计算innodb_buffer_pool使用率
发布时间:2020-08-18 23:57:02
来源:ITPUB博客
阅读:136
作者:StevenBeijing
两种方法:
一、通过show status
mysql> show status like 'innodb_buffer_pool_pages_data';
+-------------------------------+---------+
| Variable_name | Value |
+-------------------------------+---------+
| Innodb_buffer_pool_pages_data | 3226366 |
+-------------------------------+---------+
1 row in set (0.00 sec)
mysql> show status like 'innodb_buffer_pool_pages_total';
+--------------------------------+---------+
| Variable_name | Value |
+--------------------------------+---------+
| Innodb_buffer_pool_pages_total | 3244032 |
+---------------------------