Database performance monitoring method, system and equipment as well as computer readable storage medium

Abstract

The embodiment of the invention provides a database performance monitoring method, system and computer equipment as well as a computer readable storage medium. The method comprises the following steps: acquiring log data of a database and hardware information of a server in which the database is located; inputting the log data and the hardware information to a pre-warning monitoring module in realtime, wherein the pre-warning monitoring module outputs pre-warning monitored results of the database, and the pre-warning monitoring module adopts historical log data of the database and historicalhardware information of the server in which the database is located as input data. According to the scheme adopted by the invention, the log data of the database and the hardware information of the server are combined to monitor the state of the database, so that the problem that a false alarm rate caused by database monitoring through single factor is high is favorably avoided, the state of the database can be monitored more accurately, and the false alarm rate is reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database performance monitoring method, system, equipment and computer-readable storage medium. Background technique [0002] At present, database monitoring is mainly to issue alarms after problems occur. According to simple judgment rules, several operating parameters of the database are judged and alarmed. Because the judgment rules are rigid, false alarms are often generated, which increases operation and maintenance costs. [0003] The currently used database monitoring software is Qmonintor, which is a professional database monitoring platform software for Oracle and MySQL. According to user settings, timely and effectively alarm the abnormality of the database, which is convenient for users to view various real-time status curve indicators, and conduct statistical analysis on monitoring and performance data, and generate relevant reports from the perspectives of operat...

AI Technical Summary

Problems solved by technology

[0007] The embodiment of the present invention provides a database performance monitoring method to solve the technical problem of high false alarm rate in the database monitoring process in the prior art

[0008] The embodiment of the present invention also provides a computer device to solve the technical problem of high false alarm rate in the database monitoring process in the prior art

Images