Convert Zope data to Mysql
How to Convert Zope 2.1 data to Mysql db. Have any way to convert? I want argent please. ...
mysql
PHP Retrieving data problem
Hi, I have this weird problem where PHP5 is not retrieving ints from a MySql database. This is the code I have: $db = mysql_connect('XX.XX.XX.XX', 'DBName', 'DBPwd'); $query = 'Select * FROM Users WHERE UserName = \'Carlo\''; $result = mysql_query($query); if(!$result) { echo 'Could not successfuly run query: '.mysql_error(); exi...
Database for Large number of 1kB data chunks (MySQL?)
I have a very large dataset, each item in the dataset being roughly 1kB in size. The data needs to be queried rapidly by many applications distributed over a network. The dataset has more than a million items (so 500 million+ 1kB data chunks). What would be the best method to storing this dataset (need to allow adding more items, and r...
Max number of rows per MySQL (Billions) NDBCLUSTER ?
I have a database that needs to be able to scale up to billions of entries or rows. Can this many rows be supported per single table? Is it advisable? Would a single table be split over several clusters if used in a NDBCLUSTER. Other load balancing techniques? What are some advisable methods of deploying such a database? What are be...
Load inFile Data in Mysql
I have a Text file of Size 1.5GB or around 1.3Crores of Rows. When I am Loading this text file to the Table of same structure in MYSQL, Its Loads only 62Lack records, shows 65K warnings and Finished. Whatis the reason, Why It loads only half of records??? Do I need to increase Buffer Size?? If yes then How?? or there is some other rea...
MySQL MYISAM concurrency issue with two processes
I have probably overlooked something simple, but I have been trying to understand what is going wrong here for a few weeks and I need a fresh set of eyes. I have a CGI application that processes Paypal Payment notifications. When someone subscribes I actually get a subscription IPN followed by a payment IPN. On is right behind the other...
counting non-unique rows in table with additional criteria
Hi, I have a table USERS with the following fields date(datetime) email(varchar) provider(int) event(int) I am looking for how many records there are with the same email, which occur in a specific month with a specific provider. like for provider= x and month = y i want email occurs [email protected] 5 [email protected]...
How to cache server connections behind MySQL native UDFs
The MySQL UDF system doesn't provide a good way to have long-term persistent state. I want to be able to write a function that takes the name of a server, and some other arguments, that connects to the server and sends a request, and returns the result. But connecting to the server is a heavyweight operation (much more than just opening...
In SQL, how do you get the top N rows ordered by a certain column?
I want to select the top N rows of a table, ranked by how high the number in one of their columns is. I already have: SELECT * FROM movie ORDER BY worldwide_gross DESC; How can I get the first twenty? If it makes any difference I'm using MySQL. Cheers! ...
How to count and limit record in a single query in MYSQL?
I am searching for records in a table as follows: SELECT Id, Name FROM my_table WHERE Name LIKE '%prashant%' LIMIT 0, 10; Now, I am adding LIMIT to maintain my paging. But when user searches for word 'prashant' then total records I have is 124 for 'prashant'. But as the limit applied to the query so it only fetches 10 records in my PH...
MySQL: keep column together in results?
OK when I make a request I want all the items with the same group_id to be "together" for example 117,117,134,111 is fine but 117,134,117,111 is not fine because the group_id 117 are not all "together". I hope that makes sense. The only way I know how to do achieve this is by ordering my results by group_id, but if I want to order by lik...
How to execute two mysql queries as one in PHP/MYSQL?
I have two queries, as following: SELECT SQL_CALC_FOUND_ROWS Id, Name FROM my_table WHERE Name LIKE '%prashant%' LIMIT 0, 10; SELECT FOUND_ROWS(); I want to execute both these queries in a single attempt. $result = mysql_query($query); But then tell me how I will handle each tables set separately. Actually in ASP.NET we uses datas...
Why do our queries get stuck on the state "Writing to net" in MySql?
We have a lot of queries select * from tbl_message that get stuck on the state "Writing to net". The table has 98k rows. The thing is... we aren't even executing any query like that from our application, so I guess the question is: What might be generating the query? ...and why does it get stuck on the state "writing to net" I...
How to write a null safe compare "<=>" in pure SQL?
In Mysql there is a compare operator that is a null safe: <=>. I use this in my Java program when creating prepared statements like this: String routerAddress = getSomeValue(); String sql = "SELECT * FROM ROUTERS WHERE ROUTER_ADDRESS <=> ? "; PreparedStatement stmt = connection.prepareStatement(sql); stmt.setString(1, routerAddress); ...
Selecting random entry in MySQL with WHERE clause problem
Hi all, I'm running the following code to get a random entry from a dictionary: SELECT * FROM tbl_dict WHERE 1 ORDER BY RAND() LIMIT 1 This works great, but as soon as I expand there WHERE clause the query fails. What I need is something like... SELECT * FROM tbl_dict WHERE 1 and lock='0' ORDER BY RAND() LIMIT 1 Can anyone point o...
Will a MySQL table with 20,000,000 records be fast with concurrent access?
I ran a lookup test against an indexed MySQL table containing 20,000,000 records, and according to my results, it takes 0.004 seconds to retrieve a record given an id--even when joining against another table containing 4,000 records. This was on a 3GHz dual-core machine, with only one user (me) accessing the database. Writes were also fa...
MySQL Advanced Query Brainteaser
I've been asked to create a financial report, which needs to give a total commission rate between two dates for several 'referrers'. That's the easy part. The difficult part is that the commission rate varies depending not only on the referrer but also on the type of referral and also on the number of referrals of that type that have be...
MySQL dual master
For my current project we are thinking of setting up a dual master replication topology for a geographically separated setup; one db on the us east coast and the other db in japan. I am curious if anyone has tried this and what there experience has been. Also, I am curious what my other options are for solving this problem; we are cons...
Why is mysql ignoring the 'obvious' key to use in this simple join query?
Hello. I have what I'd thought would be a simple query, but it takes 'forever'. I'm not great with SQL optimizations, so I thought I could ask you guys. Here's the query, with EXPLAIN: EXPLAIN SELECT * FROM `firms_firmphonenumber` INNER JOIN `firms_location` ON ( `firms_firmphonenumber`.`location_id` = `firms_location`....
MySQL Wildcard for "=" - is there one
So, "SELECT * FROM table WHERE col LIKE '%'" will return everything. Is there a wildcard for the query "SELECT * FROM table WHERE col = '*'"? - clearly * doesn't work, I just put it there to indicate where I'd like a wildcard. The column I'm selecting from contains an integer between 1 and 12, and I want to be able to select either all r...