MY.CNF file configuration method of MySQL performance tuning

[Mysqld]

Datadir=/var/lib/mysql

Socket=/var/lib/mysql/mysql.sock

Skip-locking

Set-variable = key_buffer=16m

Set-variable = max_allowed_packet=1m

Set-variable = thread_stack=64k

Set-variable = record_buffer=1m

Set-variable = table_cache=1024

Set-variable = sort_buffer=4m

Set-variable = net_buffer_length=8k

Set-variable = max_connect_errors=100

Set-variable = max_connections=1024

Server-id = 1

[Mysqldump]

Quick

Set-variable = max_allowed_packet=16m

[MySQL]

No-auto-rehash

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

#safe-updates

[Isamchk]

Set-variable = key_buffer=20m

Set-variable = sort_buffer=20m

[Myisamchk]

Set-variable = key_buffer=20m

Set-variable = sort_buffer=20m

[Mysqlhotcopy]

Interactive-timeout

[Mysql.server]

User=mysql

Basedir=/var/lib

[Safe_mysqld]

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

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