On 1/11/07, howard chen <howachen(a)gmail.com> wrote:
1. 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.