Back to papers
A Top-Down Approach to Achieving Performance Predictability in Database Systems
Summary: Top-down study of performance predictability across MySQL, PostgreSQL, and VoltDB using TProfiler identifies key latency-variance sources. Proposes Variance-Aware Transaction Scheduling (VATS) and a lazy buffer-pool policy, yielding up to 5.6x variance reduction and 6.3x 99th percentile latency, with VATS adopted in MySQL/MariaDB.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 5393
- Venue
- SIGMOD
- Year
- 2017
- Pagerank
- 5.468383e-05
- Overall Rank
- 5,518 | 61.66%
- DOI
-
10.1145/3035918.3064016
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 10 of 10 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 3,117 |
Distributed Lock Management with RDMA: Decentralization without Starvation |
2018 |
SIGMOD |
7.5400979e-05 |
| 4,800 |
Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload |
2021 |
SIGMOD |
5.9077188e-05 |
| 4,833 |
Reactors: A Case for Predictable, Virtualized Actor Database Systems |
2018 |
SIGMOD |
5.8881564e-05 |
| 4,920 |
On Performance Stability in LSM-based Storage Systems |
2020 |
VLDB |
5.8262404e-05 |
| 7,023 |
Contention-Aware Lock Scheduling for Transactional Databases |
2018 |
VLDB |
4.853107e-05 |
| 7,291 |
Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities |
2022 |
SIGMOD |
4.7677422e-05 |
| 7,687 |
Towards Optimal Transaction Scheduling |
2024 |
VLDB |
4.6745165e-05 |
| 7,778 |
Runtime Variation in Big Data Analytics |
2023 |
SIGMOD |
4.6491879e-05 |
| 7,849 |
InTime: Towards Performance Predictability In Byzantine Fault Tolerant Proof-of-Stake Consensus |
2025 |
SIGMOD |
4.6321834e-05 |
| 8,735 |
Vertically Autoscaling Monolithic Applications with CaaSPER: Scalable Container-as-a-Service Performance Enhanced Resizing Algorithm for the Cloud |
2024 |
SIGMOD |
4.4520434e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 26 of 26 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 215 |
OLTP Through the Looking Glass, and What We Found There |
2008 |
SIGMOD |
0.00033609709 |
| 339 |
OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases |
2014 |
VLDB |
0.00026895683 |
| 515 |
QPipe: A Simultaneously Pipelined Relational Query Engine |
2005 |
SIGMOD |
0.00021209491 |
| 632 |
Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores |
2015 |
VLDB |
0.00018895506 |
| 781 |
Scalable Logging through Emerging Non-Volatile Memory |
2014 |
VLDB |
0.00016667457 |
| 826 |
Main-Memory Scan Sharing For Multi-Core CPUs |
2008 |
VLDB |
0.00016161625 |
| 934 |
SharedDB: Killing One Thousand Queries With One Stone |
2012 |
VLDB |
0.00015201246 |
| 940 |
Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems |
2015 |
SIGMOD |
0.00015149366 |
| 954 |
Storage Management in the NVRAM Era |
2014 |
VLDB |
0.0001509523 |
| 1,024 |
DBSherlock: A Performance Diagnostic Tool for Transactional Databases |
2016 |
SIGMOD |
0.00014601525 |
| 1,105 |
FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance |
2009 |
SIGMOD |
0.00013980159 |
| 1,234 |
Least Expected Cost Query Optimization: An Exercise in Utility |
1999 |
PODS |
0.00013115865 |
| 1,296 |
The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses |
2010 |
SIGMOD |
0.00012742585 |
| 1,387 |
SQLVM: Performance Isolation in Multi-Tenant Relational Database-as-a-Service |
2013 |
CIDR |
0.00012249858 |
| 1,430 |
A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses |
2009 |
VLDB |
0.0001202506 |
| 2,062 |
PIQL: Success-Tolerant Query Processing in the Cloud |
2012 |
VLDB |
9.654149e-05 |
| 2,239 |
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads |
2013 |
SIGMOD |
9.2163469e-05 |
| 2,372 |
Predictable Performance for Unpredictable Workloads |
2009 |
VLDB |
8.940791e-05 |
| 3,431 |
Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service |
2015 |
VLDB |
7.0984188e-05 |
| 3,775 |
Recovery Architectures for Multiprocessor Database Machines |
1985 |
SIGMOD |
6.7728004e-05 |
| 3,979 |
Making Updates Disk-I/O Friendly Using SSDs |
2013 |
VLDB |
6.5641036e-05 |
| 4,003 |
DBSeer: Resource and Performance Prediction for Building a Next Generation Database Cloud |
2013 |
CIDR |
6.5406297e-05 |
| 4,457 |
Generalized Scale Independence Through Incremental Precomputation |
2013 |
SIGMOD |
6.1636855e-05 |
| 4,480 |
Variance Aware Optimization of Parameterized Queries |
2010 |
SIGMOD |
6.1433292e-05 |
| 5,578 |
CliffGuard: A Principled Framework for Finding Robust Database Designs |
2015 |
SIGMOD |
5.4231783e-05 |
| 9,004 |
DBSeer: Pain-free Database Administration through Workload Intelligence |
2015 |
VLDB |
4.4074927e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 9,237 |
Low-Latency Transaction Scheduling via Userspace Interrupts: Why Wait or Yield When You Can Preempt? |
2025 |
SIGMOD |
4.3648789e-05 |
| 2,239 |
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads |
2013 |
SIGMOD |
9.2163469e-05 |
| 1,827 |
Lightweight Locking for Main Memory Database Systems |
2013 |
VLDB |
0.00010389522 |
| 7,687 |
Towards Optimal Transaction Scheduling |
2024 |
VLDB |
4.6745165e-05 |
| 11,317 |
Decoupled Transactions: Low Tail Latency Online Transactions Atop Jittery Servers |
2022 |
CIDR |
4.1905499e-05 |
| 12,315 |
Optimizing I/O-Intensive Transactions in Highly Interactive Applications |
2009 |
SIGMOD |
4.1905499e-05 |
| 3,605 |
Lazy Evaluation of Transactions in Database Systems |
2014 |
SIGMOD |
6.9247155e-05 |
| 6,338 |
An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems |
2002 |
VLDB |
5.1000849e-05 |
| 7,023 |
Contention-Aware Lock Scheduling for Transactional Databases |
2018 |
VLDB |
4.853107e-05 |
| 9,869 |
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? |
2025 |
SIGMOD |
4.2626861e-05 |