因为根页使用十分频繁,所以它通常驻留在内存缓冲区中。
Because the root page is used so often, it always resides in the memory buffer.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
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.
要求磁盘I/O 的事务,例如刷新缓冲池中的脏页或者刷新日志缓冲区中的日志,可能需要等待。
Transactions requiring disk I/O, such as flushing dirty pages from the buffer pool or flushing logs from the log buffer, may wait.
数据和索引页被从DASD中读出之后,便进入这些插槽,并留在其中,直到DB 2缓冲区管理器确定那些插槽要用于其他数据。
After being read in from DASD, the data and index pages go into these slots and remain there until the DB2 buffer manager determines that those slots should be used for some other data.
如果随机访问行,那么较小的页大小让db2可以更好地利用缓冲区,因为同样的存储区域可以容纳更多页。
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.
换言之,在后续数据页被读入内存并被处理之前,它们可能已经从缓冲区中删除,并写回磁盘。
In other words, it may be removed from the buffer and written back to the disk before subsequent data pages can be read into the memory and processed.
对于垂直方向上的每个空格来说,管理程序都会采用 DMA 方式将自己的缓冲区读到GPU 的内存中,然后将 GPU的可视页刷新为与垂直空格信号同步的数据。
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.
整个缓冲区大小对DB2性能有巨大影响,这是因为大量的页可以显著地减少I/O这一最耗时的操作。
The overall buffer size has a significant effect on DB2 performance, because a large number of pages can significantly reduce I/O, which is the most time-consuming operation.
这种内存管理模式使用4K b缓冲区为基数,然后从中分配结构,并跟踪内存页使用情况,比如哪些内存页是满的,哪些页面没有完全使用,哪些页面为空。
This memory management scheme USES 4kb buffers as its base, but then allocates structures from within, keeping track of which pages are full, partially used, and empty.
Memknobs分配一个固定大小的缓冲区,循环遍历缓冲区页面,写到每一页上。
Memknobs allocates a fixed-sized buffer and loops through that buffer's pages, writing to each one.
每个叶索引行在传递到索引创建组件时,均包含在缓冲区的叶索引页中。
As each leaf index row is passed to the index create component, it is included in a leaf index page in the buffer.
每个叶索引行在传递到索引创建组件时,均包含在缓冲区的叶索引页中。
As each leaf index row is passed to the index create component, it is included in a leaf index page in the buffer.
应用推荐