【MySQL 5.7 Reference Manual】15.4.1 Buffer Pool(缓冲池)

15.4.1 Buffer Pool(缓冲池)

The buffer pool is an area in main memory where InnoDB caches table and index data as data is accessed. The buffer pool allows frequently used data to be processed directly from memory, which speeds up processing. On dedicated database servers, up to 80% of physical memory is often assigned to the InnoDB buffer pool.


For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. For efficiency of cache management, the buffer pool is implemented as a linked list of pages; data that is rarely used is aged out of the cache, using a variation of the LRU algorithm.

出于对大量读操作的性能考虑 ,缓冲池被按页划分,从而可以做到同时处理多行记录。出于对缓存管理的性能考虑,缓冲池被设计为通过链表串联的多个页;不常用的数据会被过期并移出缓存,使用的是一个LRU算法的变种。

For more information, see Section, “The InnoDB Buffer Pool”, and Section 15.6.3, “InnoDB Buffer Pool Configuration”.

文章标签: mysql
个人分类: Mysql
上一篇【MySQL 5.7 Reference Manual】15.4 InnoDB Architecture(InnoDB架构)
下一篇【MySQL 5.7 Reference Manual】15.4.2 Change Buffer(变更缓冲)
想对作者说点什么? 我来说一句

MySQL 5.7 Reference Manual

2015年02月25日 24.76MB 下载