A Study of Database Performance Sensitivity to Experiment Settings

Proc. VLDB Endow., 2022

Yang Wang, Miao Yu, Yujie Hui, Fang Zhou, Yuyang Huang, Rui Zhu, Xueyuan Ren, Tianxi Li, Xiaoyi Lu

Abstract

To allow performance comparison across different systems, our community has developed multiple benchmarks, such as TPC-C and YCSB, which are widely used. However, despite such effort, interpreting and comparing performance numbers is still a challenging task, because one can tune benchmark parameters, system features, and hardware settings, which can lead to very different system behaviors. Such tuning creates a long-standing question of whether the conclusion of a work can hold under different settings.This work tries to shed light on this question by reproducing 11 works evaluated under TPC-C and YCSB, measuring their performance under a wider range of settings, and investigating the reasons for the change of performance numbers. By doing so, this paper tries to motivate the discussion about whether and how we should address this problem. While this paper does not give a complete solution—this is beyond the scope of a single paper, it proposes concrete suggestions we can take to improve the state of the art.

Full text links

PDF

External link

Journal Article

Issue_date
March 2022
Publisher
VLDB Endowment
Volume
15
Number
7
Issn
2150-8097
Doi
10.14778/3523210.3523221
Journal
Proc. VLDB Endow.
Month
mar
Pages
1439–1452
Numpages
14
Series
VLDB '22

Cite

Plain text

BibTeX