Hi! On Oct 21, Phil Bitis wrote: > >From: "Sergei Golubchik" <[EMAIL PROTECTED]> > > > >But for auto_increment field (on BIGINT, I believe ?), > >you'll have hundreds of keys on one key page, so logarithm base will be > >few hundreds, and log N should be just 3-5. That is, it should be only > >~3-5 times slower as compared to the table with one hundred rows. > > Hi again, does the key page size differ depending on the type of the column > (BIGINT, INT, etc)? Is there any way I can work out the key page size, or > configure it?
It differs. No, I don't think it can be influenced. It is chosen automatically based on key length - so that longer keys get larger keypages. On the other hand, if you're thinking about new storage engine (and you're in programming, compiling MySQL, etc), you can as well modify MyISAM code to have any keypage size you like. Search in mi_create.c for "keydef->block_length=". Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]