Slow query log processing method, device and electronic device

Abstract

An embodiment of the invention discloses a slow query log processing method, a device and an electronic device. The method includes steps of acquiring a slow query log; confirming a record object corresponding to the slow query log; executing preset treatment on the recording object corresponding to the slow query log. According to the technical scheme provided by the embodiment of the invention,the request or command with long executing time and too slow response speed is automatically processed regularly, thus the normal storage of the slow log can be guaranteed, the length of the slow query buffer queue is controlled within a reasonable scale; besides, the request or command with too long executing time and too slow response speed can be timely evacuated, thereby avoiding blocking other operations and influencing and even blocking the system process, and effectively improving the running efficiency of the system.

Description

technical field [0001] The present disclosure relates to the technical field of data processing, in particular to a slow query log processing method, device and electronic equipment. Background technique [0002] With the development of Internet technology and the widespread use of digital devices such as smart phones, a large amount of data is stored in a specific database and requested and called. For example, a large amount of key-value data is stored in the Redis database for requests and calls. However, Redis is a single-process storage system. If some data requests take too long to execute, it will affect the entire system process. The slowlog (slow query) data in the Redis system records requests or commands whose execution time exceeds the specified time and some related information. Therefore, related technologies read the slow log data to understand which requests or commands take too long to execute, but only It's not enough to know who the request or order is t...

AI Technical Summary

Problems solved by technology

But Redis is a single-process storage system. If some data requests take too long to execute, it will affect the process of the entire system.

The slowlog (slow query) data in the Redis system records requests or commands whose execution time exceeds the specified time and some related information. Therefore, related technologies read the slow log data to understand which requests or commands take too long to execute, but only It is not enough to know who the request or order is that is taking longer than the specified amount of time

[0003] In addition, due to the weak function of the slowlog data itself, it is a fixed-length circular queue. When there are too many slow operations, it is very easy to overwrite the data. Increasing the slow query cache queue will increase the consumption of Redis memory resources, and some too slow operations may cause Block other operations, if the slow operation is not handled in time, it will affect or even block the process of the system

Images