Geek Answers Handbook

Do I need the text "_size" in my.cnf for mysql 5.1?

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

This page gives me parameters that I can configure: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html and so I think I will need to write

key_buffer_size = 256M

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

key_buffer = 16M

My question is: do I need "key_buffer_size" or "key_buffer" or does it not matter what I use? And, how would I know if something in my.cnf is wrong? Where does the daemon run the log file?

I am running ubuntu; I think version 8.04 LTS

0
source share
2 answers

key_buffer .

key_buffer_size.

, , , : default my.cnf key_buffer.

$ mysqld --help

[] key_buffer key_buffer_size .

key_buffer, , . , key_buffer_size , 4.1.

MySQL, , - , 5.7 .

+1

MySQL 5.1 5.0 "KEY_BUFFER_SIZE":

MySQL 5.0 | MySQL 5.1

+1

More articles:


All Articles