Method and device for monitoring and managing slow SQL of database

Abstract

The invention discloses a method and a device for monitoring and managing a slow SQL of a database, and relates to the field of automatic programming. A specific embodiment of the method comprises the following steps: analyzing an SQL main body from an SQL request of a first user; encrypting the SQL main body to obtain an identification encryption string, and judging whether the identification encryption string exists in an illegal slow SQL base number library or not; if yes, intercepting the SQL request, and refusing to send the SQL request to a database; otherwise, sending the SQL request to a database. In the method, the SQL main body is analyzed and encrypted, slow SQL statements are effectively intercepted, and manual troubleshooting is replaced by an automatic mode; meanwhile, a set of forced optimization mechanism for the slow SQL statements is established, risk monitoring is moved forward, and measurement and interception can be achieved in development and test environments.

Description

technical field [0001] The invention relates to the technical field of automatic program design, in particular to a method and device for monitoring and managing database slow SQL Background technique [0002] With the rapid development of the Internet, the performance requirements of the software system are becoming more and more stringent. Slow SQL statements will greatly reduce the performance of the software system due to the long execution time. There are many factors that cause the execution time of SQL statements to be too long, including hardware, locks, and problems in writing SQL statements, but the most common problem is writing problems in SQL statements. [0003] At present, there is no database access management method for effectively intercepting slow SQL statements, and it is impossible to quickly optimize slow SQL statements after effective screening. In the development or test environment, slow SQL statements can be detected as early as possible and effecti...

AI Technical Summary

Problems solved by technology

[0003] At present, there is no database access management method for effectively intercepting slow SQL statements, and it is impossible to quickly optimize slow SQL statements after effective screening. In the development or test environment, slow SQL statements can be detected as early as possible and effectively intercepted, reducing or even avoiding Bringing slow SQL statements to the production environment has become an urgent problem to be solved

Images