• 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

  • 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

  • You can use the snapshot report to derive information such as the buffer pool hit ratio, amount of sort heap overflows, and the system workload.

    可以使用快照获得诸如缓冲命中率排序溢出次数以及系统工作负载之类的信息

    youdao

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

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

    youdao

  • This finding demonstrates the effect of concurrent transactions on the buffer pool and how changes in the buffer pool affect server performance.

    这个结果演示并发事务缓冲影响以及缓冲池大小如何影响服务器的性能。

    youdao

  • Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.

    应用程序语句堆、缓冲临时表空间这些区域中的本地处理调优联邦系统

    youdao

  • A buffer pool is an area of storage in memory into which database pages (containing table rows or index entries) are temporarily read and changed.

    缓冲内存中的一块存储区域,用于临时读入更改数据库(包含索引)。

    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

  • 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

  • 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

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

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

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