Setting MySQL innodb_buffer_pool_size

I was confused how big i should set my “innodb_buffer_pool_size” value.

Then i find this post in stackexchange.

I can run this query to get what is the suggestion of “innodb_buffer_pool_size” value.

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;

The result will be in GB.

Leave a comment

Your email address will not be published. Required fields are marked *