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
- 5392
- Venue
- SIGMOD
- Year
- 2017
- Pagerank
- 5.4734224e-05
- Overall Rank
- 5,505 | 61.71%
- 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,309 |
Distributed Lock Management with RDMA: Decentralization without Starvation |
2018 |
SIGMOD |
7.2419042e-05 |
| 4,804 |
Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload |
2021 |
SIGMOD |
5.910467e-05 |
| 4,828 |
Reactors: A Case for Predictable, Virtualized Actor Database Systems |
2018 |
SIGMOD |
5.893685e-05 |
| 4,914 |
On Performance Stability in LSM-based Storage Systems |
2020 |
VLDB |
5.8315684e-05 |
| 7,040 |
Contention-Aware Lock Scheduling for Transactional Databases |
2018 |
VLDB |
4.854418e-05 |
| 7,296 |
Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities |
2022 |
SIGMOD |
4.7723197e-05 |
| 7,696 |
Towards Optimal Transaction Scheduling |
2024 |
VLDB |
4.6754222e-05 |
| 7,778 |
Runtime Variation in Big Data Analytics |
2023 |
SIGMOD |
4.653651e-05 |
| 7,844 |
InTime: Towards Performance Predictability In Byzantine Fault Tolerant Proof-of-Stake Consensus |
2025 |
SIGMOD |
4.6366294e-05 |
| 8,739 |
Vertically Autoscaling Monolithic Applications with CaaSPER: Scalable Container-as-a-Service Performance Enhanced Resizing Algorithm for the Cloud |
2024 |
SIGMOD |
4.456315e-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.0003354907 |
| 340 |
OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases |
2014 |
VLDB |
0.00026841628 |
| 515 |
QPipe: A Simultaneously Pipelined Relational Query Engine |
2005 |
SIGMOD |
0.00021214633 |
| 635 |
Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores |
2015 |
VLDB |
0.00018879031 |
| 792 |
Scalable Logging through Emerging Non-Volatile Memory |
2014 |
VLDB |
0.0001661112 |
| 830 |
Main-Memory Scan Sharing For Multi-Core CPUs |
2008 |
VLDB |
0.00016171897 |
| 940 |
SharedDB: Killing One Thousand Queries With One Stone |
2012 |
VLDB |
0.00015173166 |
| 952 |
Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems |
2015 |
SIGMOD |
0.00015103873 |
| 1,004 |
Storage Management in the NVRAM Era |
2014 |
VLDB |
0.00014695628 |
| 1,022 |
DBSherlock: A Performance Diagnostic Tool for Transactional Databases |
2016 |
SIGMOD |
0.00014614917 |
| 1,109 |
FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance |
2009 |
SIGMOD |
0.00013976056 |
| 1,236 |
Least Expected Cost Query Optimization: An Exercise in Utility |
1999 |
PODS |
0.00013117798 |
| 1,299 |
The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses |
2010 |
SIGMOD |
0.00012751522 |
| 1,385 |
SQLVM: Performance Isolation in Multi-Tenant Relational Database-as-a-Service |
2013 |
CIDR |
0.00012261812 |
| 1,429 |
A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses |
2009 |
VLDB |
0.00012033518 |
| 2,056 |
PIQL: Success-Tolerant Query Processing in the Cloud |
2012 |
VLDB |
9.6645763e-05 |
| 2,230 |
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads |
2013 |
SIGMOD |
9.2322426e-05 |
| 2,372 |
Predictable Performance for Unpredictable Workloads |
2009 |
VLDB |
8.947963e-05 |
| 3,436 |
Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service |
2015 |
VLDB |
7.0948913e-05 |
| 3,766 |
Recovery Architectures for Multiprocessor Database Machines |
1985 |
SIGMOD |
6.7792659e-05 |
| 3,980 |
Making Updates Disk-I/O Friendly Using SSDs |
2013 |
VLDB |
6.5664429e-05 |
| 4,013 |
DBSeer: Resource and Performance Prediction for Building a Next Generation Database Cloud |
2013 |
CIDR |
6.529956e-05 |
| 4,455 |
Generalized Scale Independence Through Incremental Precomputation |
2013 |
SIGMOD |
6.171182e-05 |
| 4,482 |
Variance Aware Optimization of Parameterized Queries |
2010 |
SIGMOD |
6.1482936e-05 |
| 5,581 |
CliffGuard: A Principled Framework for Finding Robust Database Designs |
2015 |
SIGMOD |
5.424205e-05 |
| 8,999 |
DBSeer: Pain-free Database Administration through Workload Intelligence |
2015 |
VLDB |
4.4117211e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 9,233 |
Low-Latency Transaction Scheduling via Userspace Interrupts: Why Wait or Yield When You Can Preempt? |
2025 |
SIGMOD |
4.3690661e-05 |
| 2,230 |
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads |
2013 |
SIGMOD |
9.2322426e-05 |
| 1,832 |
Lightweight Locking for Main Memory Database Systems |
2013 |
VLDB |
0.00010380187 |
| 7,696 |
Towards Optimal Transaction Scheduling |
2024 |
VLDB |
4.6754222e-05 |
| 12,307 |
Optimizing I/O-Intensive Transactions in Highly Interactive Applications |
2009 |
SIGMOD |
4.1945683e-05 |
| 11,315 |
Decoupled Transactions: Low Tail Latency Online Transactions Atop Jittery Servers |
2022 |
CIDR |
4.1945683e-05 |
| 3,605 |
Lazy Evaluation of Transactions in Database Systems |
2014 |
SIGMOD |
6.9281695e-05 |
| 6,341 |
An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems |
2002 |
VLDB |
5.1037155e-05 |
| 7,040 |
Contention-Aware Lock Scheduling for Transactional Databases |
2018 |
VLDB |
4.854418e-05 |
| 9,870 |
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? |
2025 |
SIGMOD |
4.2667743e-05 |