Pith. sign in

REVIEW 4 cited by

Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation

Not yet reviewed by Pith; the record is open.

Re-run · record.json Download PDF Read on arXiv ↗

This paper has not been read by Pith yet. Machine review is queued; the pith claim, tier, and objections will appear here once it completes.

SPECIMEN: schema-true, not a live event

T0 review · schema-true

One-sentence machine reading of the paper's core claim.

pith:XXXXXXXX · record.json · timestamp

arxiv 2110.12654 v4 pith:QN7ZFSIM submitted 2021-10-25 cs.DB

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 This is my paper
classification cs.DB
keywords databasetuningconfigurationevaluationsystemscomprehensivealgorithmalgorithms
verification ladder T0 review T1 audit T2 compute T3 formal T4 reserved
0 comments
read the original 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 evaluation demonstrates that the hyper-parameter optimization algorithms can be borrowed to further enhance the database configuration tuning. Moreover, we identify the best algorithm choices for different modules. Beyond the comprehensive evaluations, we offer an efficient and unified database configuration tuning benchmark via surrogates that reduces the evaluation cost to a minimum, allowing for extensive runs and analysis of new techniques.

discussion (0)

Sign in with ORCID, Apple, or X to comment. Anyone can read and Pith papers without signing in.

Forward citations

Cited by 4 Pith papers

Reviewed papers in the Pith corpus that reference this work. Sorted by Pith novelty score.

  1. When to Use Which? Benchmarking Optimisers for Configurable Systems under Varying Budgets

    cs.SE 2026-07 conditional novelty 6.0

    Across 22 configurable systems and budgets from 100 to 10,000 evaluations, FLASH is the most consistently effective optimiser, while GA and IRACE catch up only at large budgets.

  2. AgenticDB: Self-Evolving Reconfiguration Framework for Database Workloads

    cs.DB 2026-06 unverdicted novelty 6.0

    AgenticDB introduces an agentic AI system that interactively reconfigures MySQL and PostgreSQL workloads using DBMS and OS changes guided by runtime feedback, outperforming baselines by 118.1% on average.

  3. AgenticDB: Self-Evolving Reconfiguration Framework for Database Workloads

    cs.DB 2026-06 conditional novelty 5.5

    A context-grounded agent that retunes DBMS and OS parameters from runtime bottleneck evidence beats prior database tuners by 118% on average across MySQL and PostgreSQL workloads.

  4. AgenticDB: Self-Evolving Reconfiguration Framework for Database Workloads

    cs.DB 2026-06 unverdicted novelty 5.0

    AgenticDB deploys an agent that interacts with databases to reconfigure DBMS and OS settings using runtime feedback, outperforming baselines by 118.1% on average across MySQL, PostgreSQL, YCSB, Sysbench, and TPC-H workloads.