Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for processing slow query of database

A database and slow query technology, applied in the database field, can solve the problems of business server impact, database index disorder, large labor costs, etc., to reduce labor costs, reduce the number of slow queries, and improve response speed.

Pending Publication Date: 2021-12-07
CHINA TELECOM CORP LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] This processing method can deal with most of the slow query situations, but it needs to consume a lot of labor costs, and there may be manual errors, so it puts forward higher requirements for the personnel who perform manual solutions.
Moreover, the processing process may affect the business server, and may also cause confusion in the database index

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
  • Method for processing slow query of database
  • Method for processing slow query of database
  • Method for processing slow query of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Various exemplary embodiments of the present disclosure will be described in detail below with reference to the accompanying drawings. It should be noted that relative arrangements of components and steps, numerical expressions and numerical values ​​set forth in these embodiments do not limit the scope of the present disclosure unless specifically stated otherwise.

[0024] The following description of at least one exemplary embodiment is merely illustrative in nature and in no way intended as any limitation of the disclosure, its application or uses. That is, the structures and methods herein are presented by way of example to illustrate various embodiments of the structures and methods of this disclosure. However, those skilled in the art will appreciate that they illustrate merely exemplary, and not exhaustive, ways in which the disclosure may be practiced. Furthermore, the figures are not necessarily to scale and some features may be exaggerated to show details of...

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 method for processing a slow query of a database. The method comprises the following steps: opening a slow query log of the database; collecting a slow query statement from the slow query log; based on the slow query statement, a new database is established, and the new database has a table structure the same as that of the database; performing semantic analysis on the slow query statement to generate a test statement for the new database; applying a candidate solution to the new database, and testing the new database to which the candidate solution is applied by using the test statement; and if the test on the new database to which the candidate solution has been applied passes, applying the candidate solution to the database.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular to a method for processing slow queries of databases. Background technique [0002] A database organizes, stores and manages data according to its data structure. A database is a collection of associated tables, and a table is a matrix of data. By indexing the data in the database and using the index when querying information, you can quickly access specific information in the tables of the database. [0003] Errors may occur when information is queried using an index, and these errors may accumulate. With the continuous growth of the query business volume and the continuous operation of the system, the accumulation of errors may lead to a decrease in the query speed, thereby affecting the overall operation of the system. [0004] You can enable the slow query log function for the database to record statements that take too long to execute or have no indexes and the in...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2453G06F16/242G06F40/30
CPCG06F16/2453G06F16/243G06F40/30
Inventor 郭望纾
Owner CHINA TELECOM CORP LTD