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 ...
Get MySQL 5.0 Certification Study Guide now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.