Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.

Physically, a log is a file of updates done to the database, stored in stable storage, transaction log is not used for statements that do not modify data.

The transaction log has some important purposes:

  • data recovery if there is a system failure
  • replication
  • system maintenance
  • analysis
history | show excerpt | excerpt history