14.2.2 InnoDB Concepts and Architecture MySQL and the ACID Model The InnoDB Transaction Model and Locking InnoDB Lock Modes Consistent Nonlocking Reads Locking Reads (SELECT ... FOR UPDATE and SELECT ... LOCK IN SHARE MODE) 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

The information in this section provides background to help you get the most performance and functionality from using InnoDB tables. It is intended for:

In this section, you will learn: