arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2407.02803cs.DB
收藏

KnobCF:不确定性感知的旋钮调优

KnobCF: Uncertainty-aware Knob Tuning

Yu Yan, Junfang Huang, Hongzhi Wang, Jian Geng, Kaixin Zhang, Tao Yu

AI总结:

本文提出 KnobCF,一种解耦的查询不确定性感知旋钮分类器,通过少样本估计减少无用配置评估,并在不修改调优器和 DBMS 的情况下提升数据库旋钮调优效率。

摘要:

旋钮调优旨在通过在特定工作负载下搜索最有效的旋钮配置来优化数据库性能。现有工作存在两个显著问题。一方面,由于旋钮在特定工作负载上具有不同的敏感性,即使采用多样化的搜索方法,旋钮调优中也会存在多次相似甚至无用的评估。另一方面,由于查询性能的不确定性,对旋钮配置的单次评估可能导致高估或低估。为解决上述问题,我们提出了一种解耦的查询不确定性感知旋钮分类器,称为 KnobCF,以增强旋钮调优。我们的方法有三项重要贡献:(1)我们提出了不确定性感知旋钮配置估计这一新概念,以增强旋钮调优过程。(2)我们提供了一种有效的少样本不确定性旋钮估计器,在训练数据收集方面不会产生额外时间消耗,在实际调优任务中具有很高的时间效率。(3)我们的方法提供了一个通用框架,可以轻松部署到任何旋钮调优任务中,因为我们不对旋钮调优器和数据库管理系统进行任何更改。我们在四个开源基准上的实验表明,该方法有效减少了无用评估并改善了调优结果。特别是在 TPCC 中,与完整工作负载评估相比,我们的方法仅以 60% 到 70% 的时间消耗就取得了具有竞争力的调优结果。

英文摘要:

The knob tuning aims to optimize database performance by searching for the most effective knob configuration under a certain workload. Existing works suffer two significant problems. On the one hand, there exist multiple similar even useless evaluations of knob tuning even with the diverse searching methods because of the different sensitivities of knobs on a certain workload. On the other hand, the single evaluation of knob configurations may bring overestimation or underestimation because of the query uncertainty performance. To solve the above problems, we propose a decoupled query uncertainty-aware knob classifier, called KnobCF, to enhance the knob tuning. Our method has three significant contributions: (1) We propose a novel concept of the uncertainty-aware knob configuration estimation to enhance the knob tuning process. (2) We provide an effective few-shot uncertainty knob estimator without extra time consumption in training data collection, which has a high time efficiency in practical tuning tasks. (3) Our method provides a general framework that could be easily deployed in any knob tuning task because we make no changes to the knob tuners and the database management system. Our experiments on four open-source benchmarks demonstrate that our method effectively reduces useless evaluations and improves the tuning results. Especially in TPCC, our method achieves competitive tuning results with only 60% to 70% time consumption compared to the full workload evaluations.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑