arXiv:2603.28809cs.DBcs.AI2026-03

WAter通过压缩工作负载,大幅降低数据库参数调优时间。

WAter: A Workload-Adaptive Knob Tuning System based on Workload Compression

  • 分时段评估工作负载的子集,动态选择更具代表性查询
  • 相比顶尖方法减少73.5%调优时间,性能提升最高16.2%
  • 适合需要快速调优的生产环境数据库系统

为提升数据库管理系统(DBMS)性能而调整可配置参数是一项挑战。现有基于机器学习的调优系统虽具潜力,但因调优成本高而难以应用。主要源于两点:一是需评估大量配置,二是每配置需完整执行目标工作负载,耗时长。已有研究多聚焦于提升采样效率,减少配置评估次数,但对降低单次评估耗时的关注较少。我们提出WAter,一个运行时高效且工作负载自适应的调优系统,能在远低于现有最优方法的调优成本下找到近优配置。将调优过程划分为多个时间片,每片仅评估工作负载中一小部分查询,不同时间片使用不同子集,并利用运行时特征动态识别后续更具有代表性的子集。每个时间片末尾,对最有望的配置在原始工作负载上进行实际性能评估。实验表明,WAter以最多73.5%的调优时间开销,识别出表现最佳的配置,性能较最优替代方案最高提升16.2%。

原文摘要 · Abstract (English)

Selecting appropriate values for the configurable parameters of Database Management Systems (DBMS) to improve performance is a significant challenge. Recent machine learning (ML)-based tuning systems have shown strong potential, but their practical adoption is often limited by the high tuning cost. This cost arises from two main factors: (1) the system needs to evaluate a large number of configurations to identify a satisfactory one, and (2) for each configuration, the system must execute the entire target workload on the DBMS, which is both time-consuming. Existing studies have primarily addressed the first factor by improving sample efficiency, that is, by reducing the number of configurations evaluated. However, the second factor, improving runtime efficiency by reducing the time required for each evaluation, has received limited attention and remains an underexplored direction. We develop WAter, a runtime-efficient and workload-adaptive tuning system that finds near-optimal configurations at a fraction of the tuning cost compared with state-of-the-art methods. We divide the tuning process into multiple time slices and evaluate only a small subset of queries from the workload in each slice. Different subsets are evaluated across slices, and a runtime profile is used to dynamically identify more representative subsets for evaluation in subsequent slices. At the end of each time slice, the most promising configurations are evaluated on the original workload to measure their actual performance. Evaluations demonstrate that WAter identifies the best-performing configurations with up to 73.5% less tuning time and achieves up to 16.2% higher performance than the best-performing alternative.

数据库参数调优运行时优化

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