Skip to main content

Visibility Rules & Snapshot Isolation

Learn Visibility Rules & Snapshot Isolation (MVCC, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction When a read view is created InnoDB records up_limit_id (lowest active trx id), low_limit_id (next id to be assigned) and the list of active ids. A row version with DB_TRX_ID below the low limit and not in the active list was committed before the snapshot and is visible; otherwise follow the undo chain to an older version. This gives snapshot-style isolation for reads.

More lessons in MVCC