MySQL 5.0 Certification Study Guide

28 Locking

This chapter discusses how MySQL uses locking to handle concurrent data access by multiple clients. It covers the following exam topics:

Locking concepts

Using explicit table locks

Using advisory locks

Further discussion of locking issues is presented in Chapter 29, “Storage Engines.”

28.1 Locking Concepts

The MySQL server uses a multi-threaded architecture that enables it to service many clients concurrently (simultaneously). For each ...