"Jim" <jj@stripped> 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 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
Because MyISAM is the default storage engine, I suspect.
Also take a look at the last paragraph of this page:
For information on tuning the InnoDB storage engine, see Section
14.2.11, “InnoDB Performance Tuning Tips”.
> Does this option only affect MyISAM performance, or does it also affect
> performance of operations on InnoDB tables?
key_buffer_size has nothing to do with InnoDB tables.
