To see the Buffer Pool size in GB run this:

To see the Buffer Pool size in GB run this:

SELECT FORMAT(BufferPoolPages*PageSize/POWER(1024,3),2) BufferPoolDataGB FROM(SELECT variable_value BufferPoolPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_total') A,(SELECT variable_value PageSize FROM information_schema.global_status
WHERE variable_name ='Innodb_page_size') B;

Database pages 360515 This is the number of pages with data inside the Buffer Pool

To see the amount of data in the Buffer Pool size in GB run this:

SELECT FORMAT(BufferPoolPages*PageSize/POWER(1024,3),2) BufferPoolDataGB FROM(SELECT variable_value BufferPoolPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_data') A,(SELECT variable_value PageSize FROM information_schema.global_status
WHERE variable_name ='Innodb_page_size') B;

To see the percentage of the Buffer Pool in use, run this:

SELECT CONCAT(FORMAT(DataPages*100.0/TotalPages,2),' %') BufferPoolDataPercentage FROM(SELECT variable_value DataPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_data') A,(SELECT variable_value TotalPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_total') B;

Modified db pages 300 This is the number of pages in the Buffer Pool that have to be written back to the database. They are also referred to as dirty pages.

To see the Space Taken Up by Dirty Pages, run this:

SELECT FORMAT(DirtyPages*PageSize/POWER(1024,3),2) BufferPoolDirtyGB FROM(SELECT variable_value DirtyPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_dirty') A,(SELECT variable_value PageSize FROM information_schema.global_status
WHERE variable_name ='Innodb_page_size') B;

To see the Percentage of Dirty Pages, run this:

SELECT CONCAT(FORMAT(DirtyPages*100.0/TotalPages,2),' %') BufferPoolDirtyPercentage FROM(SELECT variable_value DirtyPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_dirty') A,(SELECT variable_value TotalPages FROM information_schema.global_status
WHERE variable_name ='Innodb_buffer_pool_pages_total') B;

As for the other things in the display, run this:

SHOW GLOBAL STATUS LIKE'Innodb_buffer_pool%';
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值