(1) 读取参数,global buffer pool以及 local buffer
Innodb_buffer_pool_size,理论上越大越好,建议服务器50%~80%,实际为数据大小80%~90%即可;
Innodb_read_io_thread,根据处理器内核数决定;
Read_buffer_size;
Sort_buffer_size
(2) 写入参数
Insert_buffer_size;
Innodb_double_write;
Innodb_write_io_thread
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)缓存参数以及缓存的适用场景