Is It key_buffer or key_buffer_size?

Posted by user176890 on Server Fault See other posts from Server Fault or by user176890
Published on 2013-11-05T04:18:28Z Indexed on 2013/11/05 9:58 UTC
Read the original article Hit count: 234

Filed under:
|

I search the internet regarding the correct variable in my.cnf file. Some said that key_buffer_size is depreciated, but some said that key_buffer_size is the correct variable in my.cnf.

So, what is really the correct variable here? Is it key_buffer or key_buffer_size?

I'm using ubuntu 12.04.

And also I have the two key_buffer variable in my.cnf file. This is what I got after installing mysql.

The first one is located under this:

[mysqld]
key_buffer              = 16M

The other one is located under this:

[isamchk]
key_buffer              = 16M

© Server Fault or respective owner

Related posts about ubuntu-12.04

Related posts about mysql5.5