A Locating Method for Distributed Database Performance Faults

Abstract

The invention provides a positioning method for a performance fault of a distributed database. The positioning method comprises the following steps: acquiring an SQL sentence sent by a user, and positioning the SQL sentence; searching problem nodes with the performance fault from nodes of the distributed database; comparing the SQL sentence execution plans of the problem nodes and the non-problem nodes; searching and determining the resource use conditions of the problem nodes; determining whether all problem nodes are positioned; and examining and correcting the performance of a coordinator. With the adoption of the method, the time of positioning the fault under the distributed database environment can be greatly reduced; the performance fault can be effectively, accurately and reliably positioned, so that the maintenance time and cost can be reduced, and the running stability of the distributed database can be improved.

Description

technical field [0001] The invention relates to the field of database optimization, in particular to a method for locating performance faults of distributed databases. Background technique [0002] In recent years, with the development of the Internet and mobile Internet, the amount of data stored by enterprises has increased geometrically, and the traditional way of storing data in databases has become less and less practical, and new data storage architectures have been invented. [0003] The distributed database storage architect is an extension of the traditional single-node database, which allows data to be stored on more nodes, and at the same time does not have much impact on the business logic of the system. It is a big data storage preferred by many enterprises and processing solutions. [0004] However, the distributed database architecture has brought more maintenance problems to the operation and maintenance personnel. The most prominent one is the positioning o...

AI Technical Summary

Problems solved by technology

[0004] However, the distributed database architecture has brought more maintenance problems to the operation and maintenance personnel. The most prominent one is the positioning of distributed database performance problems. Since user query requests occur on multiple database nodes, when performance problems occur, Locating the problem on multiple nodes is much more difficult than locating the performance on a single database. This is a big challenge for the DBA. The more nodes there are in the MPP, the more difficult it is to locate the fault. At present, there are very few researches on the performance positioning methods of distributed databases in the industry

Images