【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缓冲池配置”。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值