Database slow query log processing method, server, computing device and system

A data query and slow query technology, applied in the field of database slow query log processing, can solve the problems of poor timeliness, inaccurate index data dimension in SQL mode report, low efficiency, etc., and achieve easy access and easy multi-dimensional analysis and report generation Effect

Active Publication Date: 2021-03-16
海南车智易通信息技术有限公司
View PDF14 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, the efficiency of using this tool to analyze and process log files is very low, and the periodic analysis and timeliness analysis of logging in to the server are all at the minute level, and the timeliness is poor , the generated SQL mode report is also inaccurate and the indicator data dimension is too small

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 slow query log processing method, server, computing device and system
  • Database slow query log processing method, server, computing device and system
  • Database slow query log processing method, server, computing device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0029] figure 1 A schematic diagram of a system 100 for processing slow query logs of a database according to an embodiment of the present invention is shown. Such as figure 1As shown, the system 100 includes a log storage device 110 , a server 120 , a messaging system 130 and a computing platform 140 . Wherein, the server 120 is connected in communication with the log storage device 110 and the message system 130 respectively, a...

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 invention discloses a database slow query log processing method, which comprises the following steps that a server acquires the slow query logs from log storage equipment in real time, and performs pattern matching on each slow query log by adopting a slow query matching library preset in the server to obtain data query statements and data query index values in the slow query logs; the servergenerates a structured message of the slow query log based on the data query statement and each data query index value, and sends the structured message to a message system; and the computing platformacquires the structured message from the message system in real time, performs syntax tree analysis on a data query statement in the structured message to generate an abstract mode of the data querystatement, and performs statistical analysis and data storage based on the abstract mode and the corresponding data query index value. The invention further discloses a processing method of the database slow query log executed by the server and the computing platform part, the corresponding server and the corresponding computing equipment.

Description

technical field [0001] The invention relates to the field of log processing, in particular to a processing method, server, computing device and system for slow query logs of a database. Background technique [0002] As we all know, most of the performance and stability problems encountered in database operation and maintenance work are data query problems. If this problem can be effectively solved, basically all major database products will be equipped with slow query log functions, which will soon meet Certain conditional SQL is output to the slow query log file. In most scenarios, database administrators use tools such as pt-query-digest to perform simple manual or periodic analysis on slow query log files, and diagnose, optimize, and transform problematic SQL based on the analysis results. [0003] However, the efficiency of using this tool to analyze and process log files is very low, and the periodic analysis and timeliness analysis of logging in to the server are both...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/2458G06F16/18G06F8/41
CPCG06F16/2433G06F16/2462G06F16/1815G06F8/42
Inventor 陶会祥
Owner 海南车智易通信息技术有限公司
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