Redo starting point is minimum of (MinBuffLSN, LowTranLSN)

1) MinBuffLSN represents oldest change to page in the buffer pool that hasn't been written to disk

2) LowTranLSN represents oldest active uncommitted transaction (specifically, LSN of 1st log record it wrote)


wKioL1U7Ek7zluG5AAAeJ2Wc_Ps171.gif


SOFTMAX configuration parameter influences how far back MinBuffLSN is:

1) Value is percentage of one log file (for example, 200 = 2 log files)
2) Page cleaners triggered to write pages out if MinBuffLSN too far back (“LSN gap”)
3) Lower value means shorter recovery time, but increased page cleaning activity
4) Higher value means longer recovery time, but fewer page writes


  1. Current state of database


    wKioL1U7EPCTE8AZAAAP1x72yXk874.gif


  2. More work is done, moving Current LSN out


    wKiom1U7EB6BvdbSAAARa9oL5W4863.gif


  3. Page cleaners react by cleaning pages in the LSN gap that fall outside of the
    SOFTMAX range – moving MinBuffLSN up


    wKioL1U7EAXA7o56AAAcJcgGBqM156.gif