Method, medium and equipment for analyzing MYSQL database transaction

A database and transaction technology, applied in the field of MySQL database, can solve the problems of not fully meeting the operation and maintenance requirements, difficult to locate, and unidentifiable, so as to reduce the workload and the probability of errors, improve security, and improve the efficiency of operation and maintenance. Effect

Pending Publication Date: 2022-03-25
欧冶云商股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

A transaction is composed of one or more SQLs. Daily manually triggered SQLs can be verified through inquiry and communication. The most difficult thing is the SQLs triggered by applications. Since they occur many times a day and are mostly operated by clients, Difficult to locate when encountering problems
Even with professional audit tools such as database auditing, he can accurately record every executed SQL sentence, but is this SQL executed successfully? Has it been revoked? And which SQL's belong to which transaction? these are unrecognizable
[0004] In order to solve the above technical problems, it is necessary to analyze the underlying database logs. MySQL provides a tool called MySQLBINLOG to analyze the archived logs (binary), and record the steps from the beginning to the end of each transaction in detail, but this is actually not the case. Did not fully meet operation and maintenance requirements

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
  • Method, medium and equipment for analyzing MYSQL database transaction
  • Method, medium and equipment for analyzing MYSQL database transaction
  • Method, medium and equipment for analyzing MYSQL database transaction

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments. This embodiment is carried out on the premise of the technical solution of the present invention, and detailed implementation and specific operation process are given, but the protection scope of the present invention is not limited to the following embodiments.

[0035] Such as figure 1 As shown, the present invention provides a method for parsing MYSQL database transactions, including the following steps: based on the naming rules of the binary log, the absolute path where the binary log is obtained according to the naming parameters; calling MySQLBINLOG to perform initial parsing of the binary log to obtain the first parsing Result; the transaction-related information is extracted from the first parsing result by Linux commands to realize secondary cleaning; the transaction-related information is analyzed, and the readable operation and main...

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 relates to a method, a medium and equipment for analyzing MYSQL database transactions. The method comprises the following steps: acquiring an absolute path where a binary log is located; calling MySQLBINLOG to carry out primary analysis on the binary log to obtain a first analysis result; extracting transaction related information from the first analysis result through a Linux command to realize secondary cleaning; analyzing the transaction related information to obtain a readable operation and maintenance log; the method further comprises the step of obtaining a log parameter statistical result based on the transaction related information. Compared with the prior art, the method has the advantages that the workload and the error probability of existing manual troubleshooting are reduced, the safety of maintenance and management of the IT system is improved, and the operation and maintenance efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of MySQL database, in particular to a method, medium and equipment for parsing transaction of MYSQL database. Background technique [0002] The MySQL database is known as the most popular open source database, and its installation and basic use are relatively simple, so its use is very common. But one characteristic of open source software is that if you want to use it well, the learning cost is relatively high. There are basically no problems with simple business scenarios and simple implementations, but it takes a lot of investment to deal with and analyze some problems. [0003] Relational databases are characterized by ACID characteristics and the concept of transactions. A transaction is composed of one or more SQLs. Daily manually triggered SQLs can be verified through inquiry and communication. The most difficult thing is the SQLs triggered by applications. Since they occur many times a day ...

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/21G06F16/28
CPCG06F16/21G06F16/284
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