8.10 Optimizing Locking Operations

8.10.1 Internal Locking Methods
8.10.2 Table Locking Issues
8.10.3 Concurrent Inserts
8.10.4 Metadata Locking
8.10.5 External Locking

MySQL manages contention for table contents using locking: