Skip to main content

Undo Logs & Transaction IDs

Learn Undo Logs & Transaction IDs (MVCC, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction Every InnoDB row has hidden columns: DB_TRX_ID (id of the transaction that last changed it) and DB_ROLL_PTR (pointer to the undo record holding the previous version). Undo logs chain these versions together. Each read-write transaction gets an increasing transaction id.

More lessons in MVCC