Redo Log & Undo Log
Learn Redo Log & Undo Log (InnoDB Internals, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction The redo log records physical changes so committed data survives a crash (durability and replay). The undo log stores the previous version of changed rows so a transaction can roll back and so other transactions can read old versions (MVCC). Redo moves forward, undo moves backward.