InnoDB Data Locking – Part 5 “Concurrent queues”
In this blog series, I’m describing how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, and how this was improved in recent releases.
So far we saw that access right currently granted and waiting to be granted are represented as record locks and table locks objects in memory, which we can inspect via performance_schema.data_locks.…
Source: InnoDB Data Locking – Part 5 “Concurrent queues”
