Table of Contents
Logging and Recovery
Review: The ACID properties
Motivation
Assumptions
Handling the Buffer Pool
More on Steal and Force
Basic Idea: Logging
Write-Ahead Logging (WAL)
WAL & the Log
Log Records
Other Log-Related State
Normal Execution of a Xact
Checkpointing
The Big Picture: What’s Stored Where
Simple Transaction Abort
Abort, cont.
Transaction Commit
Crash Recovery: Big Picture
Recovery: The Analysis Phase
Recovery: The REDO Phase
To REDO An Action
Recovery: The UNDO Phase
Example of Recovery
Example: Crash During Restart!
Additional Crash Issues
Summary of Logging/Recovery
Summary, Cont.
State of the Art (recovery)
|