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.