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?…