Advanced MySQL 8

The InnoDB buffer pool

The first variable that we intuitively use in our optimization is innodb_buffer_pool_size. You may think that, by increasing the value of this variable, we will have higher performance. I am going to disappoint you by telling you that it is not by increasing its value that will get you higher performance.

In fact, the acceptable maximum that you can allocate is 80% of the size of your RAM; you must keep a minimum of 20% for the operating system. From a good-practice point of view, when we start with MySQL, it is recommended to use 60% and increase by 5% over time if we need to. But before changing the value of the innodb_buffer_pool_size variable, you need to know who the users of your RAM memory are. In a typical MySQL ...