This chapter discusses how MySQL uses locking to handle concurrent data access by multiple clients. It covers the following exam topics:
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 ...