MySQL performance adjustment-my. cnf file configuration method

[Mysqld]

Datadir =/var/lib/mysql

Socket =/var/lib/mysql. sock

Skip-locking

Set-variable = key_buffer = 16 M

Set-variable = max_allowed_packet = 1 M

Set-variable = thread_stack = 64 K

Set-variable = record_buffer = 1 M

Set-variable = table_cache = 1024

Set-variable = sort_buffer = 4 M

Set-variable = net_buffer_length = 8 K

Set-variable = max_connect_errorrs = 100

Set-variable = max_connections = 1024

Server-id = 1

[Mysqldump]

Quick

Set-variable = max_allowed_packet = 16 M

[Mysql]

No-auto-rehash

# Remove the next comment character if you are not familiar with SQL

# Safe-updates

[Isamchk]

Set-variable = key_buffer = 20 M

Set-variable = sort_buffer = 20 M

[Myisamchk]

Set-variable = key_buffer = 20 M

Set-variable = sort_buffer = 20 M

[Mysqlhotcopy]

Interactive-timeout

[Mysql. server]

User = mysql

Basedir =/var/lib

[Safe_mysqld]

Err-log =/var/log/mysqld. log

Pid-file =/var/run/mysqld. pid