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

A monitoring system and database technology, applied in the database field, can solve the problems of high false alarm rate and high false alarm rate in the database, and achieve the effects of avoiding high false alarm rate, reducing false alarm rate and accurate monitoring.

Inactive Publication Date: 2018-08-10
CHINA SPORTS LOTTERY TECH GROUP
View PDF7 Cites 35 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 p

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database performance monitoring method, system and equipment as well as computer readable storage medium
  • Database performance monitoring method, system and equipment as well as computer readable storage medium
  • Database performance monitoring method, system and equipment as well as computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in further detail below in conjunction with the embodiments and accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0022] In an embodiment of the present invention, a database performance monitoring method is provided, such as figure 1 As shown, the method includes:

[0023] Step 101: collect the log data of the database and the hardware information of the server where the database is located in real time;

[0024] Step 102: Input the log data and the hardware information into the early warning monitoring model in real time, and the early warning monitoring model outputs the early warning monitoring results of the database, wherein the early warning monitoring model adopts the historical log data and The ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F11/34G06F11/30
CPCG06F11/302G06F11/3055G06F11/3065G06F11/3447G06F11/3476G06F2201/80
Inventor 章小文罗春水强华盛沈滨王彤
Owner CHINA SPORTS LOTTERY TECH GROUP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap