WO2022111265A1

WO2022111265A1 - Information alerting method and device, and storage medium

Info

Publication number: WO2022111265A1
Application number: PCT/CN2021/129296
Authority: WO
Inventors: 李云龙; 胡盼盼; 卢道和
Original assignee: 深圳前海微众银行股份有限公司
Priority date: 2020-11-25
Filing date: 2021-11-08
Publication date: 2022-06-02
Also published as: CN112433919B; CN112433919A

Abstract

Disclosed in embodiments of the present application is an information alerting method. The method comprises: acquiring a target monitoring index of a target monitoring object according to a first sampling interval, so as to obtain a first monitoring value of a current moment; obtaining a first historical monitoring value which is obtained by acquiring the target monitoring index at a historical moment; determining a target threshold on the basis of the first monitoring value and the first historical monitoring value, wherein the target threshold comprises at least one different threshold; determining alert information on the basis of the first monitoring value and the target threshold, wherein the alert information is used for sending an alert for the target monitoring index of the target monitoring object; and display the alert information. Also disclosed in the embodiments of the present application are an information alerting device and a storage medium.

Description

An information alarm method, device and storage medium

CROSS-REFERENCE TO RELATED APPLICATIONS

This application is based on the Chinese patent application with the application number of 202011340177.8 and the filing date of November 25, 2020, and claims the priority of the Chinese patent application. The entire content of the Chinese patent application is incorporated herein by reference.

technical field

The present application relates to the technical field of computer applications, and in particular, to an information alarm method, device and storage medium.

Background technique

With the rapid development of computer technology, more and more technologies are applied in the financial field, and the traditional financial industry is gradually transforming into financial technology (Fintech). high demands. With the rapid development of Internet technology, the application of database is more and more indispensable, so the monitoring of database becomes more and more important. At present, the process of monitoring whether the database is abnormal is mainly realized by judging whether the database index value exceeds the corresponding fixed threshold, or whether the year-on-year growth ratio exceeds the corresponding fixed threshold.

However, during the current database use process, due to the large changes in the request volume of the database in different time periods, the request process in different time periods may exhibit a certain periodicity. For example, the early morning is a low business peak period, and the daytime is a business peak period. For example, the batch tasks of the bank at night will lead to a large amount of requests. In this way, when abnormal monitoring of the database is performed, the database index value is compared with the corresponding fixed threshold value. , resulting in the inability to accurately realize the alarm requirements of the database in each time period, resulting in a high alarm error rate.

SUMMARY OF THE INVENTION

In order to solve the above technical problems, the embodiments of the present application expect to provide an information alarm method, device, and storage medium, which solve the problem that the current use of fixed thresholds to implement database monitoring results in the inability to accurately realize the alarm requirements of the database in various time periods, and achieve The scheme of adaptively adjusting the threshold according to the actual situation to realize the database monitoring scheme effectively improves the accuracy of the database alarm.

The technical solution of the present application is realized as follows:

In a first aspect, an information alarm method, the method includes:

Collect the target monitoring index of the target monitoring object according to the first sampling interval, and obtain the first monitoring value at the current moment;

Obtain the first historical monitoring value obtained by collecting the target monitoring index at historical time;

A target threshold is determined based on the first monitoring value and the first historical monitoring value; wherein the target threshold includes at least one different threshold;

Determine alarm prompt information based on the first monitoring value and the target threshold; wherein, the alarm prompt information is used to provide an alarm prompt for the target monitoring indicator of the target monitoring object;

The alarm prompt information is displayed.

In a second aspect, an information alarm device, the device includes a memory, a processor and a communication bus; wherein:

the memory for storing executable instructions;

the communication bus for realizing the communication connection between the processor and the memory;

The processor is configured to execute the information alarm program stored in the memory to implement the steps of the information alarm method according to any one of the above.

In a third aspect, a storage medium stores an information alarm program, and when the information alarm program is executed by a processor, implements the steps of the information alarm method described in any one of the above.

In the embodiment of the present application, the information alarm device collects the target monitoring index of the target monitoring object according to the first sampling interval, and after obtaining the first monitoring value at the current moment, obtains the first historical monitoring value obtained by collecting the target monitoring index at the historical moment, And based on the first monitoring value and the first historical monitoring value, a target threshold is determined, then based on the first monitoring value and the target threshold, alarm prompt information is determined, and finally the alarm prompt information is displayed. In this way, the information alarm device dynamically determines the target threshold value according to the first monitoring value at the current moment and the first historical monitoring value at the historical moment in real time, and generates alarm prompt information according to the relationship between the target threshold value and the first monitoring value, which solves the problem. The current use of fixed thresholds to achieve database monitoring leads to the problem that the alarm requirements of the database in various time periods cannot be accurately realized. The solution of adaptively adjusting the thresholds to realize database monitoring according to the actual situation is realized, which effectively improves the accuracy of database alarms.

Description of drawings

FIG. 1 is a schematic flowchart of an information alarm method provided by an embodiment of the present application;

FIG. 2 is a schematic flowchart of another information alarm method provided by an embodiment of the present application;

FIG. 3 is a schematic flowchart of another information alarm method provided by an embodiment of the present application;

FIG. 4 is a schematic flowchart of an information alarm method provided by another embodiment of the present application;

FIG. 5 is a schematic flowchart of another information alarm method provided by another embodiment of the present application;

FIG. 6 is a schematic flowchart of still another information alarm method provided by another embodiment of the present application;

FIG. 7 is a schematic structural diagram of an information alarm device according to an embodiment of the present application.

Detailed ways

In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be described in further detail below with reference to the accompanying drawings. All other embodiments obtained under the premise of creative work fall within the scope of protection of the present application.

Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the technical field to which this application belongs. The terms used herein are only for the purpose of describing the embodiments of the present application, and are not intended to limit the present application.

An embodiment of the present application provides an information alarm method. Referring to FIG. 1 , the method is applied to an information alarm device, and the method includes the following steps:

Step 101: Collect the target monitoring index of the target monitoring object according to the first sampling interval, and obtain the first monitoring value at the current moment.

In this embodiment of the present application, the information alarm device may be a device that runs the target monitoring object, for example, a server, or a device with running capabilities such as a computer device. The target monitoring object can be an application program, which can run on the information alarm device. The target monitoring indicator can be the resources consumed by the information alarm device when running the target monitoring object, such as central processing unit (CPU) resources to be occupied, including the number of CPUs, that is, the number of cores and/or the running time of the CPU, etc. It is input and output (Input Output) resources, etc. The target monitoring indicators can be set by default in advance, or can be set by the user according to the actual monitoring needs. The first sampling interval is the sampling frequency used to collect the target monitoring indicators of the target monitoring object. It can be set by the user, or it can be an empirical value obtained from a large number of experiments or actual experience. Usually, the first sampling interval cannot be too small. The frequency should not be too high, in order to avoid increasing the monitoring pressure caused by the information alarm equipment monitoring the target monitoring object. In the actual application process, the first sampling interval can be continuously corrected or the user can continuously modify according to actual monitoring requirements.

Step 102: Obtain the first historical monitoring value obtained by collecting the target monitoring index at historical time.

In the embodiment of the present application, when collecting the target monitoring index, the information alarm device will store the collected monitoring value, so that the first historical monitoring value collected at historical time can be obtained. The first historical monitoring value may be a monitoring value within a period of time before the current moment.

Step 103: Determine a target threshold based on the first monitoring value and the first historical monitoring value.

Wherein, the target threshold includes at least one different threshold.

In the embodiment of the present application, the information alarm device analyzes and processes the first monitoring value at the current moment and the first historical monitoring value at the historical moment to obtain the target threshold. In this way, the target threshold is dynamically determined according to the monitoring value collected at the current moment and the historical monitoring value at the historical moment.

Step 104: Determine alarm prompt information based on the first monitoring value and the target threshold.

The alarm prompt information is used to provide an alarm prompt for the target monitoring indicator of the target monitoring object.

In the embodiment of the present application, after the target threshold is determined, the range of the target threshold where the first monitoring value is located is determined, so as to determine the corresponding alarm level, and generate corresponding alarm prompt information, so as to prompt the user through the alarm prompt information whether the target monitoring object is If there is a risk, whether it is necessary to eliminate the risk of the target monitoring object in time.

Step 105 , displaying alarm prompt information.

In this embodiment of the present application, after the information alarm device generates the alarm prompt information, the alarm prompt information may be displayed in a display area corresponding to the information alarm device. The display area corresponding to the information alarm device may be the display screen of the information alarm device, or may be other devices with display functions that have a communication connection with the information alarm device, such as a mobile communication device that has a communication connection with the information alarm device, that is, After the information alarm device generates the alarm prompt information, it sends the alarm prompt information to the mobile communication device having a communication connection with the information alarm device, so as to display the alarm prompt information through the mobile communication device.

In the embodiment of the present application, the information alarm device collects the target monitoring object according to the first sampling interval, and after obtaining the first monitoring value of the target monitoring indicator at the current moment, obtains the first historical monitoring value obtained by collecting the target monitoring indicator at the historical moment, and based on A target threshold is determined for the first monitoring value and the first historical monitoring value, then based on the first monitoring value and the target threshold, alarm prompt information is determined, and finally the alarm prompt information is displayed. In this way, the information alarm device dynamically determines the target threshold value according to the first monitoring value at the current moment and the first historical monitoring value at the historical moment in real time, and generates alarm prompt information according to the relationship between the target threshold value and the first monitoring value, which solves the problem. The current use of fixed thresholds to achieve database monitoring leads to the problem that the alarm requirements of the database in various time periods cannot be accurately realized. The solution of adaptively adjusting the thresholds to realize database monitoring according to the actual situation is realized, which effectively improves the accuracy of database alarms.

Based on the foregoing embodiments, the embodiments of the present application provide an information alarm method. Referring to FIG. 2 , the method is applied to an information alarm device, and the method includes the following steps:

Step 201: Collect the target monitoring index of the target monitoring object according to the first sampling interval, and obtain the first monitoring value at the current moment.

In the embodiment of the present application, the information alarm device is a server and the target monitoring object is a database as an example for illustration. When the server runs the database, the server is set to collect the target monitoring indicators of the database at the first sampling interval. In this way, the current data can be obtained. The first monitored value at the moment. Target monitoring metrics can include at least one of the following: server CPU usage and/or IO usage. It should be noted that, after the information alarm device collects the first monitoring value at the current moment, the first monitoring value is stored for subsequent analysis and use.

Step 202: Obtain the first historical monitoring value obtained by collecting the target monitoring index at historical time.

In the embodiment of the present application, the server obtains the monitoring value of the target monitoring collected and stored at the historical moment from the storage area, and obtains the first historical monitoring value. The storage area can be a local storage area of the server or a cloud storage area that the server can access.

Step 203: Acquire a second monitoring value at the current moment of the reference monitoring index of the target monitoring object and a second historical monitoring value collected by referring to the historical moment of the monitoring index.

The reference monitoring index and the target monitoring index have an associated relationship.

In the embodiment of the present application, the reference monitoring indicator of the target monitoring object may be other indicators of the target monitoring object except the target monitoring indicator, and the reference monitoring indicator has a certain influence on the target monitoring indicator. The information alarm device also collects the reference monitoring index of the target monitoring object at the first sampling interval, so that the second monitoring value of the reference monitoring index at the current moment and the second historical monitoring value at the historical moment can be obtained. It should be noted that when acquiring the second historical monitoring value of the reference monitoring index historical time, the historical time of the second historical monitoring value and the historical time of the first historical monitoring value of the target monitoring time correspond one-to-one. The reference monitoring indicator can be the total request volume indicator in the database. Exemplarily, the first historical monitoring value collected for the target monitoring indicator and the second historical monitoring value collected for the reference monitoring indicator within a period of time before the current moment, such as within one month, are acquired. The relationship between the reference monitoring indicator and the target monitoring indicator means that the change of the reference monitoring indicator will affect the change of the target monitoring indicator. For example, when the database is running normally, the CPU usage and IO usage of the server will maintain a certain positive correlation with the total request volume of the database. When the database is running abnormally, the total request volume of the database will decrease. CPU usage and IO usage increase instead.

Step 204: Determine the target weight coefficient based on the first monitoring value, the first historical monitoring value, the second monitoring value and the second historical monitoring value.

In the embodiment of the present application, the server analyzes the first monitoring value, the first historical monitoring value, the second monitoring value and the second historical monitoring value to obtain the target weight coefficient.

Step 205: Determine a first reference value based on the first historical monitoring value.

In the embodiment of the present application, the information alarm device analyzes the first historical monitoring value to obtain the first reference value.

Step 206: From the first historical monitoring value, obtain the first historical sub-monitoring value of the previous moment adjacent to the current moment.

In the embodiment of the present application, the first sampling interval is 1 minute as an example for illustration, and from the first historical monitoring value, obtain the current time at 14:00 on November 11 at 14:00 at the previous time at 13:00 on November 11: The first history sub-monitor value of 59.

Step 207: Determine the difference between the first monitoring value and the first historical sub-monitoring value to obtain a second reference value.

In the embodiment of the present application, the second reference value is obtained by calculating the formula "second reference value=first monitoring value-first historical sub-monitoring value".

Step 208: Obtain a target threshold based on the target weight coefficient, the second reference value, the first monitoring value, at least one preset weight coefficient and the first reference value.

Wherein, the target threshold includes at least one different threshold.

In the embodiment of the present application, the target weight coefficient, the second reference value, the first monitoring value, the at least one preset weight coefficient, and the first reference value are analyzed and calculated to obtain a target threshold value including at least one different threshold value, and the target threshold value includes The number of thresholds is the same as the number of at least one preset weight coefficient. Assuming that at least one preset weight coefficient includes two different preset weight coefficients, which are preset weight coefficient 1 and preset weight coefficient 2, in this way, according to preset weight coefficient 1, target weight coefficient, second reference value, first A monitoring value and a first reference value, one of a target threshold value can be determined, and a target threshold value can be determined according to the preset weight coefficient 2, the target weight coefficient, the second reference value, the first monitoring value and the first reference value another threshold in .

Step 209: Determine alarm prompt information based on the first monitoring value and the target threshold.

Step 210 , displaying alarm prompt information.

In the embodiment of the present application, when determining the target threshold value corresponding to the target monitoring indicator, in addition to analyzing the first monitoring value and the corresponding first historical monitoring value corresponding to the target monitoring indicator at the current moment, the relationship with the target monitoring indicator is also considered. The second monitoring value at the current moment and the corresponding second historical monitoring value of the reference monitoring index of the relationship, so that the target threshold value that is more in line with the actual application situation can be obtained, the reliability of the target threshold value is effectively improved, and the automatic Accuracy of alerts.

Based on the foregoing embodiments, in other embodiments of the present application, step 204 may be implemented by steps a11 to a14:

Step a11: Process the first monitoring value and the first historical monitoring value by determining the difference between the monitoring value at the second moment and the monitoring value at the first moment to obtain the second difference value of the target monitoring index at different times.

The first moment and the second moment are two adjacent moments, and the first moment is farther from the current moment than the second moment is from the current moment.

In the embodiment of the present application, for the monitoring values at any two adjacent moments between the first monitoring value and the first historical monitoring value, the monitoring value at the next moment, that is, the monitoring value at the second moment minus the monitoring value at the previous moment is adopted. The value is the calculation method of the monitoring value at the next moment, and it is determined to obtain the second difference value at different times.

Step a12: Process the second monitoring value and the second historical monitoring value by determining the difference between the monitoring value at the second moment and the monitoring value at the first moment to obtain the third difference value of the reference monitoring index at different times.

In the embodiment of the present application, for the monitoring values at any two adjacent moments in the second monitoring value and the second historical monitoring value, the monitoring value at the next moment is used, that is, the monitoring value at the second moment minus the monitoring value at the previous moment. The value is the calculation method of the monitoring value at the first moment, and it is determined to obtain the third difference value at different moments.

Step a13: Determine the ratio of the third difference and the second difference at the same moment to obtain a reference ratio.

In the embodiment of the present application, since the reference monitoring index and the target monitoring index at the same time have the effect of mutual restriction and mutual influence, the ratio calculation is performed on the obtained third difference value and the second difference value at the same time. , to get the reference ratio.

Step a14: Determine the target weight coefficient based on the reference ratio.

Based on the foregoing embodiments, in other embodiments of the present application, step a14 may be implemented by steps a141 to a142:

Step a141: Obtain from the reference ratio a second preset number of target ratios whose ratios are greater than zero and are closest to the current moment.

In this embodiment of the present application, the second preset number may be an empirical value obtained from a large number of experiments or actual application scenarios, or may be set by the user according to actual needs. If the reference ratio is greater than zero, it can indicate that the target monitoring object is running in a normal working state. At adjacent moments, the running state of the target monitoring object generally does not have major problems suddenly. Therefore, the ratio of the second preset number that is closer to the current moment in the normal working state can be obtained, and the second preset number can be obtained. number of target ratios.

Step a142: Obtain a target weight coefficient based on the second preset number of target ratios.

In the embodiment of the present application, a preset processing method is used to process the second preset number of target ratios to obtain a value, and the value is used as the target weight coefficient. The preset processing method may be, for example, calculating an average value after summation, or calculating an average value after weighted summation, or a mathematical statistical induction method such as standard deviation.

In other embodiments of the present application, step a142 may be implemented by the following steps: determining an average value of a second preset number of target ratios to obtain a target weight coefficient.

In the embodiment of the present application, the accumulated value of the second preset number of target ratios is calculated, and then the ratio of the accumulated value of the second preset number of target ratios to the second preset number is calculated to obtain the corresponding average value, and the This average is used as the target weight coefficient.

In the embodiment of the present application, the third difference value corresponding to the target monitoring index value at the same time and the second difference value corresponding to the reference monitoring index value are analyzed to determine the target weight coefficient. Because the operation of the database has a certain The regularity ensures the validity of the target weight coefficient and is more in line with the actual use requirements.

Based on the foregoing embodiments, in other embodiments of the present application, step 205 may be implemented by steps b11 to b12:

Step b11: From the first historical monitoring value, obtain a first predetermined number of second historical sub-monitoring values at the same moment as the current moment within a first predetermined number of time periods before the current moment.

In the embodiment of the present application, the first preset quantity is an empirical value obtained according to a large number of experiments, or a value set by the user according to actual needs. Taking the time period as days and the first preset number as 7 as an example, from the first historical monitoring value, obtain the 7 monitoring values at the same moment as the current moment within 7 days before the current moment, as the 7 second monitoring values. Historical sub-monitoring values. Exemplarily, the current time is 14:00 on November 11, and the monitoring value at 14:00 seven days before 14:00 on November 11 is obtained to obtain 14:00 on November 4 and 14:00 on November 5 , 14:00 on November 6, 14:00 on November 7, 14:00 on November 8, 14:00 on November 9, and 14:00 on November 10, as the 7th 2. History sub-monitoring value.

Step b12: Determine the standard deviation of the first preset number of second historical sub-monitoring values to obtain a first reference value.

In the embodiment of the present application, the standard deviation calculation formula is used to calculate the first preset number of second historical sub-monitoring values to obtain the standard deviation of the first preset number of second historical sub-monitoring values, and the first preset number of second historical sub-monitoring values is calculated. The standard deviation of the number of second historical sub-monitoring values is set as the first reference value.

In the embodiment of the present application, the analysis is performed through the historical monitoring values within a period of time closest to the current moment. Since the performance of the database within a period of time is basically kept constant, the consumption of computing resources in the calculation and analysis process is effectively reduced, and at the same time, the Guarantee the monitoring effect.

Based on the foregoing embodiments, in other embodiments of the present application, step 208 may be implemented by steps c11 to c13:

Step c11: Determine the first product of the target weight coefficient and the second reference value.

Step c12: Determine the product of at least one preset weight coefficient and the first reference value to obtain at least one second product.

Step c13: Determine the accumulated value of the first product, each of the at least one second product, and the first monitoring value to obtain the target threshold.

In the embodiment of the present application, the standard deviation of the first preset number of values at the same time in the recent period of time is calculated, and the value of the standard deviation is used to adjust the threshold value, because the observed indicators cannot fully meet the model expectations, by adding Standard deviation to allow a certain tolerance, which can be more in line with the actual needs of detection.

In the embodiment of the present application, multiple different thresholds are obtained by setting, which improves the universality for various application situations, thereby enabling different alarms, and effectively improving the user experience.

Based on the foregoing embodiments, in other embodiments of the present application, step 209 may be implemented by steps 209a to 209f:

Step 209a: Obtain the target upper limit value of the target monitoring indicator.

In the embodiment of the present application, the target upper limit value is a preset upper limit value, that is, for the target monitoring index, the allowable maximum value corresponding to the target monitoring index.

Wherein, after the information alarm device executes step 209a, it can choose to execute steps 209b to 209c, or step 209d, or step 209e, or step 209f.

Step 209b: If the first monitoring value is less than the target upper limit value, and the first monitoring value is greater than or equal to the first threshold value, continuously collect a third preset number of third monitoring values of the target monitoring index according to the second sampling interval.

Wherein, the second sampling interval is smaller than the first sampling interval, and the target threshold includes the first threshold.

In this embodiment of the present application, the first threshold is the smallest threshold among at least one threshold included in the target threshold. The third preset number is an empirical value obtained from a large number of experiments or a value set by the user, and usually the third preset number is smaller than the first preset number. Taking the second sampling interval as 3 seconds and the third preset number as 2 as an example, when the first monitoring value is less than the target upper limit value, and the first monitoring value is greater than or equal to the first threshold value, for every 3 seconds The target monitoring indicators are continuously collected twice to obtain two third monitoring values.

Step 209c: If the third preset number of third monitoring values are all smaller than the target upper limit value, and at least one third monitoring value is greater than or equal to the second threshold, generate first alarm information.

The target threshold includes a second threshold, the second threshold is greater than the first threshold, and the first alarm information is used to implement a major alarm for the target monitoring object.

In the embodiments of the present application, three third monitoring values are used as an example for description, and the case where at least one third monitoring value is greater than or equal to the second threshold includes: any one of the three third monitoring values is greater than or equal to equal to the second threshold, any two of the three third monitoring values are greater than or equal to the second threshold, and all the three third monitoring values are greater than or equal to the second threshold.

Step 209d, if the first monitoring value is greater than or equal to the target upper limit value, generate second alarm information.

The second alarm information is used to implement a serious alarm for the target monitoring object.

Step 209e: If at least one third monitoring value in the third preset number of third monitoring values is greater than or equal to the target upper limit value, generate second alarm information.

Step 209f, if the third preset number of third monitoring values are all smaller than the second threshold, generate third alarm information.

The third alarm information is used to implement a secondary alarm for the target monitoring object.

In other embodiments of the present application, if the first monitoring value is less than the first threshold, it is determined that the target monitoring object is running normally, and no alarm is required.

In the embodiment of the present application, different levels of alarms are implemented, which effectively improves the user experience.

Based on the foregoing embodiments, an embodiment of the present application provides an information alarm method, as shown in FIG. 3 , including the following steps:

Step 31: Collect the monitoring value of the target monitoring index of the database.

Among them, the monitoring indicators of the database are classified, as shown in Table 1. Table 1 lists the indicator types, indicator names and corresponding indicator attributes. For the resource-type indicators listed in the table, each instance will have different threshold standards because it carries different services and different request volumes, and such indicators are key monitoring objects, so adaptive thresholds are used to monitor this type of resource type The CPU usage and IO usage in the metrics, that is, the target monitoring metrics are CPU usage and/or IO usage. The monitoring system operated by the information alarm device cyclically collects the monitoring data of the target monitoring indicators according to a certain sampling frequency. The sampling frequency is the sampling time interval, which can be adjusted as needed. The default is to collect once every minute. too much stress.

Table 1

Step 32, generating an adaptive threshold.

Wherein, taking the target monitoring index as the IO usage rate as an example, the self-adaptive threshold U(t)=p(t)+β·δ. Wherein: p(t) can be calculated by the formula p(t)=α(I _t -I _t-1 )+I _t-1 , It represents the monitoring value of the IO usage rate at the current moment t; It-1 is the Monitoring value of IO usage.

α is the weighted ratio, which is used to control the proportion of the monitoring value of the target monitoring index at the current moment in the formula. The p(t) formula can be used to adapt to the speed of local behavior. If α is set to a fixed constant, there is often no Very good applicability. Therefore, α changes as the monitoring index changes with the running time. When the database is not abnormal, the monitoring values of the IO usage rate and CPU usage rate of the monitoring indicators of the database will maintain a certain positive correlation with the total request volume of the database. The monitoring values of the indicators IO usage and CPU usage increase instead. Therefore, it is only necessary to consider the correlation between the IO usage rate and the CPU usage rate and the total request volume under normal circumstances. Qt represents the total request volume value at the current time t, then the IO usage rate at time t is related to the two indicators of the total request volume. The coefficient q can be written as q=(Q _t -Q _t-1 )/(I _t -I _t-1 ), in this way, the 7th nearest q at the current time t can be taken as a positive coefficient (under normal circumstances, this coefficient The value of α at the current time t is obtained by taking its average value.

δ is the standard deviation. Among them, the process of obtaining δ is as follows: since the monitoring system always detects the database, there is an observation value for the target monitoring indicator at the same time every day. In this way, when the target monitoring indicator is the IO usage rate, it can be Obtain the historical detection value of the IO usage rate at the same time for 7 times in the past period of time, such as a week. The standard deviation δ can be obtained by calculating the standard deviation of the historical detection values of the IO usage rates at the same time.

The value of β determines different tolerances, and if it is set to a fixed value, there may also be universal problems. Therefore, to alert the target monitoring indicators here, different β values can be set. The set beta value is usually an empirical value. In this way, when the β values are different, for example, when two β values are set as β1 and β2 (β1<β2, both are positive integers), the corresponding adaptive thresholds U(t) are marked as U1 and U2, and U1< U2.

Step 33: Match the corresponding alarm severity.

Among them, in the monitoring process of resource-based indicators, the upper limit of resources is usually considered, and the upper limit is denoted as L (L is a fixed constant). When the upper limit L is exceeded, a high-level alarm must be output. In this way, for the monitoring value of the IO usage rate collected at the current moment, the process of monitoring the corresponding alarm level with the upper limit L, the adaptive thresholds U1 and U2 can be referred to as shown in FIG. 4 , where U1<U2. As shown in Figure 4, it includes the following steps:

Step 41: Obtain the monitoring value of the IO usage rate at the current moment.

Step 42: Determine whether the monitoring value of the IO usage rate is greater than the upper limit L, if the monitoring value of the IO usage rate is greater than or equal to the upper limit L, go to step 43, and if the monitoring value of the IO usage rate is less than the upper limit L, go to step 44.

Step 43, generate a CRITICAL alarm.

The CRITICAL alarm corresponds to the aforementioned first alarm information, and the CRITICAL level alarm indicates that an abnormality has occurred in the database and needs to be dealt with immediately.

Step 44, determine whether the monitoring value of the IO usage rate is greater than the adaptive threshold U1, if the monitoring value of the IO usage rate is less than the adaptive threshold U1, go to step 45, if the monitoring value of the IO usage rate is greater than or equal to the adaptive threshold U1, execute Step 46.

Step 45, determine that the database is normal.

Step 46: Continuously collect the monitoring values of the IO usage rate for two times according to the collection interval of 3 seconds, and obtain two monitoring values.

Step 47: Determine whether the two monitoring values are greater than the upper limit L, if at least one of the two monitoring values is greater than or equal to the upper limit L, go to step 43, if both monitoring values are less than the upper limit L, go to step 48.

Step 48, determine whether the 2 monitoring values are greater than the adaptive threshold U2, if at least one monitoring value in the 2 monitoring values is greater than or equal to the adaptive threshold U2, perform step 49, if the 2 monitoring values are less than the adaptive threshold U2, Step 410 is performed.

Step 49, generate a MAJOR alarm.

Among them, the MAJOR alarm corresponds to the aforementioned second alarm information, and the MAJOR level alarm needs to be focused on, and may have a certain impact.

Step 410: Generate a MINOR alarm.

Among them, MINOR alarms correspond to the aforementioned third alarm information, MINOR-level alarms do not need to be processed immediately, and data can be collected for potential risk analysis afterwards.

Based on the foregoing embodiments, in other embodiments of the present application, a method for implementing root cause recommendation is provided when the alarm prompt information is the first alarm information or the second alarm information. Referring to FIG. 5 , the information alarm After the device performs steps 201-208 and steps 209a-209c, or steps 201-208,

steps

209a and 209d, or steps 201-208,

steps

209a and 209e, it is also used to perform steps 211-215:

Step 211: If the alarm prompt information is the first alarm information or the second alarm information, obtain at least one structured query language SQL statement executed by the target monitoring object at the current moment.

Step 212: Obtain an execution plan corresponding to at least one SQL statement.

In the embodiment of the present application, an execution plan (also called a query plan or an explain plan) is a specific step for a database to execute an SQL statement, such as accessing data in a table through an index or a full table scan, and the implementation method and connection of the connection query. order, etc.

Step 213: Determine the consumption cost of each SQL statement corresponding to the target monitoring indicator based on the execution plan corresponding to the at least one SQL statement, and obtain the consumption cost corresponding to the at least one SQL statement.

In the embodiment of the present application, the execution plan corresponding to each SQL statement in the execution plan corresponding to the at least one SQL statement is analyzed to determine the consumption cost of the target monitoring indicator corresponding to each SQL statement, so as to obtain the corresponding execution plan of the at least one SQL statement. consumption cost. For example, the information alarm device determines that there are three SQL statements currently executed in the database, obtains the execution plans corresponding to the three SQL statements respectively, and according to the execution plan corresponding to each SQL statement in the execution plans corresponding to the three SQL statements, Determine the consumption cost of the target monitoring indicator corresponding to each SQL statement, so as to obtain the corresponding consumption cost of the three SQL statements.

Step 214: Based on the consumption cost corresponding to the at least one SQL statement, sort the at least one SQL statement according to the order of the consumption cost from high to low, and obtain a SQL statement sorting result.

In the embodiment of the present application, it is assumed that the three SQL statements include SQL statement 1, SQL statement 2, and SQL statement 3, and the corresponding IO consumption costs are IO_cost1, IO_cost2, and IO_cost3 in sequence. For example, the sorting order to the lowest is IO_cost3>IO_cost1>IO_cost12. In this way, the sorting order of the corresponding three SQL statements, that is, the sorting results of the SQL statements are: IO_cost3, IO_cost1, and IO_cost2.

Step 215 , displaying the sorting result of the SQL statement.

It should be noted that steps 211 to 215 may be performed before step 210 , wherein step 215 and step 210 may be performed simultaneously, and step 215 may also be performed after step 210 .

Based on the foregoing embodiments, in other embodiments of the present application, step 213 may be implemented by steps d11 to d19 and/or steps e11 to e16, wherein the embodiment corresponding to steps d11 to d19 provides determination of the consumption of the target monitoring object The solution implementation process when the cost is the IO consumption cost, and the embodiments corresponding to steps e11 to e16 provide the solution implementation process when it is determined that the consumption cost of the target monitoring object is the CPU consumption cost. It should be noted that when the target monitoring indicator of the target monitoring object is the IO indicator, when determining the consumption cost, only the IO consumption cost can be determined, or the CPU consumption cost can also be determined while determining the IO consumption cost; , when the target monitoring indicator of the target monitoring object is the CPU indicator, when determining the consumption cost, you can only determine the CPU consumption cost, or you can determine the CPU consumption cost at the same time as the CPU consumption cost. The actual execution process can refer to actual application requirements.

Step d11: Determine the number of rows of each identity ID included in the execution plan corresponding to each SQL statement based on the execution plan corresponding to at least one SQL statement.

In the embodiment of the present application, the execution plan corresponding to each SQL statement includes an id column, and the id column is used to indicate the sequence number of the selection (SELECT) in the corresponding SQL statement, that is, the corresponding ID. Among them, those with larger ID values are executed first, and those with the same ID value are executed from top to bottom. If the id value is Null, it means that the union operation is performed using the row results of other id values. It is necessary to judge which step to place according to the value of the table column <union m,n>, and place it in min(m,n) (take m and The smaller value of n) is executed after the next step.

Wherein, after the information alarm device executes step d11, it can choose to execute steps d12-d13, or steps d14-d18. When the number of rows for each ID is 1, steps d12 to d13 are selected to be executed; when the number of rows of each ID is greater than 1, steps d14 to d18 are selected to be executed.

Step d12: Determine the ID corresponding to each SQL statement with the row number of 1 as the first ID, and obtain the first row number and average length corresponding to the first ID.

The number of the first row is recorded in the execution plan corresponding to each SQL statement.

In this embodiment of the present application, the first row number is recorded in the rows column in the execution plan corresponding to each SQL statement, and the first row number may be represented by rows. The average length AVG_ROW_LENGTH of the first ID corresponding to each SQL statement can be obtained from the file named information_schema.tables.

Step d13 , rounding up the product of the first row number and the average length and the preset InnoDB data page size to obtain the IO consumption cost of the first ID.

In the embodiment of this application, the default uncompressed data page of InnoDB data page in MySQL is 16KB, and the data page includes seven parts, data page file management header information, data page header information, maximum and minimum records, user records, free space, Data directory (slot), tail of data pages. The preset InnoDB data page size can be recorded as innodb_page_size, corresponding to the IO consumption cost of SQL statements with a row number of 1

Among them, the symbol

Used to indicate rounding up. InnoDB data pages can also be set by the user.

Step d14: Determine the ID with the number of rows greater than 1 corresponding to each SQL statement as the second ID, and determine the number of returned rows and the number of scanned rows for each row of the second ID.

In the example of this application, assuming that a certain ID in SQL statement 1 is, for example, ID1 with multiple rows, such as k rows, count the number of returned rows and the number of scanned rows of each row of ID1. Among them, a way to determine the number of returned rows and the number of scanned rows of each row of each ID of each SQL statement may be as follows: From the execution plan corresponding to SQL statement 1, determine the k rows corresponding to ID1, and according to The row order of the k rows corresponding to ID1 from top to bottom determines the number of returned rows for each row in turn. When determining the number of scan rows for each row of each ID of each SQL statement, it needs to be determined according to the Join method, that is, the number of join comparisons needs to be counted. The number of join comparisons can be determined by Table 2. In Table 2, RN represents the number of records in the outer table, and SN represents the number of records in the inner table.

Table 2

In the Join method in Table 2, SNLJ refers to a simple nested loop join, and the corresponding English spelling is the Join method of Simple Nested-Loops Join, and INLJ refers to an index-based nested loop join, and the corresponding English spelling is full For Index Nested-Loops Join, BNL refers to the block-based nested loop join, the corresponding English spelling is Block Nested-Loops Join, CHJ refers to the classic hash join, and the corresponding English spelling is Classic Hash Join.

Among them, the number of returned rows of the first row in the K rows corresponding to ID1 is recorded as return_rows_1=rows_1*filtered_1; wherein, rows_1 can be obtained from the rows column of the first row corresponding to ID1 in the execution plan corresponding to SQL statement 1, filtered_1 can be obtained from the filtered column of row 1 corresponding to execution plan ID1 corresponding to SQL statement 1. Except for the first row, the number of returned rows of other rows is related to the join mode corresponding to each row, and the join mode is recorded in the execution plan corresponding to SQL statement 1.

Exemplarily, when determining the number of returned rows in the second row corresponding to ID1 in the execution plan corresponding to SQL statement 1, when the join mode of the second row is inner join, the number of returned rows in the second row return_rows_2=return_rows_1*( rows_2*filtered_n2), when the join method of the second row is left join, the number of returned rows in row 2 return_rows_2=return_rows_1, when the join method of row 2 is right join, the number of returned rows in row 2 return_rows_2=table_rows_2 ;...; Determine the number of returned rows of row k corresponding to ID1 in the execution plan corresponding to SQL statement 1. When the join method of row k is inner join, return_rows_k=return_rows_(k-1)*(rows_k*filtered_k) , when the join method of row k is left join, return_rows_k=return_rows_(k-1), and when the join method of row k is right join, return_rows_k=table_rows_k. Among them, taking nk as an example, return_rows_(k-1) is the number of rows returned by row k-1, which is the number of outer rows in the execution order, and table_rows_k is the number of inner table rows.

Assuming that the Join method used in SQL statement 1 is INLJ, the number of scan rows of the k-th row corresponding to ID1 in the corresponding SQL statement 1 is recorded as examine_rows_k=return_rows_(k-1)*(1+table_rows_k/index_cdl), where, index_cdl represents the index discrimination. If you need to return to the table, that is, the value of the key is not PRIMARY, the extra does not contain using index, and there is using where, the number of scanned rows of the kth row corresponding to ID1 in SQL statement 1 is recorded as examine_rows_k=return_rows_(k-1)* (1+table_rows_k/index_cdl)*2.

The comparison times of the k-th row of Join corresponding to ID1 in SQL statement 1 may be recorded as join_compare_k=table_rows_k*index_height, where index_height is used to represent the index height. It should be noted that the index distinction index_cdl and index height index_height can be obtained from the mysql.innodb_index_stat table corresponding to ID1 in SQL statement 1.

Step d15: Obtain the average length corresponding to the corresponding second ID.

In this embodiment of the present application, the average length AVG_ROW_LENGTH corresponding to the second ID can be obtained from information_schema.tables corresponding to each SQL statement.

Step d16: Determine the difference between the number of scanned lines in each line of the second ID and the number of returned lines in the corresponding adjacent previous line to obtain the first difference.

In the embodiment of the present application, the formula for calculating the first difference value may be recorded as: first difference value=examine_rows_k−return_rows_(k−1).

Step d17: Determine the product of the first difference value and the average length and the preset InnoDB data page size and perform rounding processing to obtain the IO consumption sub-cost corresponding to each row of the second ID.

In the embodiment of the present application, the IO consumption sub-cost of the k-th row corresponding to ID1 in SQL statement 1 can be recorded as

Among them, i=1,2,...,k, innodb_page_size is used to represent the preset InnoDB data page size, the symbol

Used to indicate rounding up.

Step d18: Determine the accumulated value of the IO consumption sub-cost corresponding to each row of the second ID, and obtain the IO consumption cost of the second ID.

In this embodiment of the present application, the IO consumption cost of the second ID of SQL statement 1

The symbol Σ denotes accumulation.

Step d19: Determine the cumulative value of the IO consumption cost of each ID included in the execution plan corresponding to each SQL statement, and obtain the consumption cost corresponding to at least one SQL statement.

The accumulated value of the IO consumption cost of each ID includes the IO consumption cost of the first ID and/or the IO consumption cost of the second ID.

In the embodiment of the present application, it is assumed that SQL statement 1 includes 5 IDs, wherein the number of rows for 3 IDs such as ID1, ID2 and ID3 is 1 row, and the number of rows for the remaining 2 IDs such as ID4 and ID5 includes at least 2 rows , therefore, the IO consumption cost of ID1, the IO consumption cost of ID2 and the IO consumption cost of ID3 can be determined through steps d12 to d13 respectively, and the IO consumption cost of ID4 and the IO consumption cost of ID5 can be determined through steps d14 to d17 respectively. , and then accumulate the IO consumption cost of ID1, the IO consumption cost of ID2, the IO consumption cost of ID3, the IO consumption cost of ID4, and the IO consumption cost of ID5 to obtain the consumption cost of SQL statement 1. Similarly, you can also get Consumption cost of other SQL statements within at least one SQL statement.

Exemplarily, it is assumed that a plan table with an ID of 1 included in a certain SQL statement can be referred to as shown in Table 3. For the rows with id 1 in Table 3 from top to bottom, it can be determined: the number of scanned rows in the first row examine_rows_1=rows=54952, the number of returned rows in the first row return_rows_1=54952*100%=54952; the second row The number of scan rows examine_rows_2=tables_rows*(1+table_rows_2/index_cal)=54952*(1+413141/137713)=219808, the second row returns the row number return_rows_2=219808*100%=219808; the third row scan row number examine_rows_3= 219808*(1+1)=439616, the number of rows returned in the third row return_rows_3=219808*1*100%=219808; the number of scan rows in the fourth row examine_rows_4=219808*(1+1)=439616.

table 3

Calculate the IO consumption cost of ID 1 included in a SQL statement as io_cost=(439616-219808)*140/16000+(439616-219808)*350/16000+(219808-54952)*295/16000+(54592- 0)*465/16000, approximately equal to 11300.

Calculate the CPU consumption cost with ID 1 included in a SQL statement as cpu_cost=(54952+54952*log54952)+(54952*3)+(219808*4+219808*3)+(219808*4+219808*3) , approximately equal to 3500000.

In this way, the SQL statements in the at least one SQL statement are sorted according to the IO consumption cost and/or the CPU consumption cost of the at least one SQL statement at the current moment to obtain a sorting result. Further, in some embodiments, root cause sorting can also be performed in combination with the number of executions of SQL statements, wherein the SQL statements can be sorted according to the number of executions from high to low, and SQL statements with the same number of executions can be sorted according to Sort by IO consumption cost or CPU consumption cost.

Step e11: Determine the number of rows of each identity ID included in the execution plan corresponding to each SQL statement based on the execution plan corresponding to at least one SQL statement.

Step e12, determine that the ID whose row number is 1 is the first ID.

Step e13: Determine the CPU consumption cost corresponding to the first ID based on the execution plan of the first ID.

Step e14, determine that the ID whose number of rows is greater than 1 is the second ID.

Step e15: Determine the CPU consumption cost corresponding to each row of the second ID based on the execution plan of each row of the second ID.

In the embodiment of the present application, it is assumed that the second ID includes 3 rows, and the CPU consumption cost corresponding to each row of the second ID is determined according to the parameters included in the execution plan of each row of the second ID, and the first ID of the second ID is obtained. The CPU consumption cost corresponding to the row, the CPU consumption cost corresponding to the second row, and the CPU consumption cost corresponding to the third row.

Step e16: Accumulate the CPU consumption cost corresponding to each row of the second ID to obtain the CPU consumption cost corresponding to the second ID.

In other embodiments of the present application, the CPU consumption cost corresponding to each of the three rows included in the second ID is accumulated, that is, the CPU consumption cost corresponding to the first row and the CPU consumption cost corresponding to the second row of the second ID are calculated. The accumulated value of the CPU consumption cost corresponding to the third row is used to obtain the CPU consumption cost corresponding to the second ID.

Based on the foregoing embodiments, in other embodiments of the present application, step e13 may be implemented by steps e131 to e135:

Step e131 , based on the execution plan of the first ID, determine the number of the first row and the number of returned rows corresponding to the first ID.

Step e132: From the execution plan of the first ID, obtain the access type Type and extra field information Extra corresponding to the first ID.

In the embodiment of the present application, the row number of the row whose ID is 2 of SQL statement 1 is 1 is used as an example for description.

Table 4

In this way, the access type Type of the row whose ID is 2 in SQL statement 1 can be obtained from the Select_Type column of Table 4, and the Extra of the row whose ID is 2 in SQL statement 1 can be obtained from the Extra column of Table 4.

Step e133 , obtaining the first CPU consumption sub-cost corresponding to the first ID based on the Type, Extra and the first row number corresponding to the first ID.

In the embodiment of the present application, according to the relationship between the number of the first row and the consumption sub-cost under different Types and Extras that are preset, it is determined to obtain the Type corresponding to the first ID, the Extra, and the first row corresponding to the number of the first row. The first CPU consumption sub-cost corresponding to an ID.

Exemplarily, under different preset types and different Extras, the relationship f_filter(rows) between the first row number rows and the consumption sub-cost can be referred to as shown in Table 5. Wherein, in Table 5, primary_key_height identifies the component index height, which is generally 3 or 4.

table 5

Step e134: Determine the product of the logarithm of the number of returned rows and the number of returned rows to obtain the second CPU consumption sub-cost corresponding to the first ID.

In this embodiment of the present application, the second CPU consumption sub-cost corresponding to the first ID may be recorded as f_sort(return_rows)=return_rows*log return_rows, where log is a logarithmic function.

Step e135: Determine the sum of the first CPU consumption sub-cost and the second CPU consumption sub-cost corresponding to the first ID, and obtain the CPU consumption cost corresponding to the first ID.

In this embodiment of the present application, the CPU consumption cost corresponding to the first ID may be recorded as cpu_cost=f_filter(rows)+f_sort(return_rows).

Correspondingly, step e15 can be realized by steps e151～e156:

Step e151: Determine the second row number and the returned row number of each row of the second ID based on the execution plan of each row of the second ID.

Step e152: From the execution plan corresponding to each row of the second ID, obtain the access type Type and extra field information Extra corresponding to each row of the second ID, and the number of table rows corresponding to each row of the second ID.

Step e153 , obtaining the third CPU consumption sub-cost corresponding to each row of the second ID based on the Type, Extra and the number of the second row corresponding to each row of the second ID.

In this embodiment of the present application, for the specific implementation process of step e153, reference may be made to the specific implementation process of step e133, which will not be described in detail here.

Step e154: Determine the product of the logarithm of the number of returned rows of each row of the second ID and the corresponding number of returned rows to obtain the fourth CPU consumption sub-cost corresponding to each row of the second ID.

In this embodiment of the present application, for the specific implementation process of step e154, reference may be made to the specific implementation process of step e134, which will not be described in detail here.

Step e155: Determine the product of the number of table rows corresponding to each row of the second ID and the index height corresponding to each row of the second ID, and obtain the fifth CPU consumption sub-cost corresponding to each row of the second ID.

In the embodiment of the present application, the fifth CPU consumption sub-cost corresponding to each row of the second ID may be recorded as join_compare=table_rows*index_height, where index_height is used to represent the index height, and table_rows represents the table corresponding to each row of the second ID Rows.

Step e156: Determine the cumulative value of the third CPU consumption sub-cost, the fourth CPU consumption sub-cost and the fifth CPU consumption sub-cost corresponding to each row of the second ID, and obtain the CPU consumption cost of each row of the second ID.

In the embodiment of the present application, under different alarm conditions, the CPU consumption cost and/or the IO cost is analyzed, and when the alarm is issued, the analysis result is output to implement the root cause recommendation, which effectively reduces the work difficulty of the analyst and improves the This improves the efficiency of the analyst in determining alarm faults and improves the utilization efficiency of the analyst.

Based on the foregoing embodiments, in other embodiments of the present application, another method for implementing root cause recommendation is provided when the alarm prompt information is the first alarm information or the second alarm information. Referring to FIG. 6 , the information After the alarm device performs

steps

208 and 209a to 209c, or steps 201 to 208,

steps

209a and 209d, or steps 201 to 208,

steps

209a and 209e, it is also used to perform steps 216 to 223:

Step 216: If the alarm prompt information is the first alarm information or the second alarm information, acquire at least one SQL statement executed by the target monitoring object at the current moment.

In this embodiment of the present application, the sql statement currently being executed may be obtained from a currently high-load database table, for example, the table file name is information_schema.processlist.

Step 217: Group at least one SQL statement in the same manner as the statement to obtain at least one set of SQL statements.

In the embodiments of the present application, when grouping the statements in the same manner, specifically, SQL statements with the same sentence pattern but different parameter values can be grouped into a group of SQL. In some application scenarios, the grouping can also be based on each The characteristics of a group of SQL statements, and the SQL fingerprint is generated as the mark of the group of SQL statements.

Step 218 , based on at least one set of SQL statements, count the number of SQL statements included in each set of SQL statements.

In the embodiment of the present application, the number of SQL statements included in each group of SQL statements in the at least one group of SQL statements is counted to obtain the number of SQL statements included in each group of SQL statements.

Step 219: Acquire one SQL statement from each group of SQL statements in the at least one group of SQL statements, to obtain at least one target SQL statement.

In the embodiment of the present application, it is assumed that at least one SQL statement is grouped in the same manner as the statement to obtain 4 groups of SQL statements, then one SQL statement is randomly selected from each group of SQL statements to obtain 4 target SQL statements.

Step 220: Determine the target standby database, and run each target SQL statement respectively through the target standby database.

In this embodiment of the present application, the target standby database refers to a standby database with a lower load. When enabling standby database profiling, you can use the statement set profiling=1 to achieve this.

Step 221: Determine the resource consumption sub-cost consumed when the target standby database runs each target SQL statement, and obtain the resource consumption sub-cost of each target SQL statement.

In the embodiment of the present application, when the target standby database runs each target SQL statement, the target standby data records the resource consumption. Therefore, the resource consumption recorded when the target standby database runs each target SQL statement can be determined. Resource consumption sub-cost for each target SQL statement.

Step 222: Determine the product of the resource consumption sub-cost of each target SQL statement and the number of SQL statements included in the group where each target SQL statement is located, to obtain the resource consumption cost of each group of SQL statements.

Step 223: Sort at least one group of SQL statements in a descending order of the resource consumption cost of each group of SQL statements, obtain a sorting result, and display the sorting result.

It should be noted that steps 216 to 223 may be performed before step 210 , wherein step 223 and step 210 may be performed simultaneously, and step 223 may also be performed after step 210 .

Based on the foregoing embodiments, in other embodiments of the present application, step 221 may be implemented by steps f11 to f13:

Step f11: If the target standby database runs each target SQL statement for a duration greater than or equal to a preset duration, determine the resource consumption sub-cost of each target SQL statement as a first value.

In the embodiment of the present application, the preset duration is an empirical value, which is usually obtained based on a large number of experiments or actual experience. In some application scenarios, the user can also set it by himself. The first value is an empirical value, usually used to represent the highest resource consumption cost.

Step f12: If the duration of running each target SQL statement on the target standby database is less than the preset duration, obtain a resource consumption table corresponding to when the target standby database runs each target SQL statement.

In the embodiment of the present application, when the target standby database runs each target SQL statement, the corresponding resource consumption table acquisition method can be realized by the following statement:

Show profiles;//Display the number Query_ID of executing sql

show profile cpu,block io for query Query_ID;//Display the resource consumption table of number Query_ID

In this way, the resource consumption table of each target SQL statement obtained by the above statement can be shown in Table 6 as an example. In Table 6, status represents the state, Duration represents the state duration, usually in seconds, CPU_user represents the CPU resources consumed by the user state, CPU_system represents the CPU resources consumed by the core state, Block_ops_in represents the number of input block operations, and Block_ops_out represents the number of input block operations. The number of output block operations.

Step f13, obtain the first consumption resource and the second consumption resource from the resource consumption table corresponding to each target SQL statement, determine the sum value of the first consumption resource and the second consumption resource, and obtain the resource consumption corresponding to each target SQL statement sub cost.

Wherein, the first consumption resource is the CPU resource consumed by the user mode, the second consumption resource is the CPU resource consumed by the core mode, and/or the first consumption resource is the number of input block operations, and the second consumption resource is the output block operation. quantity.

Table 6

In the embodiment of the present application, exemplarily, when there are 4 target SQL statements, 4 resource consumption tables as shown in Table 6 corresponding to each target SQL statement can be obtained. When the target monitoring indicator is CPU, for each target SQL statement, compare the contents of the CPU_user column representing the CPU resources consumed by the user state and the CPU_system column representing the CPU resources consumed by the core state in the resource consumption table shown in Table 6. The contents are accumulated to obtain the sub-cost of CPU resource consumption corresponding to each target SQL statement.

When the target monitoring indicator is IO, for each target SQL statement, the content of the Block_ops_in column representing the number of input block operations and the content of the Block_ops_out column representing the number of output block operations in the resource consumption table shown in Table 6 are processed. Accumulate to obtain the sub-cost of IO resource consumption corresponding to each target SQL statement.

It should be noted that, in some application scenarios, when the target monitoring indicator is CPU, in addition to calculating the sub-cost of CPU resource consumption corresponding to each target SQL statement, the sub-cost of IO resource consumption corresponding to each target SQL statement can also be calculated. Similarly, when the target monitoring indicator is IO, in addition to calculating the IO resource consumption sub-cost corresponding to each target SQL statement, the CPU resource consumption sub-cost corresponding to each target SQL statement can also be calculated.

It should be noted that, for the description of the same steps and the same content in this embodiment as in other embodiments, reference may be made to the descriptions in other embodiments, and details are not repeated here.

In the embodiment of the present application, the information alarm device collects the target monitoring index of the target monitoring object according to the first sampling interval, and after obtaining the first monitoring value at the current moment, obtains the first historical monitoring value obtained by collecting the target monitoring index at the historical moment, and based on A target threshold is determined for the first monitoring value and the first historical monitoring value, then based on the first monitoring value and the target threshold, alarm prompt information is determined, and finally the alarm prompt information is displayed. In this way, the information alarm device dynamically determines the target threshold value according to the first monitoring value at the current moment and the first historical monitoring value at the historical moment in real time, and generates alarm prompt information according to the relationship between the target threshold value and the first monitoring value, which solves the problem. The current use of fixed thresholds to achieve database monitoring leads to the problem that the alarm requirements of the database in various time periods cannot be accurately realized. The solution of adaptively adjusting the thresholds to realize database monitoring according to the actual situation is realized, which effectively improves the accuracy of database alarms. In addition, different levels of alarm prompts are implemented, which can inform the user of the current specific risk level of the database, so that the user needs to immediately perform corresponding processing according to the risk level. And according to different risk levels, the possible causes of risks are displayed, which is convenient for users to analyze and process, which effectively improves the human-computer interaction process and improves the user experience.

Based on the foregoing embodiments, the embodiments of the present application provide an information alarm device. Referring to FIG. 7 , the information alarm device 5 may include: a processor 51, a memory 52, and a communication bus 53, wherein:

memory 52 for storing executable instructions;

A communication bus 53, used to realize the communication connection between the processor 51 and the memory 52;

The processor 51 is configured to execute the information alarm program stored in the memory 52 to realize the following steps:

Obtain the first historical monitoring value obtained by collecting target monitoring indicators at historical moments;

Determine the target threshold based on the first monitoring value and the first historical monitoring value; wherein the target threshold includes at least one different threshold;

Determine the alarm prompt information based on the first monitoring value and the target threshold; wherein, the alarm prompt information is used to provide an alarm prompt for the target monitoring index of the target monitoring object;

Displays warning information.

In this embodiment of the present application, when the processor executes the step based on the first monitoring value and the first historical monitoring value, when determining the target threshold, the following steps may be used:

Obtain the second monitoring value at the current moment of the reference monitoring indicator of the target monitoring object and the second historical monitoring value collected at the historical moment of the reference monitoring indicator; wherein, the reference monitoring indicator and the target monitoring indicator have an associated relationship;

determining the target weight coefficient based on the first monitoring value, the first historical monitoring value, the second monitoring value and the second historical monitoring value;

determining a first reference value based on the first historical monitoring value;

From the first historical monitoring value, obtain the first historical sub-monitoring value of the previous moment adjacent to the current moment;

determining the difference between the first monitoring value and the first historical sub-monitoring value to obtain a second reference value;

The target threshold is obtained based on the target weight coefficient, the second reference value, the first monitoring value, the at least one preset weight coefficient and the first reference value.

In the embodiment of the present application, when the processor executes the step to determine the target weight coefficient based on the first monitoring value, the first historical monitoring value, the second monitoring value and the second historical monitoring value, the following steps may be used to achieve:

By determining the difference between the monitoring value at the second moment and the monitoring value at the first moment, the first monitoring value and the first historical monitoring value are processed to obtain the second difference value of the target monitoring index at different times; The moment and the second moment are two adjacent moments, and the first moment is farther from the current moment than the second moment is from the current moment;

By determining the difference between the monitoring value at the second moment and the monitoring value at the first moment, the second monitoring value and the second historical monitoring value are processed to obtain the third difference value of the reference monitoring index at different times;

Determine the ratio of the third difference and the second difference at the same moment to obtain a reference ratio;

Based on the reference ratio, the target weight coefficient is determined.

In the embodiment of the present application, when the processor executes the step based on the reference ratio, when determining the target weight coefficient, the following steps may be used:

Obtain from the reference ratio a second preset number of target ratios whose ratios are greater than zero and are closest to the current moment;

The average value of the second preset number of target ratios is determined to obtain the target weight coefficient.

In the embodiment of the present application, when the processor executes the step based on the first historical monitoring value, when determining the first reference value, the following steps may be used:

From the first historical monitoring value, obtain the first predetermined number of second historical sub-monitoring values at the same moment as the current moment within the first predetermined number of time periods before the current moment;

The standard deviation of the first preset number of second historical sub-monitoring values is determined to obtain the first reference value.

In this embodiment of the present application, when the processor executes the steps to obtain the target threshold based on the target weight coefficient, the second reference value, the first monitoring value, at least one preset weight coefficient, and the first reference value, the following steps may be performed:

determining the first product of the target weight coefficient and the second reference value;

determining the product of at least one preset weight coefficient and the first reference value to obtain at least one second product;

The accumulated value of each of the first product, each of the at least one second product, and the first monitoring value is determined to obtain the target threshold value.

In this embodiment of the present application, when the processor performs the step to determine the alarm prompt information based on the first monitoring value and the target threshold, the following steps may be used:

Obtain the target upper limit value of the target monitoring indicator;

If the first monitoring value is less than the target upper limit value, and the first monitoring value is greater than or equal to the first threshold value, a third preset number of third monitoring values of the target monitoring index are continuously collected according to the second sampling interval; The interval is less than the first sampling interval, and the target threshold includes the first threshold;

If the third preset number of third monitoring values are all smaller than the target upper limit value, and at least one third monitoring value is greater than or equal to the second threshold value, first alarm information is generated; wherein, the target threshold value includes the second threshold value, the second threshold value When the value is greater than the first threshold, the first alarm information is used to implement a major alarm for the target monitoring object.

In this embodiment of the present application, the processor is further configured to perform the following steps:

If the first monitoring value is greater than or equal to the target upper limit value, generate second alarm information; wherein the second alarm information is used to implement a serious alarm for the target monitoring object;

If at least one of the third preset number of third monitoring values is greater than or equal to the target upper limit value, generating second alarm information;

If the third preset number of third monitoring values are all smaller than the second threshold, third alarm information is generated, wherein the third alarm information is used to implement a secondary alarm for the target monitoring object.

In the embodiment of the present application, after determining the alarm prompt information based on the first monitoring value and the target threshold, the processor performing step is further configured to perform the following steps:

If the alarm prompt information is the first alarm information or the second alarm information, obtain at least one structured query language SQL statement executed by the target monitoring object at the current moment;

Get the execution plan corresponding to at least one SQL statement;

Based on the execution plan corresponding to at least one SQL statement, determine the consumption cost of each SQL statement corresponding to the target monitoring indicator, and obtain the consumption cost corresponding to at least one SQL statement;

Based on the consumption cost corresponding to the at least one SQL statement, sort the at least one SQL statement according to the sorting order of the consumption cost from high to low, and obtain the SQL statement sorting result;

Displays the sorted results of the SQL statement.

In the embodiment of the present application, the consumption cost of each SQL statement corresponding to the target monitoring indicator includes the input and output IO consumption cost, and the processor executing step determines the consumption of each SQL statement corresponding to the target monitoring indicator based on the execution plan corresponding to at least one SQL statement When the consumption cost corresponding to at least one SQL statement is obtained, the following steps can be used to achieve:

Determine, based on the execution plan corresponding to at least one SQL statement, the number of rows of each identity ID included in the execution plan corresponding to each SQL statement;

Determine that the ID whose number of rows is 1 is the first ID, and obtain the first row number and average length corresponding to the first ID; wherein, the first row number is recorded in the execution plan corresponding to each SQL statement;

Round up the product of the first row number and the average length and the preset InnoDB data page size to obtain the IO consumption cost of the first ID;

Determine the ID with the number of rows greater than 1 as the second ID, and determine the number of returned rows and scan rows of each row of the second ID;

Obtain the average length corresponding to the corresponding second ID;

Determine the difference between the scan line number of each row of the second ID and the return line number of the corresponding adjacent previous row to obtain the first difference value;

Determine that the product of the first difference and the average length and the preset InnoDB data page size are rounded up to obtain the IO consumption sub-cost corresponding to each row of the second ID;

Determine the cumulative value of the IO consumption sub-cost corresponding to each row of the second ID, and obtain the IO consumption cost of the second ID;

Determine the cumulative value of the IO consumption cost of each ID included in the execution plan corresponding to each SQL statement, and obtain the consumption cost corresponding to at least one SQL statement; wherein, the cumulative value of the IO consumption cost of each ID includes the first ID. The IO consumption cost and/or the IO consumption cost of the second ID.

In other embodiments of the present application, the consumption cost of the target monitoring indicator corresponding to each SQL statement includes the CPU consumption cost of the central processing unit, and the processor executing step determines the target monitoring indicator corresponding to each SQL statement based on the execution plan corresponding to at least one SQL statement When the consumption cost corresponding to at least one SQL statement is obtained, the following steps can be used to achieve:

It is determined that the ID with the row number of 1 is the first ID;

Determine the CPU consumption cost corresponding to the first ID based on the execution plan of the first ID;

It is determined that the ID with the number of rows greater than 1 is the second ID;

Determine the CPU consumption cost corresponding to each row of the second ID based on the execution plan of each row of the second ID;

The CPU consumption cost corresponding to each row of the second ID is accumulated to obtain the CPU consumption cost corresponding to the second ID.

In other embodiments of the present application, when the processor is configured to execute the execution plan based on the first ID and determine the CPU consumption cost corresponding to the first ID, the processor may be configured to execute the following steps:

Based on the execution plan of the first ID, determine the first number of rows and the number of returned rows corresponding to the first ID;

From the execution plan of the first ID, obtain the access type Type and extra field information Extra corresponding to the first ID;

Based on the Type, Extra and the first row number corresponding to the first ID, obtain the first CPU consumption sub-cost corresponding to the first ID;

Determine the product of the logarithm of the number of returned rows and the number of returned rows, and obtain the second CPU consumption sub-cost corresponding to the first ID;

The sum of the first CPU consumption sub-cost and the second CPU consumption sub-cost corresponding to the first ID is determined, and the CPU consumption cost corresponding to the first ID is obtained.

In other embodiments of the present application, when the processor is used to execute the step based on the execution plan of each row of the second ID, when determining the CPU consumption cost corresponding to each row of the second ID, the following steps can be used to achieve:

Based on the execution plan of each row of the second ID, determine the second row number and the returned row number of each row of the second ID;

From the execution plan corresponding to each row of the second ID, obtain the access type Type and the extra field information Extra corresponding to each row of the second ID, and the number of table rows corresponding to each row of the second ID;

Based on the Type, Extra and the number of the second rows corresponding to each row of the second ID, the third CPU consumption sub-cost corresponding to each row of the second ID is obtained;

Determine the product of the logarithm of the number of returned rows of each row of the second ID and the corresponding number of returned rows, and obtain the fourth CPU consumption sub-cost corresponding to each row of the second ID;

Determine the product of the number of table rows corresponding to each row of the second ID and the index height corresponding to each row of the second ID, and obtain the fifth CPU consumption sub-cost corresponding to each row of the second ID;

Determine the cumulative value of the third CPU consumption sub-cost, the fourth CPU consumption sub-cost and the fifth CPU consumption sub-cost corresponding to each row of the second ID, and obtain the CPU consumption cost of each row of the second ID.

In other embodiments of the present application, after determining the alarm prompt information based on the first monitoring value and the target threshold, the processor performing step is further configured to perform the following steps:

If the alarm prompt information is the first alarm information or the second alarm information, obtain at least one SQL statement executed by the target monitoring object at the current moment;

Group at least one SQL statement in the same manner as the statement to obtain at least one set of SQL statements;

Based on at least one set of SQL statements, count the number of SQL statements included in each set of SQL statements;

Obtain one SQL statement from each group of SQL statements of at least one group of SQL statements to obtain at least one target SQL statement;

Determine the target standby database, and run each target SQL statement separately through the target standby database;

Determine the resource consumption sub-cost consumed when the target standby database runs each target SQL statement, and obtain the resource consumption sub-cost of each target SQL statement;

Determine the product of the resource consumption sub-cost of each target SQL statement and the number of SQL statements included in the group where each target SQL statement is located, and obtain the resource consumption cost of each group of SQL statements;

Sort at least one set of SQL statements according to the sorting order of the resource consumption cost of each set of SQL statements, obtain the sorting result, and display the sorting result.

In the embodiment of the present application, when the processor executes the step to determine the resource consumption sub-cost consumed when the target standby database runs each target SQL statement, and obtains the resource consumption sub-cost of each target SQL statement, the following steps can be used to achieve:

If the target standby database runs each target SQL statement for a duration greater than or equal to the preset duration, determine the resource consumption sub-cost of each target SQL statement as the first value;

If the duration of running each target SQL statement on the target standby database is less than the preset duration, obtain the resource consumption table corresponding to the target standby database running each target SQL statement;

Obtain the first consumption resource and the second consumption resource from the resource consumption table corresponding to each target SQL statement, determine the sum of the first consumption resource and the second consumption resource, and obtain the resource consumption sub-cost corresponding to each target SQL statement; Wherein, the first consumption resource is the CPU resource consumed by the user mode, the second consumption resource is the CPU resource consumed by the core mode, and/or the first consumption resource is the number of input block operations, and the second consumption resource is the output block operation. quantity.

It should be noted that, one or more programs in this embodiment of the present application may be explained by the steps of one or more processors, and reference may be made to the method implementation process provided by the embodiments corresponding to FIGS. 1 to 2 and FIGS. 5 to 6 . It will not be repeated here.

Based on the foregoing embodiments, the embodiments of the present application provide a computer-readable storage medium, referred to as a storage medium for short, and the computer-readable storage medium stores one or more programs, and the one or more programs can be stored by one or more programs. The processor executes to implement the implementation process of the information alarm method provided by the embodiments corresponding to FIGS. 1 to 2 and FIGS. 5 to 6 , which will not be repeated here.

The above are merely examples of the present application, and are not intended to limit the protection scope of the present application. Any modifications, equivalent replacements and improvements made within the spirit and scope of this application are included within the protection scope of this application.

Industrial Applicability

Embodiments of the present application provide an information alarm method, device, and storage medium. The method includes: collecting a target monitoring index of a target monitoring object according to a first sampling interval to obtain a first monitoring value at the current moment; obtaining a historical moment to collect the target a first historical monitoring value obtained from a monitoring index; a target threshold is determined based on the first monitoring value and the first historical monitoring value; wherein the target threshold includes at least one different threshold; based on the first monitoring value and the target threshold value to determine alarm prompt information; wherein, the alarm prompt information is used to provide an alarm prompt for the target monitoring index of the target monitoring object; display the alarm prompt information, so that the information alarm device can The first monitoring value at the time and the first historical monitoring value at the historical moment dynamically determine the target threshold to generate alarm prompt information according to the relationship between the target threshold and the first monitoring value, which solves the problem of using a fixed threshold to realize database monitoring. This leads to the problem that the alarm requirements of the database in each time period cannot be accurately realized, and the solution of adaptively adjusting the threshold according to the actual situation to realize the database monitoring is realized, which effectively improves the accuracy of the database alarm.

Claims

An information warning method, the method comprising:

Collect the target monitoring index of the target monitoring object according to the first sampling interval, and obtain the first monitoring value at the current moment;

Obtain the first historical monitoring value obtained by collecting the target monitoring index at historical time;

A target threshold is determined based on the first monitoring value and the first historical monitoring value; wherein the target threshold includes at least one different threshold;

Determine alarm prompt information based on the first monitoring value and the target threshold; wherein, the alarm prompt information is used to provide an alarm prompt for the target monitoring indicator of the target monitoring object;

The alarm prompt information is displayed.
The method of claim 1, wherein the determining a target threshold based on the first monitoring value and the first historical monitoring value comprises:

Obtain the second monitoring value at the current moment of the reference monitoring indicator of the target monitoring object and the second historical monitoring value collected at the historical moment of the reference monitoring indicator; wherein, the reference monitoring indicator and the target monitoring indicator have connection relation;

determining a target weight coefficient based on the first monitoring value, the first historical monitoring value, the second monitoring value and the second historical monitoring value;

determining a first reference value based on the first historical monitoring value;

From the first historical monitoring value, obtain the first historical sub-monitoring value of the previous moment adjacent to the current moment;

determining the difference between the first monitoring value and the first historical sub-monitoring value to obtain a second reference value;

The target threshold value is obtained based on the target weight coefficient, the second reference value, the first monitoring value, at least one preset weight coefficient and the first reference value.
The method according to claim 2, wherein the determining the target weight coefficient based on the first monitoring value, the first historical monitoring value, the second monitoring value and the second historical monitoring value comprises: :

The first monitoring value and the first historical monitoring value are processed by determining the difference between the monitoring value at the second moment and the monitoring value at the first moment, so as to obtain the second difference between the target monitoring index at different times value; wherein, the first moment and the second moment are two adjacent moments, and the first moment is farther from the current moment than the second moment is from the current moment;

The second monitoring value and the second historical monitoring value are processed by determining the difference between the monitoring value at the second moment and the monitoring value at the first moment, so as to obtain the third difference between the reference monitoring index at different moments value;

determining the ratio of the third difference and the second difference at the same moment to obtain a reference ratio;

Based on the reference ratio, a target weighting coefficient is determined.
The method according to claim 3, wherein the determining a target weight coefficient based on the reference ratio comprises:

Obtain from the reference ratio a second preset number of target ratios whose ratios are greater than zero and are closest to the current moment;

The average value of the second preset number of the target ratios is determined to obtain the target weight coefficient.
The method according to claim 2, wherein the determining the first reference value based on the first historical monitoring value comprises:

From the first historical monitoring value, obtain the first predetermined number of second historical sub-monitoring values at the same moment as the current moment in a first predetermined number of time periods before the current moment;

The standard deviation of the first preset number of the second historical sub-monitoring values is determined to obtain the first reference value.
The method according to claim 2, wherein the said target weight coefficient, the second reference value, the first monitoring value, the at least one preset weight coefficient and the first reference value are obtained based on the target thresholds, including:

determining a first product of the target weight coefficient and the second reference value;

determining the product of the at least one preset weight coefficient and the first reference value to obtain at least one second product;

An accumulated value of the first product, each of the at least one second product, and the first monitoring value is determined to obtain the target threshold value.
The method according to claim 1, wherein the determining the alarm prompt information based on the first monitoring value and the target threshold value comprises:

obtaining the target upper limit value of the target monitoring indicator;

If the first monitoring value is less than the target upper limit value, and the first monitoring value is greater than or equal to the first threshold value, continuously collect a third preset number of third target monitoring indicators according to the second sampling interval a monitoring value; wherein the second sampling interval is smaller than the first sampling interval, and the target threshold includes the first threshold;

If the third preset number of third monitoring values are all smaller than the target upper limit value, and at least one of the third monitoring values is greater than or equal to the second threshold value, first alarm information is generated; wherein, the target threshold value The second threshold value is included, the second threshold value is greater than the first threshold value, and the first alarm information is used to realize a major alarm for the target monitoring object.
The method of claim 7, wherein the method further comprises:

If the first monitoring value is greater than or equal to the target upper limit value, generate second alarm information; wherein, the second alarm information is used to implement a serious alarm for the target monitoring object;

If at least one of the third preset number of third monitoring values is greater than or equal to the target upper limit value, generating the second alarm information;

If the third preset number of third monitoring values are all smaller than the second threshold, third alarm information is generated; wherein, the third alarm information is used to implement a secondary alarm for the target monitoring object.
The method according to claim 7 or 8, wherein after the alarm prompt information is determined based on the first monitoring value and the target threshold, the method further comprises:

If the alarm prompt information is the first alarm information or the second alarm information, obtain at least one structured query language SQL statement executed by the target monitoring object at the current moment;

obtaining the execution plan corresponding to the at least one SQL statement;

Determine, based on the execution plan corresponding to the at least one SQL statement, the consumption cost of each of the SQL statements corresponding to the target monitoring indicator, and obtain the consumption cost corresponding to the at least one SQL statement;

Based on the consumption cost corresponding to the at least one SQL statement, sort the at least one SQL statement according to the sorting order of the consumption cost from high to low to obtain a SQL statement sorting result;

Display the sorted result of the SQL statement.
The method according to claim 9, wherein the consumption cost of each of the SQL statements corresponding to the target monitoring indicators includes input and output IO consumption costs, and the determination of each SQL statement is based on the execution plan corresponding to the at least one SQL statement. The SQL statement corresponds to the consumption cost of the target monitoring indicator, and the consumption cost corresponding to the at least one SQL statement is obtained, including:

Based on the execution plan corresponding to the at least one SQL statement, determine the number of rows of each identity ID included in the execution plan corresponding to each of the SQL statements;

Determine that the ID whose row number is 1 is the first ID, and obtain the first row number and average length corresponding to the first ID; wherein, the first row number is recorded in the execution plan corresponding to each of the SQL statements;

Rounding up the product of the first row number and the average length and the preset InnoDB data page size to obtain the IO consumption cost of the first ID;

Determine that the ID with the number of rows greater than 1 is the second ID, and determine the number of returned rows and the number of scanned rows of each row of the second ID;

Obtain the average length corresponding to the corresponding second ID;

Determine the difference between the scan line number of each row of the second ID and the return line number of the corresponding adjacent previous line to obtain the first difference value;

Determine that the product of the first difference and the average length and the preset InnoDB data page size are rounded up to obtain the IO consumption sub-cost corresponding to each row of the second ID;

Determine the cumulative value of the IO consumption sub-cost corresponding to each row of the second ID, and obtain the IO consumption cost of the second ID;

Determine the cumulative value of the IO consumption cost of each ID included in the execution plan corresponding to each of the SQL statements, and obtain the consumption cost corresponding to the at least one SQL statement; wherein, the cumulative value of the IO consumption cost of each ID includes The IO consumption cost of the first ID and/or the IO consumption cost of the second ID.
The method according to claim 9, wherein the consumption cost of each of the SQL statements corresponding to the target monitoring indicators includes the CPU consumption cost of the central processing unit, and the determination of each SQL statement is based on the execution plan corresponding to the at least one SQL statement. 1. The consumption cost of the SQL statement corresponding to the target monitoring indicator, and obtaining the consumption cost corresponding to the at least one SQL statement, including:

Based on the execution plan corresponding to the at least one SQL statement, determine the number of rows of each identity ID included in the execution plan corresponding to each of the SQL statements;

It is determined that the ID with a row number of 1 is the first ID;

Determine the CPU consumption cost corresponding to the first ID based on the execution plan of the first ID;

It is determined that the ID with the number of rows greater than 1 is the second ID;

Determine the CPU consumption cost corresponding to each row of the second ID based on the execution plan of each row of the second ID;

The CPU consumption cost corresponding to each row of the second ID is accumulated to obtain the CPU consumption cost corresponding to the second ID.
The method according to claim 11, wherein, determining the CPU consumption cost corresponding to the first ID in the execution plan based on the first ID, comprising:

Determine the first row number and the returned row number corresponding to the first ID based on the execution plan of the first ID;

From the execution plan of the first ID, obtain the access type Type and extra field information Extra corresponding to the first ID;

Obtain the first CPU consumption sub-cost corresponding to the first ID based on the Type, the Extra, and the first row number corresponding to the first ID;

Determine the product of the logarithm of the number of returned rows and the number of returned rows to obtain the second CPU consumption sub-cost corresponding to the first ID;

The sum of the first CPU consumption sub-cost and the second CPU consumption sub-cost corresponding to the first ID is determined, and the CPU consumption cost corresponding to the first ID is obtained.
The method according to claim 11, wherein, determining the CPU consumption cost corresponding to each row of the second ID based on the execution plan of each row of the second ID, comprising:

Based on the execution plan of each row of the second ID, determine the second row number and the returned row number of each row of the second ID;

From the execution plan corresponding to each row of the second ID, obtain the access type Type and extra field information Extra corresponding to each row of the second ID, and the number of table rows corresponding to each row of the second ID;

Based on the Type, the Extra, and the number of the second rows corresponding to each row of the second ID, obtain a third CPU consumption sub-cost corresponding to each row of the second ID;

determining the product of the logarithm of the number of returned rows of each row of the second ID and the corresponding number of returned rows, to obtain the fourth CPU consumption sub-cost corresponding to each row of the second ID;

Determine the product of the number of table rows corresponding to each row of the second ID and the index height corresponding to each row of the second ID, and obtain the fifth CPU consumption sub-cost corresponding to each row of the second ID;

Determine the cumulative value of the third CPU consumption sub-cost, the fourth CPU consumption sub-cost and the fifth CPU consumption sub-cost corresponding to each row of the second ID, and obtain each row of the second ID CPU consumption cost.
The method according to claim 7 or 8, wherein after the alarm prompt information is determined based on the first monitoring value and the target threshold, the method further comprises:

If the alarm prompt information is the first alarm information or the second alarm information, obtain at least one SQL statement executed by the target monitoring object at the current moment;

Grouping the at least one SQL statement in the same manner as the statement to obtain at least one group of SQL statements;

Based on the at least one group of SQL statements, count the number of SQL statements included in each group of SQL statements;

Obtain one SQL statement from each group of SQL statements of the at least one group of SQL statements to obtain at least one target SQL statement;

Determine a target standby database, and run each of the target SQL statements respectively through the target standby database;

Determine the resource consumption sub-cost consumed when the target standby database runs each of the target SQL statements, and obtain the resource consumption sub-cost of each of the target SQL statements;

Determine the product of the resource consumption sub-cost of each of the target SQL statements and the number of SQL statements included in the group where each of the target SQL statements is located, to obtain the resource consumption cost of each group of the SQL statements;

The at least one set of SQL statements is sorted according to the sorting order of the resource consumption cost of each set of the SQL statements, to obtain a sorting result, and display the sorting result.
The method according to claim 14, wherein the determining the resource consumption sub-cost consumed when the target standby database runs each of the target SQL statements, and obtaining the resource consumption sub-cost of each of the target SQL statements, comprises: :

If the target standby database runs each of the target SQL statements for a duration greater than or equal to a preset duration, determining that the resource consumption sub-cost of each of the target SQL statements is a first value;

If the duration of the target standby database running each of the target SQL statements is less than the preset duration, obtaining a resource consumption table corresponding to the target standby database running each of the target SQL statements;

Obtain the first consumption resource and the second consumption resource from the resource consumption table corresponding to each target SQL statement, determine the sum of the first consumption resource and the second consumption resource, and obtain each of the The resource consumption sub-cost corresponding to the target SQL statement; wherein, the first consumption resource is the CPU resource consumed by the user state, the second consumption resource is the CPU resource consumed by the core state, and/or the first consumption resource The resource is the number of input block operations, and the second consumed resource is the number of output block operations.
An information alarm device, the device includes a memory, a processor and a communication bus; wherein:

the memory for storing executable instructions;

the communication bus for realizing the communication connection between the processor and the memory;

The processor is configured to execute the information alarm program stored in the memory to implement the steps of the information alarm method according to any one of claims 1 to 15.
A storage medium, storing an information alarm program on the storage medium, the information alarm program implementing the steps of the information alarm method according to any one of claims 1 to 15 when the information alarm program is executed by a processor.