Buffer pool size的意思|示意

We can see from the figures that there appears to be a significant benefit to managing the buffer pool size when there's a high degree of concurrency.

从这些图可以看到，当并发性程度很高时，管理缓冲池的大小能够获得显著的性能提升。

If you set the buffer pool size too high, then system memory usage will exceed the available physical memory, causing the operating system to spend more time paging the memory.

如果缓冲池大小过大，那么内存使用会超过可用的物理内存，从而导致操作花费更多时间对内存进行分页。

If each buffer pool has an NPAGES value of -1, then the buffer pool size is being controlled through the BUFFPAGE parameter in the database configuration.

如果每个缓冲池都有一个为“- 1”的npages值，那么缓冲池大小是由数据库配置中的BUFFPAGE参数控制的。

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.

但是，如果总的缓冲区大小太大，并且没有足够的存储器可用来分配给它们，那么将为每种页大小分配最少的缓冲池，性能就会急剧下降。

Use one buffer pool, but increase its size until the index hit ratio stops increasing.

使用一个缓冲池，但是增加其大小直至索引命中率停止增长。

To determine the buffer pool size in the database, take a look at Listing 3.

为了确定数据库中的缓冲池大小，请查看清单3。