• 存入高速缓冲存储器了。

    This page is cached.

    《牛津词典》

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

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

    youdao

  • 因而操作日志缓冲池中的数据操作之间存在竞争

    Thus, the read operations compete with log writing and the write operation for data pages from the buffer pool.

    youdao

  • 要求缓冲存在适当索引

    This requires the appropriate index pages to be in the buffer pool.

    youdao

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

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

    youdao

  • 这个计算考虑缓冲高速缓存所有(索引数据)。

    This calculation takes into account all of the pages (index and data) that are cached by the buffer pool.

    youdao

  • 假设一个针对非常运行查询,它使用同一个缓冲并且需要读取总的缓存大小还多

    You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.

    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

  • 如果的确上述情况,那么使用大的缓冲是最好解决办法但是索引增加更多自由空间有所帮助

    If this is the case, a larger buffer pool is the best solution, but adding more free space to index pages may also help.

    youdao

  • 如果小型拥有自己缓冲,那么它们必须拥有自己的空间因此大型查询不能覆盖它们

    If the small tables have their own buffer pool, thereby making it necessary for them to have their own table space, their pages cannot be overwritten by the large query.

    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

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

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

    youdao

  • 然而,过多地分配空余空间可能会产生浪费DASD 空间,导致每次I/O 只能传输少的数据缓冲利用效率,并且扫描更多

    However, over-allocating free space may result in wasted DASD space, less data transferred per I/O, less efficient use of buffer pools and more pages to scan.

    youdao

  • 而且DB 2空间压缩内存db2缓冲仍保持压缩。

    Furthermore, compressed pages of a DB2 table space remain compressed in the DB2 buffer pool in main memory.

    youdao

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

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

    youdao

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

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

    youdao

  • 而在其他平台上缓冲大小250个大小为4k

    For other platforms, the buffer pool size is 250 pages with a 4k pagesize.

    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

  • 可以使用新增BUFFER POOL配置参数创建dbspace大小对应缓冲

    You can also use the new BUFFERPOOL configuration parameter to create a buffer pool that corresponds to the page size of the dbspace.

    youdao

  • perl buffhitratio . pl dbrun. snap——脚本提供了每个缓冲数据索引命中率。

    Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.

    youdao

  • db 2PageCleaner (db2pclnr):相当于Oracle中的DBWR进程进程磁盘上转移BP之前清理缓冲

    Db2 page Cleaner (db2pclnr) : Equivalent to DBWR process in Oracle, this process cleans the buffer pool before pages from the disk are moved into the BP.

    youdao

  • 例如假设1Member 1读取不在本地缓冲池中的数据

    For example, assume that Member 1 in Figure 1 wants to read a data page that isn't in its local buffer pool.

    youdao

  • 新的需要读入缓冲

    A new page needs to be read into the buffer pool.

    youdao

  • 缓冲数据物理读数(以表空间单位定义)。

    Buffer pool data physical reads (defined in units of tablespace page size).

    youdao

  • 缓冲索引物理读数(以表空间单位定义)。

    Buffer pool index physical reads (defined in units of tablespace page size).

    youdao

  • 缓冲x da物理读数(以表空间单位定义)。

    Buffer pool xda physical reads (defined in units of tablespace page size).

    youdao

  • 下面例子定义了缓冲两个空间个表空间宽为4KB,另个表空间的宽为32KB(注意,一个表空间总是一个缓冲,且缓冲池要有一个匹配) 。

    The following example defines two buffer pools and two table spaces, one each with 4KB and 32KB pages. (Note that a table space always requires a buffer pool with a matching page size.)

    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

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

    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

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

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

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