• The page buffer provided here is in kernel space.

    此处提供page缓冲区内核空间中。

    youdao

  • 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

  • For every different page size tablespace, there should be a matching page size buffer pool.

    对于每个不同大小表空间应该存在一个页大小相匹配缓冲

    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

  • Because the root page is used so often, it always resides in the memory buffer.

    因为使用十分频繁所以它通常驻留内存缓冲区中。

    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

  • 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

  • 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

  • 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

  • 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

  • Buffer pool data writes is approximately equal to Asynchronous pool data page writes.

    缓冲数据等于异步池数据写。

    youdao

  • Buffer pool index writes is approximately equal to Asynchronous pool index page writes.

    缓冲索引等于异步池索引写。

    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

  • Create buffer pool BP 5000 page, size 16k.

    创建缓冲BP 5000个页面大小16K

    youdao

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

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

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