首页>
外国专利>
AUTOMATED CONFIGURATION PARAMETER TUNING FOR DATABASE PERFORMANCE
AUTOMATED CONFIGURATION PARAMETER TUNING FOR DATABASE PERFORMANCE
展开▼
机译:自动配置参数调整数据库性能
展开▼
页面导航
摘要
著录项
相似文献
摘要
Embodiments implement a prediction-driven, rather than a trial-driven, approach to automate database configuration parameter tuning for a database workload. This approach uses machine learning (ML) models to test performance metrics resulting from application of particular database parameters to a database workload, and does not require live trials on the DBMS managing the workload. Specifically, automatic configuration (AC) ML models are trained, using a training corpus that includes information from workloads being run by DBMSs, to predict performance metrics based on workload features and configuration parameter values. The trained AC-ML models predict performance metrics resulting from applying particular configuration parameter values to a given database workload being automatically tuned. Based on correlating changes to configuration parameter values with changes in predicted performance metrics, an optimization algorithm is used to converge to an optimal set of configuration parameters. The optimal set of configuration parameter values is automatically applied for the given workload.
展开▼