但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
However, if the total buffer size is too large, and there is not enough storage to allocate them, a minimum system buffer pool for each page size is allocated, and performance is sharply reduced.
与其他内存缓冲区相比,缓冲池对数据库性能的影响最为显著。
Compared to other memory buffers, buffer pools have the most significant impact on database performance.
拥有多个缓冲池可以将数据保存在缓冲区中。
Having more than one buffer pool can preserve data in the buffers.
缓冲池调优的目标是帮助DB 2尽可能好地利用可用于缓冲区的内存。
The goal of buffer pool tuning is to help DB2 make the best possible use of the memory available for buffers.
本文针对数据库管理系统中缓冲区的特殊重要地位,介绍了多缓冲池的配置及自调优的概念。
This paper introduces the concept of configuring and self-tuning multiple buffer pools according to the specialty of the buffer area in DBMS.
在此之后已确定,接收缓冲区的大小是临时设置为2的幂,而设置缓冲区的数目等于其余池的大小由该接收缓冲区的大小划分。
After this has been determined, the receive buffer size is provisionally set to a power of 2, and the number of buffers is set equal to the remaining pool size divided by this receiver buffer size.
在此之后已确定,接收缓冲区的大小是临时设置为2的幂,而设置缓冲区的数目等于其余池的大小由该接收缓冲区的大小划分。
After this has been determined, the receive buffer size is provisionally set to a power of 2, and the number of buffers is set equal to the remaining pool size divided by this receiver buffer size.
应用推荐