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
7120
Venue
SIGMOD
Year
2025
Pagerank
4.1945683e-05
Overall Rank
10,418 | 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,729 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 4.1945683e-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.00045316749
137 H-Store: A High-Performance, Distributed Main Memory Transaction Processing System 2008 VLDB 0.00042342967
174 ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes 1990 VLDB 0.00038347904
209 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00034468292
419 Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems 2015 SIGMOD 0.00023720338
514 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002124895
635 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.00018879031
889 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.0001557156
933 An Evaluation of Alternative Architectures for Transaction Processing in the Cloud 2010 SIGMOD 0.00015232301
1,092 E-Store: Fine-Grained Elastic Partitioning for Distributed Transaction Processing Systems 2015 VLDB 0.00014135961
1,121 Albatross: Lightweight Elasticity in Shared Storage Databases for the Cloud using Live Data Migration 2011 VLDB 0.00013856011
1,217 Rethinking serializable multiversion concurrency control 2015 VLDB 0.0001323177
1,227 Elle: Inferring Isolation Anomalies from Experimental Observations 2021 VLDB 0.00013170695
1,456 Rewriting Procedures for Batched Bindings 2008 VLDB 0.00011899772
1,521 High Performance Transactions via Early Write Visibility 2017 VLDB 0.00011532045
1,832 Lightweight Locking for Main Memory Database Systems 2013 VLDB 0.00010380187
1,845 Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering 2019 VLDB 0.00010338323
1,961 TicToc: Time Traveling Optimistic Concurrency Control 2016 SIGMOD 9.9514005e-05
2,369 Aria: A Fast and Practical Deterministic OLTP Database 2020 VLDB 8.9490403e-05
2,513 Leveraging Lock Contention to Improve OLTP Application Performance 2016 VLDB 8.6178149e-05
2,548 An Evaluation of Distributed Concurrency Control 2017 VLDB 8.5652459e-05
2,713 A Scalable Lock Manager for Multicores 2013 SIGMOD 8.2477916e-05
3,005 Clay: Fine-Grained Adaptive Partitioning for General Database Schemas 2017 VLDB 7.7303579e-05
3,605 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD 6.9281695e-05
3,628 OceanBase: A 707 Million tpmC Distributed Relational Database System 2022 VLDB 6.9031596e-05
3,749 BCC: Reducing False Aborts in Optimistic Concurrency Control with Low Cost for In-Memory Databases 2016 VLDB 6.7907876e-05
3,788 Opportunities for Optimism in Contended Main-Memory Multicore Transactions 2020 VLDB 6.7656267e-05
4,351 Sundial: Harmonizing Concurrency Control and Caching in a Distributed OLTP Database Management System 2018 VLDB 6.2638519e-05
4,454 Analyzing the Impact of System Architecture on the Scalability of OLTP Engines for High-Contention Workloads 2018 VLDB 6.1715229e-05
4,498 GaccO - A GPU-accelerated OLTP DBMS 2022 SIGMOD 6.138538e-05
4,519 Controlled Lock Violation 2013 SIGMOD 6.1176534e-05
4,721 Releasing Locks As Early As You Can: Reducing Contention of Hotspots by Violating Two-Phase Locking 2021 SIGMOD 5.9729623e-05
4,727 STAR: Scaling Transactions through Asymmetric Replication 2019 VLDB 5.9690763e-05
4,845 Graph Analytics Through Fine-Grained Parallelism 2016 SIGMOD 5.8795333e-05
5,227 Adaptive Concurrency Control: Despite the Looking Glass, One Concurrency Control Does Not Fit All 2017 CIDR 5.6180363e-05
5,512 Strong consistency is not hard to get: Two-Phase Locking and Two-Phase Commit on Thousands of Cores 2019 VLDB 5.4665318e-05
5,923 HyBench: A New Benchmark for HTAP Databases 2024 VLDB 5.2721765e-05
6,268 Speedup Your Analytics: Automatic Parameter Tuning for Databases and Big Data Systems 2019 VLDB 5.133857e-05
7,028 Bringing Modular Concurrency Control to the Next Level 2017 SIGMOD 4.856636e-05
7,040 Contention-Aware Lock Scheduling for Transactional Databases 2018 VLDB 4.854418e-05
7,154 Bf-Tree: A Modern Read-Write-Optimized Concurrent Larger-Than-Memory Range Index 2024 VLDB 4.815267e-05
7,683 TDSQL: Tencent Distributed Database System 2024 VLDB 4.6799361e-05
8,232 Don’t Look Back, Look into the Future: Prescient Data Partitioning and Migration for Deterministic Database Systems 2021 SIGMOD 4.553873e-05
11,105 IsoVista: Black-box Checking Database Isolation Guarantees 2024 VLDB 4.1945683e-05
Previous Page 1 / 1 Next

Semantically Similar Papers