MountEtna

决定我们成为什么样的人,不是我们的能力,而是我们的选择。——阿不思·邓布利多...

【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.

该缓冲池位于主内存中,InnoDB用它来缓存被访问过的表和索引。该缓冲池使常用数据可以直接在内存中被处理,从而提升处理速度。在专用的数据库服务中,常有多达80%的物理内存被作为InnoDB的缓冲池。

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 15.6.3.1, “The InnoDB Buffer Pool”, and Section 15.6.3, “InnoDB Buffer Pool Configuration”.

更多信息,请参考15.6.3.1,“InnoDB缓冲池”,和15.6.3,“InnoDB缓冲池配置”。
阅读更多
文章标签: 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 下载

没有更多推荐了,返回首页

关闭
关闭