Automation Ninja's Dojo

Mysql – calculate InnoDB buffer pool

Recently I was investigating how big my innodb buffer pool should be. While looking for more detailed info I came across this really handy mysql query which gives in result number of GB to which you should set your innodb_buffer_pool_size

 

To query what is your current data usage you can use the following

With this knowledge you should not have any problems with tuning your mysql 😉

 

 

1 thought on “Mysql – calculate InnoDB buffer pool

Leave a Reply

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

%d bloggers like this: