MySQL 5.0 slower than 4.1?

I just installed MySQL 5.0 yesterday and ran my application that has a lot of selects with left joins. I noticed the application is running 4x-7x slower than with MySQL 4.1. Now it could be because I'm using a new my.ini file (dedicated server) and I haven't yet copied my old my.ini settings ove

Re: Trouble duplicating a mongo live table

At 11:01 AM 9/30/2006, you wrote: I have a 17,000,000 record table that I'm trying to duplicate in order to make some changes and improvements, then I'll rename it and drop the original table. So I need this duplicate to be a live table in the same database as the original. I tried the "copy tab

Re: "Keys should not both be set for column..."

On Sat, 2006-09-30 at 12:51 -0700, Brian Dunning wrote: > phpMyAdmin is giving me the following warning: > PRIMARY and INDEX keys should not both be set for column `referer` > > Here is what the table looks like: > CREATE TABLE `myspacemap_visitors_2` ( >`creation` timestamp NOT NULL default C

max_connections and max_user_connections

hi all in the mysql.user table, what is the difference between max_connections and mac_user_connections? or to put it simply, if i want each user except root to only be able to have only one connection to the server at any one time, which field should i set to 1? -- PO Box 26453 00504 Nairobi

"Keys should not both be set for column..."

phpMyAdmin is giving me the following warning: PRIMARY and INDEX keys should not both be set for column `referer` Here is what the table looks like: CREATE TABLE `myspacemap_visitors_2` ( `creation` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `lat` double NOT

Re: Low priority copy?

The problem when I try this is that the database gets locked up: INSERT INTO newtable2 SELECT * from oldtable On Sep 27, 2006, at 12:37 PM, Dan Buettner wrote: Brian, I'm not sure there's a quick way to copy 14 million records, no matter how you slice it. Disabling the indexes on the destinat

Re: Low priority copy?

Thanks Chris, this sounds great but when I read about mysqlhotcopy I didn't see a way to make it create a live table that's open within the same database, it seems to want only to create a separate backup file in some directory. On Sep 27, 2006, at 6:10 PM, Wagner, Chris (GEAE, CBTS) wrote

Trouble duplicating a mongo live table

I have a 17,000,000 record table that I'm trying to duplicate in order to make some changes and improvements, then I'll rename it and drop the original table. So I need this duplicate to be a live table in the same database as the original. I tried the "copy table" function in the Operation