Other Log-Related State

Transaction Table: One entry per active Xact. Contains XID, status (running/commited/aborted), and lastLSN.

Dirty Page Table: One entry per dirty page in buffer pool. Contains recLSN -- the LSN of the log record which first caused the page to be dirty.

Previous slide

Next slide

Back to first slide

View graphic version