• The accounting reports show the number of GETPAGES and synchronous reads per buffer pool.

    会计报表显示对应于每个缓冲GETPAGES同步数量

    youdao

  • Database records are read and updated in the buffer pool area of memory.

    数据库记录内存缓冲区域里被读取更新

    youdao

  • The purpose of the buffer pool is to improve database system performance.

    缓冲用途为了提高数据库系统性能

    youdao

  • Subsequent users may often find some of these resources in the buffer pool.

    随后的用户则常常可以发现有些资源已经缓冲中。

    youdao

  • This provides a means to exploit the various thresholds to favor certain types of data access within a buffer pool.

    利用各种阈值处理缓冲某些类型数据访问提供了一种方法

    youdao

  • Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.

    内存影响客户端连接数量缓冲大小以及服务器分配数据库缓存的大小。

    youdao

  • Rather, the page size for tables is determined by the page size of the buffer pool to which the table space containing the table is assigned.

    相反由相应缓冲的页宽确定的,这个缓冲池也就是为包含该表空间所指定的缓冲池。

    youdao

  • Buffer pool occupies the largest part of resident portion.

    缓冲占用了常驻区中最大部分

    youdao

  • Information about system configuration can include the size of the buffer pool, the sort heap, and more.

    关于系统配置信息包括缓冲大小排序的大小等等。

    youdao

  • This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.

    这个参数决定缓冲阈值百分比,当脏页达到这个百分比时,就启动清除

    youdao

  • With the bigger buffer pool of 12000 4k pages, the performance result improves from 43 completed transactions per 10 seconds to 66 completed transactions, as shown in Figure 4.

    通过12000个4K页面更大缓冲性能结果10完成43个事务增加完成66个事务,如图4中所示。

    youdao

  • For applications that only use one buffer pool, change NPAGES to -1 so that BUFFPAGE controls the size of the buffer pool.

    对于使用一个缓冲应用程序,将NPAGES更改成-1这样BUFFPAGE就可以控制缓冲池的大小

    youdao

  • A database must have at least one buffer pool, and can have a number of buffer pools depending on the workload characteristics, database page sizes used in the database, etc.

    数据库必须至少缓冲并且可以多个缓冲,这要工作负载特征、数据库使用的数据库页面大小等因素而定。

    youdao

  • The designation of buffer pool sizes is dependent upon the amount of storage (both central and expanded) that is available.

    缓冲大小指定取决于可用存储(包括中央存储扩展存储)的容量。

    youdao

  • Most notably is the change of the size of the default buffer pool.

    值得注意是对缺省缓冲大小修改

    youdao

  • This setting controls the size of the NSF buffer pool, a section of memory dedicated to buffering I/O transfers between the NIF indexing functions and disk storage.

    这个设置控制NSF缓冲大小,后者是用于缓冲NIF索引函数磁盘存储之间I/O传输一部分内存

    youdao

  • A database must have at least one buffer pool, and can have a number of buffer pools depending on such things as the workload characteristics and database page sizes used in the database.

    数据库必须至少缓冲并且可以多个缓冲,具体要工作负载的特征、数据库使用数据库页面大小因素而定。

    youdao

  • The above example shows a good buffer pool hit ratio of 98.4%.

    以上示例显示了98.4%的良好缓冲命中率

    youdao

  • 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%的糟糕缓冲池命中率

    youdao

  • During the test run, the actual amount of buffer pool used did not exceed 1 GB, even though the amount that the server could use was significantly above that.

    测试运行期间实际使用缓冲超过1GB尽管服务器可以使用大小远远超过这个数值。

    youdao

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

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

    youdao

  • The figures that follow show the effect of buffer pool size when the amount of concurrency was increased with smaller databases.

    下图演示小型数据库并发性上升时,缓冲大小产生影响。

    youdao

  • For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.

    例如页面大小8kb空间只能使用页面大小为8kb的缓冲

    youdao

  • If the hit ratio is low, increasing the number of buffer pool pages may improve performance.

    如果命中率低,则可以增加缓冲页数来提高性能。

    youdao

  • Note that the page sizes of 8K for the buffer pool and table space are the same.

    注意缓冲空间大小8K,两者是相同的。

    youdao

  • When multiple buffer pools are in use, the buffer pool snapshot data can be used to calculate the buffer pool hit ratio of each pool to indicate the effectiveness of each buffer pool.

    多个缓冲同时用时,缓冲快照数据用于计算每个缓冲池命中率表示每个缓冲池的有效性

    youdao

  • The goal of buffer pool tuning is to help DB2 make the best possible use of the memory available for buffers.

    缓冲调优目标帮助DB 2尽可能好地利用用于缓冲区内存

    youdao

  • Thus the number of concurrent transactions was relatively low. Because of that, the net effect of having more buffer pool was limited.

    因此并发事务比较又进一步限制更大缓冲实际影响

    youdao

  • It is mentioned earlier that ESTORE is used to extend the size of a buffer pool.

    前面提到,ESTORE用于扩展缓冲大小

    youdao

  • Number of pages prefetched into the buffer pool, but never read.

    预抓取缓冲从未读取页面数量

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定