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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: DENG GENQIANG
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 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