[MySQL] my.cnf optimizer problem

supergag

key_buffer = RAM/4
max_allowed_packet = 16M
table_cache = RAM
sort_buffer_size = (1M per 1G RAM)
read_buffer_size = (1M per 1G RAM)
read_rnd_buffer_size = (4M per 1G RAM)
thread_cache_size = 128

我上網搵到教話咁樣改個my.cnf wo, 我想問下跟佢做岩唔岩既, 唔知重有無其他野要改呢..?

我部server係行centos, cp同directadmin, mysql v5.0

JackWu

嘩, cp + DA

YuiNarusawa

sort_buffer_size = (1M per 1G RAM)
read_buffer_size = (1M per 1G RAM)
read_rnd_buffer_size = (4M per 1G RAM)
thread_cache_size = 128

呢4個係per thread的, 即係你開得多Thread就用得越多
keybuffer唔洗咁大...1G RAM /4 都256MB...邊有咁多index
反而query cache可以加大d,如果係website ,select statement用量比insert/update/delete高好多倍的話
query cache係可以加快好多, 不過MyISAM only

query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1

table_cache一定唔係RAM size..呢個係控制file open數量, 多用 "max connection count" x "join table count"
通訊都係幾百到一二千左右


唔用innonDB可以加
skip-innodb

[ 本帖最後由 YuiNarusawa 於 2008-11-25 02:46 編輯 ]