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...
Gespeichert in:
Hauptverfasser: | , , , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
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 |
---|