2-56 IBM Informix OnLine Database Server Administrator’s Guide
Shared-Memory Buffer PoolRegular Buffers
The regular buffers store dbspace pages read from disk. The status of the
regular buffers is tracked through the buffer header table. Within shared
memory, regular buffers are organized intoLRU buffer queues. (Refer to
page 2-57 for further information about theLRU queues.) Buffer allocation is
managedthrough the use of latches and lock access information. Buffer infor-
mation is available through four options oftbstat:
■-b and -B options display general buffer information.
■-R displaysLRU queue statistics.
■-X displays information about OnLine user processes that are
sharing or waiting for buffers.
Each regular buffer is the size of one OnLine page, specified asBUFFSIZE in
theconfiguration file. In general, OnLine performs I/O in full-page units, the
size of a regular buffer. The two exceptions areI/O performed from big
buffers andI/O performed from blobspace buffers. (Refer to page 2-78 for
further information about blobspace buffers.)
Big Buffers
For every 100 regular buffers, OnLine allocates one additionalbig buffer.
OnLinecreates at least one big buffer, even if BUFFERS is less than 100. A big
buffer is a single buffer that is the size of eight pages.
Thefunction of the big buffers is to increase performance on large writes and
reads.For example, OnLine tries to use a big buffer if it is writing a dbspace
blob into shared memory or performing a series of sequential reads. After
disk pages are read into the big buffer, they are immediately allocated to
regular buffers in the buffer pools. The big buffers are also used in sorted
writes and during checkpoints, if possible. (Refer to page 2-75 for more
details about sorted and chunk writes.)
Multiple big buffers cannot be combined for contiguous I/O reads that are
greaterthan eight pages. The number of big-buffer reads is displayed as part
of thetbstat -P output.