Extracting More Intra-transaction Parallelism with Work Stealing for OLTP Workloads
Xiaozhou Zhou, Zhaoguo Wang, Rong Chen, Haibo Chen, Jinyang Li · 2017
Online transaction processing systems use two-phase locking (2PL) to guarantee serializability. However, traditional 2PL does not perform well under high contention, because a transaction will be blocked when it fails to acquire lock. This paper proposes a scalable work stealing algorithm for 2PL to leverage intra-transaction parallelism. The key idea is to parallelize the lock holder's work among lock waiters. Compared to traditional 2PL, our approach can achieve up to 2.8X throughput improvement for TPC-C new-order transactions under high contention.