(1) 读取参数,
global buffer pool以及 local buffer
Innodb_buffer_pool_size,理论上越大越好,建议服务器50%~80%,实际为数据大小80%~90%即可;
Innodb_read_io_thread,根据处理器内核数决定;
Read_buffer_size;
(2) 写入参数
Insert_buffer_size;
Innodb_double_write;
innodb_flush_method
(3) 与IO相关的参数
Innodb_log_buffer_size
innodb_flush_log_at_trx_commit
innodb_file_io_threads
innodb_max_dirty_pages_pct
(4)缓存
query_cache_size
query_cache_type
binlog_cache_size