转载本站文章请注明:
转载来至：[记录与PHP的PK经历]
本文链接: mysql优化脚本！


[mysqld]
#port = 3306
#socket = /tmp/mysql.sock
#socket = /var/lib/mysql/mysql.sock
#skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
net_buffer_length = 16K
myisam_sort_buffer_size = 1M
max_connections=120
#addnew config
wait_timeout =120
back_log=100
read_buffer_size = 1M
thread_cache=32
#skip-innodb
#skip-bdb
#skip-name-resolve
join_buffer_size=512k
query_cache_size = 64M
interactive_timeout=120
long_query_time=10
log_slow_queries= /usr/local/mysql/slow_query.log
query_cache_type= 1
# Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 4