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]

Reply via email to