Skip to content

Instantly share code, notes, and snippets.

@OpenCoderX

OpenCoderX/mysql_buffer_pool.sql

Created July 1, 2014 12:54
Show Gist options
  • Save OpenCoderX/1d9f055930959dba7a35 to your computer and use it in GitHub Desktop.
Save OpenCoderX/1d9f055930959dba7a35 to your computer and use it in GitHub Desktop.
Download ZIP
query to estimate buffer pool
Raw
mysql_buffer_pool.sql
SELECT CEILING(Total_InnoDB_Bytes*1.2/POWER(1024,3)) RIBPS FROM
(SELECT SUM(data_length+index_length) Total_InnoDB_Bytes
FROM information_schema.tables WHERE engine='InnoDB') A;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment