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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access