InnoDB Data Locking - Part 4 "Scheduling"

Published: 2021-04-15

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. As we’ve already seen, the order in which server pretends transactions are happening (the serialization order) is tied to the order in which locks are granted to transactions.…

Read More