Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation
Xinyi Zhang, Zhuo Chang, Yang Li, Hong Wu, Jian Tan, Feifei Li, Bin, Cui

TL;DR
This paper provides a comprehensive evaluation of hyper-parameter optimization techniques for database tuning, demonstrating their effectiveness and identifying optimal algorithms for different tuning modules, along with a cost-efficient benchmarking approach.
Contribution
It offers a broad evaluation of configuration tuning algorithms, integrating hyper-parameter optimization methods into database tuning, and introduces a unified benchmarking framework.
Findings
Hyper-parameter optimization algorithms improve database tuning performance.
Different algorithms are optimal for different tuning modules.
A surrogate-based benchmark reduces evaluation costs significantly.
Abstract
Recently, using automatic configuration tuning to improve the performance of modern database management systems (DBMSs) has attracted increasing interest from the database community. This is embodied with a number of systems featuring advanced tuning capabilities being developed. However, it remains a challenge to select the best solution for database configuration tuning, considering the large body of algorithm choices. In addition, beyond the applications on database systems, we could find more potential algorithms designed for configuration tuning. To this end, this paper provides a comprehensive evaluation of configuration tuning techniques from a broader perspective, hoping to better benefit the database community. In particular, we summarize three key modules of database configuration tuning systems and conduct extensive ablation studies using various challenging cases. Our…
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Code & Models
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsData Stream Mining Techniques · Machine Learning and Data Classification · Cloud Computing and Resource Management
