Re: Does InnoDB ever not cluster data by primary key?

With your auto-increment in the right-most position, it seems to me that it would tend to make your inserts non-sequential (assuming the fields to the left are not sequential) causing inserts to occur all over the tree. With the auto-increment as the first field in the key, the inserts would be go

Re: Does InnoDB ever not cluster data by primary key?

Michael, Yeah. We're trying to maximize the benefits of clustering and had to sacrifice on the length of the primary key. And we got fairly good results from query profiling using maatkit. One thing that shocked me was the overhead of random inserts primary key updates. It's definitely a tradeoff.

Does InnoDB ever not cluster data by primary key?

We have a multi-column primary key with an auto-increment column as the 3rd column in the primary key in InnoDB. Is there a requirement to have the auto-increment column as the leftmost column in the primary key in order for InnoDB to cluster by the multi-column primary key? I don't believe this to

Re: UNIQUE KEY vs UNIQUE INDEX

On 07/30/2009 02:23 PM, Joerg Bruehe wrote: Hi ! mos wrote: At 09:13 AM 7/30/2009, b wrote: Are UNIQUE KEY& UNIQUE INDEX two ways of specifying the same thing? If not, what are the differences? Feel free to tell me to RTFM but please post manual chapters. I've been looking but haven't been a

RE: Replication recovery on restart

Hi Bryan, Please define "out of whack." Tell us exactly what you're doing when you restart, and what the replication state is before and after, and where the updates are coming from. Regards, Gavin Towey -Original Message- From: Cantwell, Bryan [mailto:bcantw...@firescope.com] Sent: T

Re: UNIQUE KEY vs UNIQUE INDEX

Hi ! mos wrote: > At 09:13 AM 7/30/2009, b wrote: >> Are UNIQUE KEY & UNIQUE INDEX two ways of specifying the same thing? >> If not, what are the differences? >> >> Feel free to tell me to RTFM but please post manual chapters. I've >> been looking but haven't been able to find anything. > > They

Replication recovery on restart

I have 2 machines 'master' and 'slave'. I have the mysql 5.0.51a-log databases both replicating wonderfully. They are configured in a dual master scenario so that one can take over for the other in my HA environment I've built. All is working great until... If one or the other box reboots or the

Re: UNIQUE KEY vs UNIQUE INDEX

At 09:13 AM 7/30/2009, b wrote: Are UNIQUE KEY & UNIQUE INDEX two ways of specifying the same thing? If not, what are the differences? Feel free to tell me to RTFM but please post manual chapters. I've been looking but haven't been able to find anything. They are the same thing. If you mean

UNIQUE KEY vs UNIQUE INDEX

Are UNIQUE KEY & UNIQUE INDEX two ways of specifying the same thing? If not, what are the differences? Feel free to tell me to RTFM but please post manual chapters. I've been looking but haven't been able to find anything. -- MySQL General Mailing List For list archives: http://lists.mysql.co

INFOBRIGHT STORAGE ENGINE

Hi, Is there anybody using infobright storage engine on production. Please let me know the performance. Thanks Krishna Chandra Prajapati

MyQuery 3.0 Alpha available now

Sorry for crossposting, but I felt this might be of intrerest to both lists. MyQuery 3.0 is an interactive Windows GUI based query tool for MySQL. Among the features are> - Support running scripts from a position, up to a position of just a single query in the script, allowing you to run up to