On 1/11/07, howard chen howachen@gmail.com wrote:
- I see quite a lot fo mediawiki's tables use auto-increment as
primary key but we know that this is no good for innodb, do you guy aware of this problem?
The only reason I can think that someone would say that autoincrement is bad w/ Innodb is because innodb is always clustered on the primary key. In some applications the use of autoincrement can result in poor locality. In our usage, I don't see why autoincrement would result in any worse locality than any other choice. Also, the use of sparse primary keys w/ Innodb results in poor packing and wasted space.