MySQL的Innodb缓存相关优化

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

原文地址:https://www.cnblogs.com/jing1617/p/7281840.html