Skip to content

Instantly share code, notes, and snippets.

@juniorplenty

juniorplenty/Innodb Buffer Pool Usage %

Created August 28, 2014 17:31
Show Gist options
  • Save juniorplenty/ddb00710fc318f7e58ab to your computer and use it in GitHub Desktop.
Save juniorplenty/ddb00710fc318f7e58ab to your computer and use it in GitHub Desktop.
Download ZIP
Mysql-Fu
Raw
Innodb Buffer Pool Usage %
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment