---
title: Write-ahead logging
slug: write-ahead-logging
qid: 
snapshot: enwiki-001345989151
content_hash: 
license: CC BY-SA 4.0
source: https://en.wikipedia.org/w/index.php?oldid=1345989151
tags: [20549174, 22904254, 23118434, 23468805, 23603337, 24043274, 59400749]
---

# Write-ahead logging

> [!note] Provenance
> Snapshot `enwiki-001345989151` · content root `…`
> Derived from <https://en.wikipedia.org/w/index.php?oldid=1345989151> · Licensed CC BY-SA 4.0

In computer science, write-ahead logging (WAL) is a family of techniques for providing atomicity and durability (two of the ACID properties) in database systems. A write ahead log is an append-only auxiliary disk-resident structure used for crash and transaction recovery. The changes are first recorded in the log, which must be written to stable storage, before the changes are written to the database.

In computer science, write-ahead logging (WAL) is a family of techniques for providing atomicity and durability (two of the ACID properties) in database systems. A write ahead log is an append-only auxiliary disk-resident structure used for crash and transaction recovery. The changes are first recorded in the log, which must be written to stable storage, before the changes are written to the database.
