Re: key_buffer_size and InnoDB tables

2007-04-12 Thread Ding Deng
"Jim" <[EMAIL PROTECTED]> writes: > On the following page and in the example ini files installed with MySQL > it's suggested that key_buffer_size is an option that affects MyISAM > performance. > > http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html > > But on the following page ab

key_buffer_size and InnoDB tables

2007-04-12 Thread Jim
On the following page and in the example ini files installed with MySQL it's suggested that key_buffer_size is an option that affects MyISAM performance. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html But on the following page about tuning MySQL server parameters, it says

Re: key_buffer_size and INNODB

2004-04-19 Thread Paul DuBois
At 9:45 -0700 4/19/04, Emmett Bishop wrote: Is the key_buffer_size server variable useful for tuning databases that only have innodb tables or do I need to use the innodb_buffer_pool_size variable for this? The buffer controlled by key_buffer_size is used only for MyISAM and ISAM tables. -- Paul Du

key_buffer_size and INNODB

2004-04-19 Thread Emmett Bishop
Is the key_buffer_size server variable useful for tuning databases that only have innodb tables or do I need to use the innodb_buffer_pool_size variable for this? Thx, Tripp __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital print