The configuration method of my.cnf file for MySQL performance adjustment

MySQL performance tuning of the My.cnf file configuration method:

[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