Title:
SLOW QUERY ALARM METHOD, ELECTRONIC DEVICE, AND STORAGE MEDIUM
Document Type and Number:
WIPO Patent Application WO/2023/077823
Kind Code:
A1
Abstract:
Disclosed in the embodiments of the present application are a slow query alarm method, an electronic device, and a storage medium. The slow query alarm method comprises: on the basis of a first average duration, which is consumed for executing a first SQL statement in a unit duration within a first set statistical period, determining a first amplification corresponding to a first average duration of every two adjacent days; on the basis of the determined first amplification, determining a first mean value regarding the first amplification; on the basis of the first mean value, a first average duration corresponding to a first date, and a first threshold value, predicting a corresponding second date when the first SQL statement is a slow query, wherein the first threshold value represents critical time consumption of the slow query, the first date represents the last day of the first set statistical period, and the second date is after the first date; and before the second date, outputting a slow query early warning prompt regarding the corresponding first SQL statement.
Inventors:
CAO WEI (CN)
Application Number:
PCT/CN2022/099854
Publication Date:
May 11, 2023
Filing Date:
June 20, 2022
Export Citation:
Assignee:
WEBANK CO LTD (CN)
International Classes:
G06F16/242; G06F16/2453; G06F16/2455
Foreign References:
| CN114185919A | 2022-03-15 | |||
| CN112380237A | 2021-02-19 | |||
| CN110019349A | 2019-07-16 | |||
| CN113220705A | 2021-08-06 | |||
| US20180322154A1 | 2018-11-08 |
Attorney, Agent or Firm:
CHINA PAT INTELLECTUAL PROPERTY OFFICE (CN)
Download PDF: