星期二, 一月 18, 2005

MySQLD Tuning 参数配置.

/etc/my.cnf 配置

skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 1024
sort_buffer_size = 8M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
set-variable = max_connections=500
thread_concurrency = 8