Skip to main content

REPEATABLE READ

Learn REPEATABLE READ (Transaction Isolation Levels, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction REPEATABLE READ is InnoDB's default. The first consistent read in a transaction creates a snapshot (read view); all later plain SELECTs in that transaction see the same data even if others commit changes. InnoDB also uses next-key locks to prevent most phantoms for locking reads.

More lessons in Transaction Isolation Levels