InnoDB 维护一个名为 缓冲池 的存储区域,用于在内存中缓存数据和索引。了解 InnoDB 缓冲池的工作原理,并利用它将频繁访问的数据保存在内存中,是 MySQL 调优的重要方面。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.
有关 InnoDB 缓冲池内部工作原理、其 LRU 替换算法概述以及一般配置信息,请参见 第 17.5.1 节,“缓冲池”。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 17.5.1, “Buffer Pool”.
有关额外的 InnoDB 缓冲池配置和调优信息,请参见以下章节:For additional InnoDB buffer pool
configuration and tuning information, see these sections:
第 17.8.3.4 节,“配置 InnoDB 缓冲池预取(读提前)”Section 17.8.3.4, “Configuring InnoDB Buffer Pool Prefetching (Read-Ahead)”
第 17.8.3.5 节,“配置缓冲池刷新”Section 17.8.3.5, “Configuring Buffer Pool Flushing”
第 17.8.3.3 节,“使缓冲池抗扫描”Section 17.8.3.3, “Making the Buffer Pool Scan Resistant”
第 17.8.3.2 节,“配置多个缓冲池实例”Section 17.8.3.2, “Configuring Multiple Buffer Pool Instances”
第 17.8.3.6 节,“保存和恢复缓冲池状态”Section 17.8.3.6, “Saving and Restoring the Buffer Pool State”
第 17.8.3.1 节,“配置 InnoDB 缓冲池大小”Section 17.8.3.1, “Configuring InnoDB Buffer Pool Size”