arXiv:2510.27145cs.LGcs.DB2025-10

用关系图与亲和度评分优化数据库配置,提升调优速度与效果。

Relation-Aware Bayesian Optimization of DBMS Configurations Guided by Affinity Scores

  • 构建参数关系图,用图神经网络捕捉性能相关语义。
  • 结合代理模型与亲和度评分,使调优更快收敛且更高效。
  • 适合需要快速调优数据库的系统工程师或运维人员。

数据库管理系统(DBMS)对大规模异构数据管理至关重要,其性能受配置参数影响显著。有效调优这些参数对适应不同工作负载、提升吞吐量并降低延迟至关重要。尽管已有研究采用机器学习实现自动化配置优化,但现有方法仍存在关键局限:多数框架忽略参数间的依赖关系,假设各参数独立作用,无法利用参数间的关联效应;为降低高维搜索空间复杂度,先前工作常仅选择少数关键参数优化,忽略了对性能有贡献的其他参数;贝叶斯优化(BO)作为主流方法,受限于代理模型,易导致预测不稳定和探索效率低。为此,我们提出RelTune框架,将参数依赖关系表示为关系图,并学习基于图神经网络的潜在嵌入以编码性能相关语义。RelTune进一步引入混合得分引导的贝叶斯优化(HBO),融合代理模型预测与衡量配置接近历史高性能配置程度的亲和度评分。在多个DBMS和工作负载上的实验表明,RelTune相比传统基于BO的方法实现更快收敛与更高优化效率,在所有评估场景中均达到当前最优表现。

原文摘要 · Abstract (English)

Database Management Systems (DBMSs) are fundamental for managing large-scale and heterogeneous data, and their performance is critically influenced by configuration parameters. Effective tuning of these parameters is essential for adapting to diverse workloads and maximizing throughput while minimizing latency. Recent research has focused on automated configuration optimization using machine learning; however, existing approaches still exhibit several key limitations. Most tuning frameworks disregard the dependencies among parameters, assuming that each operates independently. This simplification prevents optimizers from leveraging relational effects across parameters, limiting their capacity to capture performancesensitive interactions. Moreover, to reduce the complexity of the high-dimensional search space, prior work often selects only the top few parameters for optimization, overlooking others that contribute meaningfully to performance. Bayesian Optimization (BO), the most common method for automatic tuning, is also constrained by its reliance on surrogate models, which can lead to unstable predictions and inefficient exploration. To overcome these limitations, we propose RelTune, a novel framework that represents parameter dependencies as a Relational Graph and learns GNN-based latent embeddings that encode performancerelevant semantics. RelTune further introduces Hybrid-Score-Guided Bayesian Optimization (HBO), which combines surrogate predictions with an Affinity Score measuring proximity to previously high-performing configurations. Experimental results on multiple DBMSs and workloads demonstrate that RelTune achieves faster convergence and higher optimization efficiency than conventional BO-based methods, achieving state-of-the-art performance across all evaluated scenarios.

数据库优化贝叶斯优化图神经网络

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