14.6.3 InnoDB Concepts and Architecture The InnoDB Transaction Model and Locking InnoDB Lock Modes Consistent Nonlocking Reads SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads InnoDB Record, Gap, and Next-Key Locks Avoiding the Phantom Problem Using Next-Key Locking Locks Set by Different SQL Statements in InnoDB Implicit Transaction Commit and Rollback Deadlock Detection and Rollback How to Cope with Deadlocks InnoDB Multi-Versioning InnoDB Table and Index Structures