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
5454
Venue
SIGMOD
Year
2017
Pagerank
6.4949878e-05
Overall Rank
4,816 | 66.96%
DOI
10.1145/3035918.3064016
Incoming Non-self Citations Over Time
BibTeX Citation
@inproceedings{huang_sigmod17,
title = {{A Top-Down Approach to Achieving Performance Predictability in Database Systems}},
author = {Huang, Jiamin and Mozafari, Barzan and Schoenebeck, Grant and Wenisch, Thomas F.},
series = {{SIGMOD} '17},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3035918.3064016},
url = {https://dl.acm.org/doi/10.1145/3035918.3064016},
year = {2017}
}
Incoming Citations (Sorted by Pagerank)
Showing 11 of 11 citing papers.
Rank
Citing Paper
Year
Venue
Pagerank
3,080
Distributed Lock Management with RDMA: Decentralization without Starvation 2018
SIGMOD
7.7746739e-05
3,953
Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload 2021
SIGMOD
6.996368e-05
4,262
On Performance Stability in LSM-based Storage Systems 2020
VLDB
6.7965035e-05
5,015
Reactors: A Case for Predictable, Virtualized Actor Database Systems 2018
SIGMOD
6.4000528e-05
6,361
Contention-Aware Lock Scheduling for Transactional Databases 2018
VLDB
5.9009048e-05
6,939
Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022
SIGMOD
5.7338637e-05
7,334
Towards Optimal Transaction Scheduling 2024
VLDB
5.6425501e-05
7,762
Runtime Variation in Big Data Analytics 2023
SIGMOD
5.5501898e-05
7,819
InTime: Towards Performance Predictability In Byzantine Fault Tolerant Proof-of-Stake Consensus 2025
SIGMOD
5.5373997e-05
8,910
Vertically Autoscaling Monolithic Applications with CaaSPER: Scalable Container-as-a-Service Performance Enhanced Resizing Algorithm for the Cloud 2024
SIGMOD
5.3483178e-05
10,033
Modeling Concurrency Control as a Learnable Function 2026
SIGMOD
5.173224e-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
157
OLTP Through the Looking Glass, and What We Found There 2008
SIGMOD
0.0002863588
226
OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014
VLDB
0.00024027277
383
QPipe: A Simultaneously Pipelined Relational Query Engine 2005
SIGMOD
0.00019520728
473
Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015
VLDB
0.00017900942
603
Scalable Logging through Emerging Non-Volatile Memory 2014
VLDB
0.00015853456
670
SharedDB: Killing One Thousand Queries With One Stone 2012
VLDB
0.00015157572
696
Main-Memory Scan Sharing For Multi-Core CPUs 2008
VLDB
0.00014891322
798
DBSherlock: A Performance Diagnostic Tool for Transactional Databases 2016
SIGMOD
0.00013919795
840
Storage Management in the NVRAM Era 2014
VLDB
0.00013683877
841
Let’s Talk About Storage & Recovery Methods for Non-Volatile Memory Database Systems 2015
SIGMOD
0.00013677356
1,022
A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses 2009
VLDB
0.00012602841
1,024
The DataPath System: A Data-Centric Analytic Processing Engine for Large Data Warehouses 2010
SIGMOD
0.0001258839
1,104
Least Expected Cost Query Optimization: An Exercise in Utility 1999
PODS
0.00012157634
1,105
FlashLogging: Exploiting Flash Devices for Synchronous Logging Performance 2009
SIGMOD
0.00012151254
1,335
SQLVM: Performance Isolation in Multi-Tenant Relational Database-as-a-Service 2013
CIDR
0.00011122853
1,879
Predictable Performance for Unpredictable Workloads 2009
VLDB
9.5613416e-05
1,931
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013
SIGMOD
9.4664741e-05
1,969
PIQL: Success-Tolerant Query Processing in the Cloud 2012
VLDB
9.3749819e-05
3,236
Sharing Buffer Pool Memory in Multi-Tenant Relational Database-as-a-Service 2015
VLDB
7.6108467e-05
3,513
Variance Aware Optimization of Parameterized Queries 2010
SIGMOD
7.354613e-05
3,808
Making Updates Disk-I/O Friendly Using SSDs 2013
VLDB
7.1083217e-05
4,000
DBSeer: Resource and Performance Prediction for Building a Next Generation Database Cloud 2013
CIDR
6.9666198e-05
4,250
Generalized Scale Independence Through Incremental Precomputation 2013
SIGMOD
6.8031294e-05
5,222
CliffGuard: A Principled Framework for Finding Robust Database Designs 2015
SIGMOD
6.3103741e-05
5,550
Recovery Architectures for Multiprocessor Database Machines 1985
SIGMOD
6.178647e-05
9,016
DBSeer: Pain-free Database Administration through Workload Intelligence 2015
VLDB
5.3312701e-05
Semantically Similar Papers
#
Overall Rank
Paper
Year
Venue
1
8,840
Low-Latency Transaction Scheduling via Userspace Interrupts: Why Wait or Yield When You Can Preempt? 2025
SIGMOD
2
1,931
Performance and Resource Modeling in Highly-Concurrent OLTP Workloads 2013
SIGMOD
3
1,420
Lightweight Locking for Main Memory Database Systems 2013
VLDB
4
7,334
Towards Optimal Transaction Scheduling 2024
VLDB
5
12,501
Optimizing I/O-Intensive Transactions in Highly Interactive Applications 2009
SIGMOD
6
11,514
Decoupled Transactions: Low Tail Latency Online Transactions Atop Jittery Servers 2022
CIDR
7
3,053
Lazy Evaluation of Transactions in Database Systems 2014
SIGMOD
8
6,751
An Almost-Serial Protocol for Transaction Execution in Main-Memory Database Systems 2002
VLDB
9
6,361
Contention-Aware Lock Scheduling for Transactional Databases 2018
VLDB
10
9,517
Are Database System Researchers Making Correct Assumptions About Transaction Workloads? 2025
SIGMOD