14.6.3 InnoDB Concepts and Architecture

14.6.3.1 The InnoDB Transaction Model and Locking
14.6.3.2 InnoDB Lock Modes
14.6.3.3 Consistent Nonlocking Reads
14.6.3.4 SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE Locking Reads
14.6.3.5 InnoDB Record, Gap, and Next-Key Locks
14.6.3.6 Avoiding the Phantom Problem Using Next-Key Locking
14.6.3.7 Locks Set by Different SQL Statements in InnoDB
14.6.3.8 Implicit Transaction Commit and Rollback
14.6.3.9 Deadlock Detection and Rollback
14.6.3.10 How to Cope with Deadlocks
14.6.3.11 InnoDB Multi-Versioning
14.6.3.12 InnoDB Table and Index Structures