All posts by Sunny Bains

About Sunny Bains

InnoDB developer by night and the InnoDB team manager by day.

Contention-Aware Transaction Scheduling Arriving in InnoDB to Boost Performance

Authors: Sunny Bains, Jiamin Huang (University of Michigan)

What is Transaction Scheduling?

Locking is one of the most popular mechanisms for concurrency control in most database systems, including Oracle MySQL. One major question, however, seems to have been overlooked by all database vendors:

Q: When multiple transactions are waiting for a lock on the same object, which one(s) should get the lock first?