Write-Ahead Logging (WAL) and Data Consistency

A mechanism where changes are logged before data pages are updated.

InnoDB uses Redo Logs to implement WAL. This ensures that even if the server crashes before memory pages are flushed to disk, the transaction can be replayed from the log.