Increase the buffer pool size.
增加缓冲池大小。
Increase the buffer pool size online as follows.
联机增加缓冲池大小,如下。
For other platforms, the buffer pool size is 250 pages with a 4k pagesize.
而在其他平台上,缓冲池大小为250个页大小为4k的页。
To determine the buffer pool size in the database, take a look at Listing 3.
为了确定数据库中的缓冲池大小,请查看清单3。
To determine whether the BUFFPAGE parameter is in use for buffer pool size of database, run.
要确定数据库的缓冲池大小是否由BUFFPAGE参数所决定,请运行。
What happens if you increase the buffer pool size to 20,000 4K pages and run PERFORMER again?
如果将缓冲池大小增加到 20,000 个4K页面并重新运行 PERFORMER,那将会发生什么情况呢?
We recommend you keep increasing the buffer pool size until you see diminishing improvements.
我们建议您不断增加缓冲池大小,直到看到不再有性能提高。
Another configuration parameter that dramatically affects performance is the database buffer pool size.
另一个极大影响性能的配置参数是数据库缓冲池大小。
(buffer pool size in the db2exfmt output is discussed further in the buffer pool size section below.).
db 2 exfmt输出中的缓冲池大小将在下面的缓冲池大小一节中进行进一步的讨论。
With the buffer pool size of 250 pages, the application test run experienced very poor buffer pool hit ratio of 48.69%.
通过250个页面的缓冲池大小,应用程序测试运行呈现了48.69%的糟糕的缓冲池命中率。
This makes it easier to update and report the buffer pool size along with other DB2 database configuration parameters.
这使得更新和报告缓冲池大小以及其它DB 2数据库配置参数变得更加方便。
In an actual production configuration, we would expect that the NSF Buffer Pool Size value would be set to a higher value.
在实际的产品配置中,我们期望nsfBuffer Pool size值应该设置为一个比较大的值。
The figures that follow show the effect of buffer pool size when the amount of concurrency was increased with smaller databases.
下图演示当小型数据库的并发性上升时,缓冲池的大小产生的影响。
When NPAGES has value of -1, the buffer pool size is determined by the BUFFPAGE parameter in the database configuration. For example.
当NPAGES的值为-1时,缓冲池大小就是由数据库配置中的BUFFPAGE参数确定的。
Our second hypothesis was that specifying the buffer pool size affects memory utilization differently at various user loads (Test Case #2).
我们的第二个假设是指定缓冲池大小对内存利用率的影响因用户负载不同而不同(测试案例 #2)。
If your system has a low buffer pool hit ratio, you can increase the buffer pool size further to achieve better application performance result.
如果您的系统具有较低的缓冲池命中率,您就可以通过增加缓冲池大小来进一步地取得更好的应用程序性能结果。
After making sure that you can use the BUFFPAGE parameter in the database configuration to control the buffer pool size, set it to a proper value.
确保可以使用数据库配置中的BUFFPAGE参数来控制缓冲池大小之后,将该参数设置成合适的值。
Thus, raising the Buffer Pool Size reduces the effectiveness and overall performance of your Domino server, configured with lower amounts of RAM.
因此,对于配备了较小的RAM的Domino服务器,增大缓冲池大小会降低其效率和总体性能。
The db2fopt command tells the optimizer to use the specified value for "buffer pool size," rather than adding up the pages of the buffer pools available.
db 2 fopt命令告诉优化器为“缓冲池大小(Buffer pool size)”使用指定的值,而非将可用缓冲池变量的页面加起来。
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参数控制的。
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.
从这些图可以看到,当并发性程度很高时,管理缓冲池的大小能够获得显著的性能提升。
This is important information for you, as an administrator, because you control the buffer pool size specification and you can decide what size to specify.
这些信息对您很重要,因为作为一名管理员,您要控制缓冲池大小规格和决定要指定的缓冲池大小。
In fact, depending on the type of SQL performed by your application, increasing the buffer pool size over a certain limit may not improve performance any further.
实际上,取决于应用程序所执行的SQL的类型,将缓冲池的大小增加到某个极限之后就可能不会再提高性能了。
To take advantage of the increased buffer pool, you must rebind the applications for the optimizer to consider the buffer pool size when deciding its access strategy.
要利用增加的缓冲池,您必须重新绑定应用程序,以使优化器在决定其访问策略时考虑缓冲池大小。
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 there are table Spaces with different page sizes, there must be at least one buffer pool per page size.
如果有一些具有不同页大小的表空间,那么每种页大小必须至少有一个缓冲池。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池,但是增加其大小直至索引命中率停止增长。
For every different page size tablespace, there should be a matching page size buffer pool.
对于每个不同页大小的表空间,应该存在一个页大小相匹配的缓冲池。
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.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
This gives you the ability to choose any page size you want, and still maintain a single buffer pool and uniform page size across the database.
这使得您可以选择需要的任何页面大小,并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
应用推荐