MySQL的Innodb缓存相关优化
INNODB 状态的部分解释
通过 命令 SHOW STATUS LIKE 'Innodb_buffer_pool_%'
查看
Innodb缓存使用率 (Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free)/Innodb_buffer_pool_pages_total
Innodb_buffer_pool_pages_total
Innodb_buffer_pool_pages_data
Innodb_buffer_pool_pages_free
Innodb_buffer_pool_pages_misc 缓存池中当前已经被用作管理用途或HASH INDEX而不能用作为普通
Innodb 读次数 Innodb_buffer_pool_read_requests
Innodb 写次数 Innodb_buffer_pool_write_requests