这一页存入高速缓冲存储器了。
这意味着它们将使用相同的页宽并在同一个缓冲池中进行缓冲。
This means they use the same page size and are buffered in the same buffer pool.
因而,读操作与日志写和缓冲池中的数据页的写操作之间存在竞争。
Thus, the read operations compete with log writing and the write operation for data pages from the buffer pool.
这要求在缓冲池中存在适当的索引页。
This requires the appropriate index pages to be in the buffer pool.
在具有大缓冲池的环境下,也可能需要配置较多的页清除程序。
Environments with large buffer pools may also require more page cleaners to be configured.
这个计算考虑了缓冲池高速缓存的所有页(索引和数据)。
This calculation takes into account all of the pages (index and data) that are cached by the buffer pool.
假设有一个针对非常大的表运行的查询,它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
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.
缓冲池是内存中的一块存储区域,用于临时读入和更改数据库页(包含表行或索引项)。
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.
如果的确是上述情况,那么使用更大的缓冲池是最好的解决办法,但是为索引页增加更多的自由空间也有所帮助。
If this is the case, a larger buffer pool is the best solution, but adding more free space to index pages may also help.
如果小型表拥有自己的缓冲池,那么它们就必须拥有自己的表空间,因此大型查询就不能覆盖它们的页。
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.
更少的缓冲池和表空间,以及更少的页宽种类,可以导致更简单的物理数据库设计,从而更容易管理、维护和调优。
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.
请注意,缓冲池和表空间的页大小都是8K,两者是相同的。
Note that the page sizes of 8K for the buffer pool and table space are the same.
然而,过多地分配空余空间可能会产生浪费的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.
而且DB 2表空间的压缩页在主内存的db2缓冲池中仍保持压缩。
Furthermore, compressed pages of a DB2 table space remain compressed in the DB2 buffer pool in main memory.
缓冲池数据写远远大于异步池数据页写。
Buffer pool data writes is much greater than Asynchronous pool data page writes.
缓冲池索引写远远大于异步池索引页写。
Buffer pool index writes is much greater than Asynchronous pool index page writes.
而在其他平台上,缓冲池大小为250个页大小为4k的页。
For other platforms, the buffer pool size is 250 pages with a 4k pagesize.
缓冲池数据写约等于异步池数据页写。
Buffer pool data writes is approximately equal to Asynchronous pool data page writes.
缓冲池索引写约等于异步池索引页写。
Buffer pool index writes is approximately equal to Asynchronous pool index page writes.
也可以使用新增的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.
perl buffhitratio . pl dbrun. snap——该脚本提供了每个缓冲池的数据和索引页命中率。
Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.
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.
例如,假设图1中Member 1要读取不在它本地缓冲池中的数据页。
For example, assume that Member 1 in Figure 1 wants to read a data page that isn't in its local buffer pool.
新的页需要被读入缓冲池。
缓冲池数据物理读数(以表空间页宽为单位定义)。
Buffer pool data physical reads (defined in units of tablespace page size).
缓冲池索引物理读数(以表空间页宽为单位定义)。
Buffer pool index physical reads (defined in units of tablespace page size).
缓冲池x da物理读数(以表空间页宽为单位定义)。
Buffer pool xda physical reads (defined in units of tablespace page size).
下面的例子定义了两个缓冲池和两个表空间,一个表空间的页宽为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.)
相反,表的页宽是由相应的缓冲池的页宽来确定的,这个缓冲池也就是为包含该表的表空间所指定的缓冲池。
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.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
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.
应用推荐