mysql通过增加内存缓存来改善磁盘io瓶颈

 

 

[mysqld]
# InnoDB Buffer Pool Settings
innodb_buffer_pool_size = 30G
innodb_buffer_pool_instances = 8

# InnoDB Log File and Flush Settings
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 256M

# Binary Log Syncing
sync_binlog = 1000

# Temporary Table Settings
tmp_table_size = 256M
max_heap_table_size = 256M

# Sort Buffer Size
sort_buffer_size = 8M