October 3, 2006

MySQL Optimizer and Innodb Primary Key

Posted by peter |

Innodb primary key is special in many senses and I was always wondering how well MySQL is integrated with Innodb to take advantage of these special features.

Lets see which things work and which things do not:
[read more...]

Posted by peter @ 10:07 am :: Innodb, bugs :: 9 comments
Print This Post Print This Post book mark MySQL Optimizer and Innodb Primary Key in del.icio.usdel.icio.us :: submit MySQL Optimizer and Innodb Primary Key to digg.comdigg

Long PRIMARY KEY for Innodb tables

Posted by peter |

I’ve written and spoke a lot about using short PRIMARY KEYs with Innodb tables due to the fact all other key will refer to the rows by primary key. I also recommended to use sequential primary keys so you do not end up having random primary key BTREE updates which can be very expensive.

Today I would like to share practical example when you may use long primary key with value distribution far from sequential.
[read more...]

Posted by peter @ 4:14 am :: Innodb, tips :: 6 comments
Print This Post Print This Post book mark Long PRIMARY KEY for Innodb tables in del.icio.usdel.icio.us :: submit Long PRIMARY KEY for Innodb tables to digg.comdigg