原先MySQL運行時的CPU用量偏高,記憶體用量偏低.
故拆半給 MySQL 用為 24 GB 上限. 但運行以 MyISAM 居多, innoDB 偏少, 慢慢考慮減少 MISAM 改用 innoDB.
調整後, CPU 佔用約 6%, 佔用約 1GB RAM.
代碼: 選擇全部
max_connections=200
table_open_cache=4096
tmp_table_size=1G
thread_cache_size=64
myisam_max_sort_file_size=10G
myisam_sort_buffer_size=1G
key_buffer_size=512M
read_buffer_size=2M
read_rnd_buffer_size=4M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=4M
innodb_buffer_pool_size=2G
innodb_log_file_size=128M
innodb_thread_concurrency=4
innodb_autoextend_increment=64
innodb_buffer_pool_instances=4
innodb_concurrency_tickets=5000
innodb_old_blocks_time=1000
innodb_open_files=300
innodb_stats_on_metadata=0
innodb_file_per_table=1
innodb_checksum_algorithm=0
back_log=80
flush_time=0
join_buffer_size=256K
max_allowed_packet=64M
max_connect_errors=100
open_files_limit=4161
sort_buffer_size=8M
table_definition_cache=4096
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
適調:
innodb_log_buffer_size=4M
innodb_buffer_pool_size=2G
innodb_log_file_size=128M