郑州大学学报（工学版）2024，Vol.45Issue(1)：1-11,28,12.DOI:10.13705/j.issn.1671-6833.2024.01.008
基于机器学习的数据库系统参数优化方法综述
A Review of Machine Learning-Based Methods for Database Tuning
摘要
Abstract
Knobs tuning is a key technology that affects the performance and adaptability of databases.However,traditional tuning methods have difficulty in finding the optimal configuration in high-dimensional continuous param-eter spaces.The development of machine learning could bring new opportunities to solve this problem.By summari-zing and analyzing relevant work,existing work was classified according to development time and characteristics,including expert decision-making,static rules,heuristic algorithms,traditional machine learning methods,and deep reinforcement learning methods.The database tuning problem was defined,and the limitations of heuristic al-gorithms in tuning problems were discussed.Traditional machine learning-based tuning methods were introduced,including random forest,support vector machine,decision tree,etc.The general process of using machine learning methods to solve tuning problems was described,and specific implementations were provided.The shortcomings of traditional machine learning models in adaptability and tuning capabilities were also discussed.The principles of deep reinforcement learning models were emphasized,and the mapping relationship between tuning problems and deep reinforcement learning models was defined.Recent relevant work on improving database performance,time consumption and model characteristics was introduced,and the process of building and training agents based on deep neural networks was described.Finally,the characteristics of existing work were summarized,and the re-search hotspots and development directions of machine learning in database tuning were outlined.Distributed sce-narios,multi-granularity tuning,adaptive algorithms and self-maintenance capabilities were identified as future re-search trends.关键词
数据库系统/参数优化/性能优化/机器学习/强化学习/数据库运维Key words
database system/knobs tuning/performance optimization/machine learning/reinforcement learning/database maintenance分类
信息技术与安全科学引用本文复制引用
石磊,李天,高宇飞,卫琳,李翠霞,陶永才..基于机器学习的数据库系统参数优化方法综述[J].郑州大学学报（工学版）,2024,45(1):1-11,28,12.基金项目
国家重点研发计划(2022YFC3800057,2020YFB1712401) （2022YFC3800057,2020YFB1712401）
