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.