Slow inquiry information retrieval method, device, server and readable storage medium

Abstract

The embodiment of the invention provides a slow query information retrieval method, a device, a server and a readable storage medium. The server is provided with a slow query scheduling strategy and asearch server. The method comprises the following steps of: acquiring the slow query information of all Mongodb instances based on the slow query scheduling strategy; transferring the slow query information of all Mongodb instances into a search server; obtaining a retrieval filtering condition from the slow query information retrieval request when receiving a slow query information retrieval request sent by a user terminal; retrieving the corresponding slow query information from the search server based on the retrieval filtering condition, and sending the retrieved slow query information tothe user terminal for display. According to the invention, when the slow query information is retrieved, the slow query recording parameter is not required to be started, the retrieval efficiency ofthe slow query information can be greatly improved, the system problem is convenient to be check in time, and the potential safety hazard caused by directly connecting the database can be avoided.

Description

technical field [0001] The present invention relates to the technical field of data processing, and in particular, to a slow query information retrieval method, device, server and readable storage medium. Background technique [0002] There are two methods for the current Mongodb slow query recording method. Turn on the Profiling function or add the parameter –slowms at startup. In actual implementation, when performance problems occur and need to check the slow query, it is often necessary to manually connect to the corresponding database instance. , run the db.system.profile.find() statement to query. [0003] The inventors of the present application have found in actual research that the above solution has many drawbacks: firstly, if the slow query record parameter is always enabled, the set corresponding to the database will keep growing, which is very unfavorable for instance maintenance. The second is that if there is a problem with the system, if you turn on the slow...

AI Technical Summary

Problems solved by technology

[0003] The inventors of the present application have found in actual research that the above-mentioned scheme has many disadvantages: first, if the slow query record parameter is always enabled, the corresponding collection of the database will continue to grow, which is very unfavorable for the maintenance of the instance

The second is that if there is a problem in the system, if you turn on the slow query parameter to obtain the slow query statement, it will take a long time to troubleshoot the problem, and historical problems cannot be traced back

The third is that since it is necessary to connect to the Mongodb database and input commands every time, it is necessary to enable the permission to connect to the database for each member who wants to view slow queries. For online data, this method will bring great safety hazard

Images