Skip to content

Instantly share code, notes, and snippets.

@krabello

krabello/RIBPS.sql

Created September 21, 2018 18:10
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save krabello/95e74b020156d4bdc61f46b72332cd4f to your computer and use it in GitHub Desktop.
Save krabello/95e74b020156d4bdc61f46b72332cd4f to your computer and use it in GitHub Desktop.
Download ZIP
RIBPS, Recommended InnoDB Buffer Pool Size based on all InnoDB Data and Indexes with an additional 60%
Raw
RIBPS.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