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 😉




One Comment

Leave a Reply

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