Database parameter configuration automatic tuning method and system

The invention discloses a database parameter configuration automatic tuning method and system, equipment and a storage medium, and the method comprises the following steps: (1) dividing database samples into a plurality of classes according to a set sample classification rule, and generating a plura...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZHANG CHEN, MA LAN, WANG LICHEN, DAI TIECHAO, WANG HONGKAI, LI YAN, YANG WENQING, PENG LIANGYING
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:The invention discloses a database parameter configuration automatic tuning method and system, equipment and a storage medium, and the method comprises the following steps: (1) dividing database samples into a plurality of classes according to a set sample classification rule, and generating a plurality of classes of database samples by using a benchmark test tool; (2) taking a plurality of types of database samples as input, and training by utilizing the established tuning model to generate a plurality of sample tuning models; (3) acquiring actual database information, and comparing the actual database with the sample database according to the tuning trigger condition; (4) outputting the optimal database parameter configuration of the current tuning interval, and applying the parameter configuration to the current database; according to the method, the automatic tuning process of the database parameter configuration is realized, the performance of the database is improved, meanwhile, the tuning difficulty of