[转]Mysql MyISAM配置一则
环境:
Mysql 4.1
OS: Red hat linux
Memory: 2G
CPU : dual 2.8GHx Xeon
/etc/my.cnf
[mysqld]
...
key_buffer = 512M
max_allowed_packet = 8M
table_cache = 512
myisam_sort_buffer_size = 256M
thread_cache = 32
query_cache_size = 256M
sort_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
Mysql 4.1
OS: Red hat linux
Memory: 2G
CPU : dual 2.8GHx Xeon
/etc/my.cnf
[mysqld]
...
key_buffer = 512M
max_allowed_packet = 8M
table_cache = 512
myisam_sort_buffer_size = 256M
thread_cache = 32
query_cache_size = 256M
sort_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 16M