Flush buffer-pool buffers

Flushing of the buffers is triggered by specific conditions.

Flushing of the buffers is initiated when:
  • The number of buffers in an MLRU queue reaches the number specified by the lru_max_dirty value in the BUFFERPOOL configuration parameter.
  • The page-cleaner threads cannot keep up. In other words, a user thread must acquire a buffer, but no unmodified buffers are available.
  • The database server must execute a checkpoint. (See Checkpoints.)

Automatic LRU tuning affects all buffer pools and adjusts the lru_min_dirty and lru_max_dirty values in the BUFFERPOOL configuration parameter.


Copyright© 2019 HCL Technologies Limited