DML processing method and device

A processing method and monitoring agent technology, applied in the field of distributed systems, can solve problems such as difficult to cope with the scale and automation requirements of distributed MySQL, insufficient to meet the fine-grained analysis, etc.

Inactive Publication Date: 2017-05-17
无线生活(杭州)信息科技有限公司
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of this solution is that it is difficult to meet the scale and automation requirements of distributed MySQL. At the same time, the information of

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
  • DML processing method and device
  • DML processing method and device
  • DML processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053] The preferred embodiments of the present invention will be described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described here are only used to illustrate and explain the present invention, and are not intended to limit the present invention.

[0054] figure 1 Shown is a flow chart of a DML processing method in the embodiment of the present invention, as figure 1 As shown, the DML processing method includes the following steps S11-S14:

[0055] Step S11, receiving the input data manipulation language DML.

[0056] Step S12, the preset program detects and analyzes the data manipulation language DML, and analyzes the structured query language SQL that meets the preset conditions.

[0057] Step S13, using at least one preset optimization method to optimize the structured query language SQL, and recording the optimization result of each optimization method.

[0058] Step S14, determine the target optimization...

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 discloses a DML processing method and device. The method includes the steps that input data manipulation language (DML) is received, preset programs are used for detecting and analyzing the DML, structured query language (SQL) meeting the preset condition in the DML is analyzed, at least one preset optimizing mode is adopted to optimize the SQL, the optimization results of all the optimizing modes are recorded, the target optimizing mode is determined according to the optimization results, and the SQL meeting the preset condition and the target optimizing mode are sent to a developer. By means of the technical scheme, performance of the distributed MySQL mass DML can be analyzed in real time and ensured, how to optimize the SQL can be analyzed automatically to give an optimized suggestion finally, and the developer can optimize the programs according to the suggestion to improve service stability.

Description

technical field [0001] The invention relates to the field of distributed systems, in particular to a DML processing method and device. Background technique [0002] There are many distributed MySQL nodes, and management efficiency needs to be improved. The performance of the MySQL server is easily dragged down by a slow query, which in turn affects the user experience. The main role of MySQL is to undertake the persistent storage of data state changes. Once the performance of MySQL fluctuates, it will have a serious impact on the entire distributed system. Writing an efficient MySQL DML (Data Manipulation Language, Data Manipulation Language) requires very high quality technical personnel. With the growth of data, a DML that was running normally may become a very inefficient query as the business develops. For example, because the index plan is not accurate or the index is not added, it will slowly evolve into a slow query. Or the writing method of SQL does not meet the ...

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/30
CPCG06F16/2454G06F16/2433G06F16/2471
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap