Method and device for performance statistics of structured query language SQL

Abstract

Embodiments of the present invention provide a method and device for statistics of structured query language SQL performance. The method includes: acquiring SQL-type log information, the log information including SQL statements and execution performance information of the SQL statements; A piece of log information, parsing the SQL statement, splitting the SQL statement according to a predetermined splitting character to obtain a split SQL statement; using the split SQL statement as the first index information of the performance statistics list, according to the second An index information, storing the execution performance information of the SQL statement in the current log information to the performance statistics list; according to the execution performance information of the SQL statement in the current log information stored in the performance statistics list, counting the current log information The performance data of the SQL statement. Through the invention, the performance statistics of SQL statements can be performed quickly and efficiently, and the SQL statements with abnormal problems can be accurately searched.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for statistics of the performance of a structured query language SQL. Background technique [0002] At present, business systems are usually divided into multiple modules, and each module has data access operations. Usually, data access operations in this mode are implemented by calling external interfaces or database operation statements. Due to some uncertainties in the process of calling external interfaces or performing database operations, it is impossible to determine the impact of external interfaces or database operations on business system performance. Therefore, it is necessary to monitor external interfaces or database operations, such as monitoring external The running time of the interface or database operation, etc., when the monitoring finds that the time is abnormal, the development and operation and maintenance personnel can be notified in t...

AI Technical Summary

Problems solved by technology

[0005] In the process of realizing the present invention, the inventor finds that there are at least the following problems in the prior art: on the one hand, although the Antlr syntax analyzer can parse the parameters of the SQL statement very accurately, it must be nested in the project to be used to achieve For the analysis of SQL statements, since Antlr itself contains a lot of grammatical analysis, there will be redundancy in nested projects, making the project more cumbersome; It is more accurate to parse SQL statements with a relatively short length, but because the number and length of parameters are uncontrollable and unknown, if you encounter SQL statements with many parameters and long parameter lengths, the parsing will be inaccurate , therefore, it is impossible to completely merge similar SQL statements, and the monitoring of SQL statements cannot have a good effect

Images