SERIALIZABLE
Learn SERIALIZABLE (Transaction Isolation Levels, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction SERIALIZABLE is the strictest level. In InnoDB it behaves like REPEATABLE READ but converts every plain SELECT into SELECT ... FOR SHARE (when autocommit is off), so readers take shared next-key locks and writers cannot sneak in.