Number of pages added to the MLRU queues
The page-cleaner threads flush the modified buffers in an MLRU queue to disk. To specify the point at which cleaning begins, use the BUFFERPOOL configuration parameter to specify a value for lru_max_dirty, which limits the number of page buffers that can be appended to an MLRU queue.
The initial setting of lru_max_dirty is 60.00
,
so page cleaning begins when 60 percent of the buffers managed by
a queue are modified.
In practice, page cleaning begins under several conditions, only one of which is when an MLRU queue reaches the value of lru_max_dirty. For more information about how the database server performs buffer-pool flushing, see Flush data to disk.
Buffers specified as 8000
lrus specified as 8
lru_max_dirty specified as 60 percent
Page cleaning begins when the number of buffers in the MLRU
queue is equal to lru_max_dirty.
Buffers per lru queue = (8000/8) = 1000
Max buffers in MLRU queue and point at which page cleaning
begins: 1000 x 0.60 = 600