What Isolation Levels Actually Prevent

A transaction isolation level is a policy choice about which anomalies to allow. The anomalies each ANSI level prevents, and how InnoDB’s MVCC and Repeatable Read behave differently from the standard.

September 15, 2023 · 7 min read