Slow query processing method and system and related equipment

The invention provides a slow query processing method and system, a computer readable storage medium and electronic equipment, and relates to the technical field of communication, the method comprises the following steps: analyzing user login historical query data to obtain a slow query risk value o...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: WEN ZHANPENG, LIU DONGXIN, XIA JINHUI, WANG LAIFU
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 provides a slow query processing method and system, a computer readable storage medium and electronic equipment, and relates to the technical field of communication, the method comprises the following steps: analyzing user login historical query data to obtain a slow query risk value of a query request; distributing the query request to a slow query thread unit for execution according to the slow query risk value; and performing arrangement caching processing on the execution statements in the slow query thread according to the query request, wherein the statements with relatively large weight values are executed preferentially. According to the method, the slow query risk value of the query request can be predicted by analyzing the user login historical query data, compared with the prediction result of the query request without reference to historical data, the prediction result of the query request is more verified, and the slow query processing quality is improved. And furthermore, the slow