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 😉



« »

© 2020 Automation Ninja's Dojo. Theme by Anders Norén.

%d bloggers like this: