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