我们有一个大小为150GB的数据库,使用MySQL 5.0.45运行MyISAM表,其中有一些大表超过5GB,并且索引占用2GB。服务器配置如下:
8GB内存
双核3.2GHz - 启用超线程
单个RAID 5 - SCSI
1gb网卡
64位操作系统
以下是我们的my.cnf文件:
以下是我们的my.cnf文件:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
log=/var/log/mysqld.log
log-slow-queries=/var/log/mysqld-slow.log
set-variable=long_query_time=2
set-variable=sql_mode=ANSI_QUOTES
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
max_connections = 100
key_buffer = 384M
max_allowed_packet = 16M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
thread_concurrency = 3
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
非常感谢您提供的建议,以提高查询性能(80%读取/20%写入)。 谢谢, 大卫