pack_keys

[pablovicente]

from the manual about pack_keys:

"Set this to 1 if you want to have a smaller index. This usually makes updates slower and reads faster (MyISAM, ISAM). Setting this to 0 will disable all packing of keys. Setting this to DEFAULT (MySQL 4.0) will tell the table handler to only pack long CHAR/VARCHAR columns. "

In the manual when they say updates they refer to the update command or to updates, insert, delete?

Thanks.

[mattuu]

I believe they mean all of the above. When you pack keys, you get slower inserts, updates, deletes, or anything that modifies the table, but you get faster select performance. You may not take the performance hit if no changes occur to your keys -- say you only have 1 table with a single primary key, and you UPDATE a row, I doubt packed keys would be an issue. But anything that changes the indexing, like insertion or removal of a row, would then hit you.

[pablovicente]

Thanks i would look for my indexes and give it a try.