arXiv:2603.15540cs.DBcs.AI2026-03

动态筛选调优参数,无需预热快速优化数据库性能

DOT: Dynamic Knob Selection and Online Sampling for Automated Database Tuning

  • 用递归特征消除与似然比测试动态筛选关键参数
  • 基于贝叶斯优化在线搜索,显著降低调优开销
  • 适合追求高效自动调优的数据库管理员使用

数据库管理系统(DBMS)在数据管理中至关重要,但其运维对数据库管理员(DBA)仍具挑战性,尤其是调优环节。现代系统拥有大量调优参数,但仅有少数对性能有显著影响。聚焦这些关键参数可缩小搜索空间并提升性能。现有方法依赖昂贵的预热阶段和人工经验来识别重要参数。本文提出DOT算法,采用递归特征消除结合交叉验证(RFECV)剔除低影响力参数,并运用似然比测试(LRT)策略平衡探索与利用。参数搜索采用贝叶斯优化(BO)在线动态调整配置,无需预热或先验知识(尽管可融入已有知识)。实验表明,DOT在性能上达到或优于当前最先进调优器,同时大幅降低调优开销。

原文摘要 · Abstract (English)

Database Management Systems (DBMS) are crucial for efficient data management and access control, but their administration remains challenging for Database Administrators (DBAs). Tuning, in particular, is known to be difficult. Modern systems have many tuning parameters, but only a subset significantly impacts performance. Focusing on these influential parameters reduces the search space and optimizes performance. Current methods rely on costly warm-up phases and human expertise to identify important tuning parameters. In this paper, we present DOT, a dynamic knob selection and online sampling DBMS tuning algorithm. DOT uses Recursive Feature Elimination with Cross-Validation (RFECV) to prune low-importance tuning parameters and a Likelihood Ratio Test (LRT) strategy to balance exploration and exploitation. For parameter search, DOT uses a Bayesian Optimization (BO) algorithm to optimize configurations on-the-fly, eliminating the need for warm-up phases or prior knowledge (although existing knowledge can be incorporated). Experiments show that DOT achieves matching or outperforming performance compared to state-of-the-art tuners while substantially reducing tuning overhead.

数据库调优贝叶斯优化自动化

Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。