mysql的innodb缓存使用率统计

show 方式去查看:
show status like '%innodb_buffer_pool_pages%';

计算方式:
(total-free)/total * %100
sql方式查看:

select VARIABLE_NAME,VARIABLE_VALUE from global_status where VARIABLE_NAME in('Innodb_buffer_pool_pages_total','Innodb_buffer_pool_pages_free');

 

posted @ 2019-08-02 17:33  tigergaonotes  阅读(1676)  评论(0编辑  收藏  举报