mysql 5.1 my.cnf,我需要输入文字“ _size”吗？在MySQL 5.1的my.cnf文件中？

This is a pretty simple question about setting parameters in the my.cnf file for mysql 5.1.

This page gives me the parameters I can tune:

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

and so I think I would need to write

key_buffer_size = 256M

But when I open my current my.cnf, it has the line:

key_buffer = 16M

My question is, do I need "key_buffer_size" or "key_buffer" or does it not matter which I use? And, how would I know if something in the my.cnf is incorrect? Where's the daemon start log file?

I am running ubuntu; I think version 8.04 LTS

解决方案

The key_buffer key is deprecated.

The key_buffer_size should be used instead.

The old deprecated key existing in the configurations seems to be a bug: default my.cnf has deprecated option key_buffer.

$ mysqld --help

[Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead

The key_buffer keys seems to have been deprecated for a long time. For example, key_buffer_size has been in use all the way back as far as 4.1.

The only mention of this deprecation in the MySQL documentation, that I could find, is a reference here in the 5.7 Release Notes.