SQL semantic extensibility-based performance diagnosis and optimization method

Abstract

The invention discloses an SQL semantic extensibility-based performance diagnosis and optimization method. The method is implemented by the steps of firstly obtaining performance data; finding out an SQL statement needed to be diagnosed from the obtained data, and analyzing the SQL statement into a syntax tree; analyzing the syntax tree, wherein the analysis of the syntax tree can be extended; and giving out a diagnosis result and optimization suggestions according to an analysis result, namely giving out index creation or adjustment suggestions. Compared with the prior art, the SQL semantic extensibility-based performance diagnosis and optimization method has the advantages that a more comprehensive and systematic index adjustment analysis method is provided; the consumption of physical and logic IO of a system is reduced; the response performance and throughput of the whole system are improved; the response performance of the system can be effectively ensured; the maintenance cost of the system is reduced; and the method is high in practicality and wide in application range, and has very high promotion and application values.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to an extensible performance diagnosis and optimization method based on SQL semantics. Background technique [0002] With the development of social informatization, the business and technical architecture of modern IT systems are becoming more and more complex, and the scale of the system is getting larger and larger. Especially in order to adapt to the flexibility of the business, many functions are implemented through configuration, adaptation, secondary development, etc. In this case, the data distribution of the original system will have a large skew, and the rationality of the default index will often appear insufficient, and even play a negative role in special scenarios. However, developers of a single module lack a comprehensive understanding of the access method of a certain data table, have a one-sided understanding of the internal operating mechanism of the database, an...

AI Technical Summary

Problems solved by technology

[0002] With the development of social informatization, the business and technical architecture of modern IT systems are becoming more and more complex, and the scale of the system is getting larger and larger. Especially in order to adapt to the flexibility of the business, many functions are implemented through configuration, adaptation, secondary development, etc. In this case, the data distribution of the original system will have a large inclination, and the rationality of the default index will often appear insufficient, and even play a negative role in special scenarios

However, developers of a single module lack a comprehensive understanding of the access method of a certain data table, and have a one-sided understanding of the internal operating mechanism of the database. Faced with stress testing and performance problems in the production environment, they often do not know how to start

Images