2024-09-25
请教各位老大innodb buffer pool查询问题
mysql> show global status like 'Innodb_buffer_pool_pages%';
+----------------------------------+-------+
| Variable_name | Value |
+----------------------------------+-------+
| Innodb_buffer_pool_pages_data | 1115 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 203 |
| Innodb_buffer_pool_pages_free | 7071 |
| Innodb_buffer_pool_pages_misc | 6 |
| Innodb_buffer_pool_pages_total | 8192 |
+----------------------------------+-------+
6 rows in set (0.00 sec)
Q1.Innodb_buffer_pool_pages_flushed是什么意思?具体是哪部分page?
Q2.上面1115+203+7071+6=8395 大于total的8192
各项加起来为什么会比8192大出203?
我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
