InnoDB
maintains a storage area called the buffer pool for caching data and indexes in memory. Knowing how the InnoDB
buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning.
For an explanation of the inner workings of the InnoDB
buffer pool, an overview of its LRU replacement algorithm, and general configuration information, see Section 15.5.1, “Buffer Pool”.
For additional InnoDB
buffer pool configuration and tuning information, see these sections:
InnoDB
维护一个称为 buffer pool(缓冲池) 的存储区域, 用于在内存中缓存数据和索引。
学习 InnoDB
缓冲池的工作原理,并利用它的优势来将频繁访问的数据保存在内存中, 是 MySQL 调优的一个重要方面。
有关 InnoDB
缓冲池详细的内部工作原理、LRU替换算法的概述, 以及一般配置信息,请参阅 Section 15.5.1, “Buffer Pool”。
有关 InnoDB
缓冲池配置和优化的其他信息,请参阅以下部分:
- Section 15.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
- Section 15.8.3.5, “Configuring Buffer Pool Flushing”
- Section 15.8.3.3, “Making the Buffer Pool Scan Resistant”
- Section 15.8.3.2, “Configuring Multiple Buffer Pool Instances”
- Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”
- Section 15.8.3.1, “Configuring InnoDB Buffer Pool Size”