Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Statement early warning method and device, equipment and computer readable storage medium

An early warning device and sentence technology, applied in the field of financial technology, can solve the problems of high cost of slow query optimization, failure to carry out normally, increase the load of production database, etc., and achieve the effect of low cost and reduced optimization cost

Pending Publication Date: 2019-07-16
WEBANK (CHINA)
View PDF0 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantages of this method are: 1) When an abnormality is detected, the slow query in the production database has already formed, and the formed slow query often means that the data scale of the target table of the query has grown relatively large, forming a large table, while When the optimization plan involves operations such as adding indexes, adding fields, and partitioning to large tables, it will be accompanied by a long period of time for the production database to lock the table. During this period, the business that has write operations on the large table cannot be carried out normally. , which results in higher optimization costs for slow queries
2) The monitoring logic has query operations on the production database, which objectively increases the load on the production database. In addition, the monitoring logic and the production database are deployed on the same physical resource, which will also cause certain resource contention and affect the performance of the production database.

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
  • Statement early warning method and device, equipment and computer readable storage medium
  • Statement early warning method and device, equipment and computer readable storage medium
  • Statement early warning method and device, equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0069] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0070] Such as figure 1 as shown, figure 1 It is a schematic diagram of the device structure of the hardware operating environment involved in the solution of the embodiment of the present invention.

[0071] The sentence warning device in the embodiment of the present invention may be a PC or a server device.

[0072] Such as figure 1 As shown, the sentence warning device may include: a processor 1001 , such as a CPU, a network interface 1004 , a user interface 1003 , a memory 1005 , and a communication bus 1002 . Wherein, the communication bus 1002 is used to realize connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and ...

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 statement early warning method. The method comprises the steps of obtaining a structured query statement of an application program accessing a preset production database; obtaining an execution plan of the structured query statement, and extracting preset parameters related to slow query from the execution plan; judging whether the extracted preset parameters meet a preset slow query early warning condition or not; and when the preset parameter satisfies a preset slow query early warning condition, adding the corresponding structured query statement into a preset early warning list. The invention further discloses a statement early warning device, equipment and a computer readable storage medium. The optimization cost of slow query can be reduced on the premise that the performance of the production database is not influenced.

Description

technical field [0001] The invention relates to the technical field of financial technology (Fintech), in particular to a sentence early warning method, device, equipment and a computer-readable storage medium. Background technique [0002] With the continuous development of financial technology (Fintech), especially Internet technology finance, more and more technologies are applied in the financial field. MySQL is currently one of the most popular relational database management systems, and SQL (Structured Query Language, Structured Query Language) used by MySQL is the most commonly used standardized language for accessing databases. In the process of using SQL language to query the database, the phenomenon that the query response time exceeds the specified time is called slow query. Slow query will affect the performance of the database and application system, and in severe cases, it will affect the availability of the application system. [0003] At present, in order to...

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): G06F16/2453
CPCG06F16/2453
Inventor 王锋李宗波
Owner WEBANK (CHINA)
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products