MySQL Forge

Resources for the MySQL Community

KeyBufferSize

Contents 1 key_buffer_size Server Variable 1.1 Purpose 1.2 Usage 1.3 Notes

[edit] key_buffer_size Server Variable

[edit] Purpose

Controls the amount of memory allocated to the MyISAM index key cache

This server variable is global and pertains to MyISAM tables only

[edit] Usage

In your my.cnf file, under the [mysql.server] configuration section (or the [mysqld] section prior to MySQL 5.1), place the following:

key_buffer_size=128M

[edit] Notes

Remember that the mysql system database is composed of MyISAM tables, so even if your application tables use only non-MyISAM storage engines, you still need to keep a minimal value in key_buffer_size