一种基于综合调优的数据库性能趋势预测方法

A Time Series Prediction Approach Based on Hybrid Tuning for Database Performance Indicator in AIOps

云数据库智能运维中的重要应用场景之一是对监控采集的大量性能时序数据进行趋势预测。提出一种基于Prophet模型和ARIMA模型的综合调优智能趋势预测方法AutoPA4DB(auto prophet and ARIMA for database)。该方法根据数据库性能监控数据的特征,进行了原始监控数据的预处理、预测模型自动调参和模型优化。采用加权的时序预测准确性度量WMC(weighted MAPE coverage),基于多个企业级数据库实例(包含10种性能指标)进行了实验验证。实验对比了5种不同时序模型的预测效果,结果表明在单调变化模式(如磁盘使用量)的数据中,文中提出的AutoPA4DB方法时序预测准确性最高;然而在震荡模式的数据中,预测效果不太稳定,例如内存使用率趋势预测效果较好,但数据库连接数趋势预测效果不理想。

One of the most important applications of the intelligent operation and maintenance of a cloud database is its trend prediction of key performance indicators(KPI),such as disk use,memory use,etc.We propose a meth⁃od named AutoPA4DB(Auto Prophet and ARIMA for Database)to predict the trend of the KPIs of the cloud data⁃base based on the Prophet model and the ARIMA model.Our AutoPA4DB method includes data preprocessing,model building,parameter tuning and optimization.We employ the weighted MAPE coverage to measure its accura⁃cy and use 6 industrial datasets including 10 KPIs to compare the AutoPA4DB method with other three time⁃series trend prediction algorithms.The experimental results show that our AutoPA4DB method performs best in predicting monotonic variation data,e.g.disk use trend prediction.But it is unstable in predicting oscillatory variation data;for example,it is acceptable in memory use trend prediction but has poor accuracy in predicting the number of data⁃base connection trends.