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

When your database is busy with multiple sessions reading and writing data, the mechanism that controls access to data files and memory areas can become a consideration for performance tuning. Otherwise, sessions can spend time waiting for access to resources when they could be running concurrently.

MySQL manages contention for table contents using locking: