Find optimum innodb_buffer_pool_size in G for my.cnf - Cacher Snippet

7/8/2015 - 3:46 PM

Find optimum innodb_buffer_pool_size in G for my.cnf

Find optimum innodb_buffer_pool_size in G for my.cnf

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;