Dirty Pages Table

• During normal processing:

  • When page is fixed with intention to update
    • Let L = current end-of-log LSN (the LSN of next log record to be generated)
    • if page is not dirty, store L as RecLSN of the page in dirty pages table
  • When page is flushed to disk, delete from dirty page table
  • dirty page table written out during checkpoint
  • (Thus RecLSN is LSN of earliest log record whose effect is not reflected in page on disk)

Notes: