MySQL performance adjustment-how to configure the my. cnf file _ MySQL

MySQL performance adjustment-my. cnf file configuration method-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