MySQL性能调整之my.cnf文件配置方法

MySQL性能调整之my.cnf文件配置方法

　　[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