List:General Discussion« Previous MessageNext Message »
From:Jim Date:April 13 2007 5:24am
Subject:key_buffer_size and InnoDB tables
View as plain text  
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 
"When tuning a MySQL server, the two most important variables to configure 
are key_buffer_size and table_cache", with no mention of its applicability 
to MyISAM or other types of tables.

http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html


Does this option only affect MyISAM performance, or does it also affect 
performance of operations on InnoDB tables? 

Thread
key_buffer_size and InnoDB tablesJim13 Apr
  • Re: key_buffer_size and InnoDB tablesDing Deng13 Apr