比较挺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

分类:FreeBSD Tags:
评论

还没有任何评论。

留下评论