redbookcover.gif (13955 bytes) Readings in Database Systems, 3rd Edition

Stonebraker & Hellerstein, eds.

Transaction Commit

Write commit record to log.

All log records up to Xact’s lastLSN are flushed.

Guarantees that flushedLSN lastLSN.
Note that log flushes are sequential, synchronous writes to disk.
Many log records per log page.

Commit() returns.

Write end record to log.

Previous slide Next slide Back to first slide View graphic version

1998, Joseph M. Hellerstein.  Last modified 08/17/98.
Feedback welcomed.