比较挺OK的my.cnf设置
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 4M
join_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 32
query_cache_size = 64M
thread_concurrency = 8
max_connections = 512
tmp_table_size = 256M
max_heap_table_size = 128M
skip-name-resolve
skip-networking
评论
还没有任何评论。
留下评论