Positioning method for performance fault of distributed database

A locating method and database technology, applied in the field of database optimization, can solve problems such as difficulty locating faults, difficult performance locating, and few researches on distributed database performance locating methods, achieve effective, accurate and reliable locating, and shorten the time for locating performance faults , The effect of reducing maintenance time and cost

Inactive Publication Date: 2017-03-29
长安通信科技有限责任公司 +1
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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

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
  • Positioning method for performance fault of distributed database
  • Positioning method for performance fault of distributed database
  • Positioning method for performance fault of distributed database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0075] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts fall within the protection scope of the present invention.

[0076] like figure 1 As shown, the present invention provides a method for locating a distributed database performance fault, comprising the following steps:

[0077] Step 1. Obtain the SQL statement issued by the user and locate the SQL statement;

[0078] Step 2. Find out the problem nodes with performance failures in the nodes of the distributed database;

[0079] Step 3. compare the execution plan of the SQL statement of the problem node and the non-pr...

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 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...

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
IPC IPC(8): G06F17/30G06F11/30
CPCG06F11/3006G06F16/21
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