匿名投稿
投稿指南
RSS订阅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 |
|
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 |