Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
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
