Slow log processing method and device, electronic equipment and storage medium

A processing method and slow log technology, applied in the computer field, can solve the problems of large time consumption, large data volume, and many data types of slow log files, and achieve the effect of avoiding repeated analysis and facilitating analysis

Pending Publication Date: 2022-05-13
CHINA TELECOM CORP LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, due to the many types of data and the large amount of data in the slow log file, the analysis of the slow log file is cumbersome and takes a lot of time, which leads to low efficiency in the analysis of the slow log file

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
  • Slow log processing method and device, electronic equipment and storage medium
  • Slow log processing method and device, electronic equipment and storage medium
  • Slow log processing method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0040] refer to figure 1 , which shows a flow chart of the steps of a slow log processing method of the present application. The slow log processing method provided in the embodiment of the present application may specifically include the following steps:

[0041] In step S110, the slow log of the target database is collected. Wherein, the slow log includes a corresponding target server identifier.

[0042] In the embodiment provided by this application, the slow logs of MySQL can be collected in real time based on logstash for analysis. Among them, Logstash is a lightweight, open source server-side data processing pipeline that allows data to be collected from various sources, dynamically transformed,...

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 provides a slow log processing method and device, electronic equipment and a storage medium, and the method comprises the steps: collecting a slow log of a target database, the slow log comprising a corresponding target server identifier; obtaining a target value corresponding to an SQL statement in the slow log, and forming a target key value pair by the target server identifier and the target value; and writing the target key value pair into a target Redis cache. In this way, the slow log can be analyzed more conveniently through the key value pair, in addition, incremental data of the slow log can be analyzed, and repeated analysis of the slow log is avoided.

Description

technical field [0001] The present application relates to the field of computer technology, and in particular to a slow log processing method, device, electronic equipment and storage medium. Background technique [0002] At present, as databases are more and more widely used, the cost of database performance maintenance is also increasing, and the analysis of slow log files can help developers find out the statements that have the greatest impact on the process, thereby optimizing the overall performance of the system. [0003] However, due to the many types of data and the large amount of data in the slow log file, the analysis of the slow log file is cumbersome and requires a lot of time, which leads to low efficiency in the analysis of the slow log file. Therefore, a technical problem that needs to be urgently solved by those skilled in the art is: how to improve the analysis efficiency of slow logs. Contents of the invention [0004] In order to solve the above techn...

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/18G06F16/242G06F16/2455G06F16/27G06F16/23
CPCG06F16/1815G06F16/242G06F16/24552G06F16/27G06F16/2358
Inventor 周福可王健徐锐甄青伟张磊槐正
Owner CHINA TELECOM CORP LTD
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