Search papers, labs, and topics across Lattice.
This paper introduces DOT, a novel DBMS tuning algorithm that dynamically selects important tuning parameters using Recursive Feature Elimination with Cross-Validation (RFECV) and balances exploration/exploitation via a Likelihood Ratio Test (LRT). DOT employs Bayesian Optimization (BO) for on-the-fly configuration optimization, eliminating the need for warm-up phases. Experiments demonstrate that DOT matches or surpasses state-of-the-art tuners while significantly reducing tuning overhead.
Database tuning just got easier: DOT dynamically identifies and optimizes key parameters on-the-fly, outperforming existing methods without the need for costly warm-up phases.
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.
