Leveraging buffering and caching
This section focuses on using buffering and caching techniques to increase the performance.
InnoDB buffer pool optimization
The InnoDB storage engine maintains a storage area known as the buffer pool. It is used for caching data and indexes in the memory. It is important to know how the InnoDB buffer pool works, so as to take advantage of it to keep frequently accessed data in memory. It is an important aspect of MySQL tuning.
The following are the general guidelines for improving performance with the InnoDB buffer pool:
- In an ideal case, the size of the buffer pool should be set large enough, while leaving enough memory for other processes on the server to run without excessive paging. With larger buffer pools, more
InnoDBfunctions, like an in-memory database. In this case, it reads data from the disk once, and then accesses the data from memory in subsequent reads. - We can consider splitting the buffer pool into many parts for 64-bit systems with large memory...
