TXSQL: Lock Optimizations Towards High Contented Workloads
Summary: TXSQL optimizes 2PL with lightweight lock management, a copy-free active transaction list, and queue locking to boost concurrency. A hotspot-aware mode groups conflicts, enabling uncommitted execution without locks and delivering up to 6.5x–22.3x gains. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Donghui Wang (Tencent)
- 2. Yuxing Chen (Tencent)
- 3. Chengyao Jiang (Tencent)
- 4. Anqun Pan (Tencent)
- 5. Wei Jiang (Tencent)
- 6. Songli Wang (Tencent)
- 7. Hailin Lei (Tencent)
- 8. Chong Zhu (Tencent)
- 9. Lixiong Zheng (Tencent)
- 10. Wei Lu (Renmin University of China)
- 11. Yunpeng Chai (Renmin University of China)
- 12. Feng Zhang (Renmin University of China)
- 13. Xiaoyong Du (Renmin University of China)
BibTeX Citation
@inproceedings{wang_sigmod25,
title = {{TXSQL: Lock Optimizations Towards High Contented Workloads}},
author = {Wang, Donghui and Chen, Yuxing and Jiang, Chengyao and Pan, Anqun and Jiang, Wei and Wang, Songli and Lei, Hailin and Zhu, Chong and Zheng, Lixiong and Lu, Wei and Chai, Yunpeng and Zhang, Feng and Du, Xiaoyong},
series = {{SIGMOD} '25},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3722212.3724457},
url = {https://dl.acm.org/doi/10.1145/3722212.3724457},
year = {2025}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,633 | TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection | 2025 | VLDB | 5.135655e-05 |
| 10,985 | Reaching the Pinnacle of TPC-DS: Co-design of Architecture, Executor, and Storage in TDSQL | 2026 | VLDB | 4.9605343e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 44 of 44 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,699 | Concurrency on High-Traffic Data Elements | 1982 | PODS |
| 2 | 1,437 | Lightweight Locking for Main Memory Database Systems | 2013 | VLDB |
| 3 | 2,338 | A Scalable Lock Manager for Multicores | 2013 | SIGMOD |
| 4 | 4,431 | Strong consistency is not hard to get: Two-Phase Locking and Two-Phase Commit on Thousands of Cores | 2019 | VLDB |
| 5 | 3,449 | Load Control for Locking: The 'Half-and-Half' Approach | 1990 | PODS |
| 6 | 6,884 | An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems | 2002 | VLDB |
| 7 | 14,806 | Safety Of Non-Well-Locked Transaction Systems | 1986 | PODS |
| 8 | 10,625 | Brook-2PL: Tolerating High Contention Workloads with A Deadlock-Free Two-Phase Locking Protocol | 2026 | SIGMOD |
| 9 | 6,481 | Contention-Aware Lock Scheduling for Transactional Databases | 2018 | VLDB |
| 10 | 3,838 | Releasing Locks As Early As You Can: Reducing Contention of Hotspots by Violating Two-Phase Locking | 2021 | SIGMOD |