Spec-Zone .ru
спецификации, руководства, описания, API

14.2.3. InnoDB Concepts and Architecture

14.2.3.1. The InnoDB Transaction Model and Locking
14.2.3.2. InnoDB Lock Modes
14.2.3.3. Consistent Nonlocking Reads
14.2.3.4. Locking Reads (SELECT ... FOR UPDATE and SELECT ... LOCK IN SHAREMODE)
14.2.3.5. InnoDB Record, Gap, and Next-Key Locks
14.2.3.6. Avoiding the Phantom Problem Using Next-Key Locking
14.2.3.7. Locks Set by Different SQL Statements in InnoDB
14.2.3.8. Implicit Transaction Commit and Rollback
14.2.3.9. Deadlock Detection and Rollback
14.2.3.10. How to Cope with Deadlocks
14.2.3.11. InnoDB Multi-Versioning
14.2.3.12. InnoDB Table and Index Structures
14.2.3.13. The InnoDB Recovery Process
14.2.3.14. InnoDB Error Handling

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: