Database Paper Browser

Back to papers

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)

Paper ID
7121
Venue
SIGMOD
Year
2025
Pagerank
4.1905499e-05
Overall Rank
10,428 | 27.53%
DOI
10.1145/3722212.3724457

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank Citing Paper Year Venue Pagerank
10,736 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 4.1905499e-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.

Rank Cited Paper Year Venue Pagerank
122 Calvin: Fast Distributed Transactions for Partitioned Database Systems 2012 SIGMOD 0.0004532783
136 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00042409816
175 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.00038354115
208 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00034478612
419 Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems 2015 SIGMOD 0.00023720294
510 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021420477
632 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.00018895506
883 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.00015581085
931 An Evaluation of Alternative Architectures for Transaction Processing in the Cloud 2010 SIGMOD 0.00015228565
1,091 E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems 2015 VLDB 0.00014133147
1,120 Albatross: Lightweight Elasticity in Shared Storage Databases for the Cloud using Live Data Migration 2011 VLDB 0.00013846732
1,217 Rethinking serializable multiversion concurrency control 2015 VLDB 0.00013228757
1,228 Elle: Inferring Isolation Anomalies from Experimental Observations 2021 VLDB 0.00013158624
1,457 Rewriting Procedures for Batched Bindings 2008 VLDB 0.00011891025
1,521 High Performance Transactions via Early Write Visibility 2017 VLDB 0.00011522701
1,827 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.00010389522
1,850 Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering 2019 VLDB 0.00010330316
1,958 TicToc: Time Traveling Optimistic Concurrency Control 2016 SIGMOD 9.9592064e-05
2,370 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 8.9457118e-05
2,498 Leveraging Lock Contention to Improve OLTP Application Performance 2016 VLDB 8.6408169e-05
2,548 An Evaluation of Distributed Concurrency Control 2017 VLDB 8.5594603e-05
2,712 A Scalable Lock Manager for Multicores 2013 SIGMOD 8.2530512e-05
3,006 Clay: Fine-Grained Adaptive Partitioning for General Database Schemas 2017 VLDB 7.7285127e-05
3,605 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 6.9247155e-05
3,641 OceanBase: A 707 Million tpmC Distributed Relational Database System 2022 VLDB 6.8877808e-05
3,747 BCC: Reducing False Aborts in Optimistic Concurrency Control with Low Cost for In-Memory Databases 2016 VLDB 6.7883562e-05
3,789 Opportunities for Optimism in Contended Main-Memory Multicore Transactions 2020 VLDB 6.7614151e-05
4,348 Sundial: Harmonizing Concurrency Control and Caching in a Distributed OLTP Database Management System 2018 VLDB 6.2587037e-05
4,452 Analyzing the Impact of System Architecture on the Scalability of OLTP Engines for High-Contention Workloads 2018 VLDB 6.1693569e-05
4,500 GaccO - A GPU-accelerated OLTP DBMS 2022 SIGMOD 6.1326735e-05
4,519 Controlled Lock Violation 2013 SIGMOD 6.1125985e-05
4,715 Releasing Locks As Early As You Can: Reducing Contention of Hotspots by Violating Two-Phase Locking 2021 SIGMOD 5.9692979e-05
4,725 STAR: Scaling Transactions through Asymmetric Replication 2019 VLDB 5.9635555e-05
4,845 Graph Analytics Through Fine-Grained Parallelism 2016 SIGMOD 5.8731048e-05
5,223 Adaptive Concurrency Control: Despite the Looking Glass, One Concurrency Control Does Not Fit All 2017 CIDR 5.617782e-05
5,482 Strong consistency is not hard to get: Two-Phase Locking and Two-Phase Commit on Thousands of Cores 2019 VLDB 5.4830927e-05
6,265 Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems 2019 VLDB 5.1294788e-05
6,399 HyBench: A New Benchmark for HTAP Databases 2024 VLDB 5.0740852e-05
7,023 Contention-Aware Lock Scheduling for Transactional Databases 2018 VLDB 4.853107e-05
7,029 Bringing Modular Concurrency Control to the Next Level 2017 SIGMOD 4.8521438e-05
7,152 Bf-Tree: A Modern Read-Write-Optimized Concurrent Larger-Than-Memory Range Index 2024 VLDB 4.8126591e-05
7,684 TDSQL: Tencent Distributed Database System 2024 VLDB 4.6754482e-05
8,229 Don’t Look Back, Look into the Future: Prescient Data Partitioning and Migration for Deterministic Database Systems 2021 SIGMOD 4.5495076e-05
11,108 IsoVista: Black-box Checking Database Isolation Guarantees 2024 VLDB 4.1905499e-05
Previous Page 1 / 1 Next

Semantically Similar Papers