• This means that DB2 fetches every data page in the table space sequentially into the buffer pool.

    意味着DB2按顺序空间上提取每一个数据页面缓冲

    youdao

  • This means they use the same page size and are buffered in the same buffer pool.

    意味着它们将使用相同同一个缓冲池中进行缓冲。

    youdao

  • Environments with large buffer pools might also require more page cleaners to be configured.

    具有大型缓冲环境可能需要配置更多页面清洗器

    youdao

  • If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.

    如果一些具有不同大小空间那么每种大小必须至少一个缓冲

    youdao

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

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

    youdao

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

    使得可以选择需要任何页面大小并且整个数据库仍然维护缓冲统一的页面大小。

    youdao

  • Requests for subsequent rows on that page are filled from the buffer until all the rows on that page are processed.

    该页的后续行的请求都可以这个缓冲区中得到满足直到将该页上的所有行都处理完为止。

    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

  • A data page also remains compressed in the DB2 buffer pool there by allowing more data to be cached in memory for potential reuse.

    db2缓冲池中数据页面保持压缩的,为了潜在的重用允许更多的数据存在内存

    youdao

  • If rows are accessed randomly, then the smaller page size enables DB2 to make better use of the buffer, because more pages fit into the same storage area.

    如果随机访问那么较小大小db2可以更好地利用缓冲区因为同样存储区域可以容纳更多

    youdao

  • For a database that has table Spaces of more than one page size, additional buffer pools with matching page sizes need to be created.

    对于具有大于页面大小空间数据库而言,需要创建具有匹配页面大小的附加缓冲

    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

  • When you create a database with a uniform page size, only one buffer pool to match this page size is required (even if it isn't a 4 KB).

    统一页面大小创建数据库需要一个匹配页面大小的缓冲(即使不是4KB)。

    youdao

  • Environments with large buffer pools may also require more page cleaners to be configured.

    在具有缓冲环境下可能需要配置较多的清除程序

    youdao

  • Buffer pool index writes is much greater than Asynchronous pool index page writes.

    缓冲索引远远大于异步池索引写。

    youdao

  • Buffer pool data writes is much greater than Asynchronous pool data page writes.

    缓冲数据远远大于异步池数据写。

    youdao

  • The hit ratios for data and index pages reflect the number of times a page request was handled by the buffer pool directly without requiring disk I/O.

    数据索引页面击中反映缓冲需要磁盘I/O情况下直接处理一个页面请求时间

    youdao

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

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

    youdao

  • The more page requests that can be satisfied by a buffer pool, the better query performance will be.

    一个缓冲满足页面请求越多得到高的查询性能

    youdao

  • Fewer buffer pools and table Spaces and fewer distinct page sizes lead to a simpler physical database design which is easier to manage, maintain, and tune.

    缓冲空间以及更少的种类,可以导致更简单物理数据库设计从而容易管理维护调优

    youdao

  • These page cleaners write changed pages from the buffer pool to disk before the space in the buffer pool is required by a database agent.

    数据库代理程序需要缓冲中的空间之前这些清除程序将缓冲池中已更改写到磁盘

    youdao

  • You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.

    必须根据想要页面大小选择一个缓冲名称通过- ALTERBUFFER POOL命令激活

    youdao

  • For example, if you create a new database with an 8 KB page size, the default buffer pool for all the table Spaces will be 8 KB.

    例如如果8KB页面大小创建一个新的数据库,那么所有空间默认缓冲8 KB。

    youdao

  • For these reasons, a default buffer pool is created that supports a 4 KB page when a new database is created in DB2.

    出于这些理由DB 2中创建新数据库会创建一个支持4KB页面的默认缓冲

    youdao

  • Pagination is the process of breaking a single page into multiple pages in order to fit the page size within acceptable limits of the device buffer.

    分页为了使页面大小适合设备缓冲可接受限制而将单个页面分解多个页面过程

    youdao

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

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

    youdao

  • Every vertical blank, the hypervisor DMAs this buffer to the GPU memory, and then flips the GPU's visible page to the new data synchronously with the vertical blank signal.

    对于垂直方向上的每个空格来说,管理程序都会采用 DMA 方式将自己的缓冲区GPU内存中然后将 GPU可视刷新为垂直空格信号同步数据

    youdao

  • Page cleaners, on the other hand, write changed pages from the buffer pool to disk before the space in the buffer pool is required by a database agent.

    一方面,数据库代理需要缓冲中的空间之前页面清洗器将已修改页面缓冲池写入磁盘

    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

  • Four small buffer pools of page size 4k, 8k, 16k and 32k are allocated when a database is started.

    数据库启动分配4分别为4k8 K、16k32 K小型缓冲

    youdao

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

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

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