(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