Skip to content

Instantly share code, notes, and snippets.

@OdinsHat

OdinsHat/innodb_buffer_pool_size.sql

Created July 8, 2015 15:46
Show Gist options
  • Save OdinsHat/9c01e89e6a4d19b7e73d to your computer and use it in GitHub Desktop.
Save OdinsHat/9c01e89e6a4d19b7e73d to your computer and use it in GitHub Desktop.
Download ZIP
Find optimum innodb_buffer_pool_size in G for my.cnf
Raw
innodb_buffer_pool_size.sql
SELECT CEILING(Total_InnoDB_Bytes*1.6/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