Intelligent identification method and device for abnormal SQL, electronic equipment and storage medium
The invention relates to the field of big data, and discloses an intelligent identification method for an abnormal SQL, which comprises the following steps of: recording execution plan information of an SQL in response to an execution plan change operation of the SQL in a database so as to configure...
Gespeichert in:
1. Verfasser: | |
---|---|
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 relates to the field of big data, and discloses an intelligent identification method for an abnormal SQL, which comprises the following steps of: recording execution plan information of an SQL in response to an execution plan change operation of the SQL in a database so as to configure an execution plan information table of the SQL; querying the latest execution plan of the SQL from the execution plan information table; searching all original execution plans of the SQL in the database, and identifying an optimal execution plan in the original execution plans; when the newest execution plan is consistent with the optimal execution plan, taking the newest execution plan as a normal execution plan to access a database; and when the newest execution plan is inconsistent with the optimal execution plan, taking the newest execution plan as an abnormal execution plan, and determining a final execution plan for the SQL to access the database according to the change information of the abnormal execution |
---|