CN115373960A - Database query performance analysis method and device and storage medium - Google Patents

Database query performance analysis method and device and storage medium Download PDF

Info

Publication number
CN115373960A
CN115373960A CN202211026488.6A CN202211026488A CN115373960A CN 115373960 A CN115373960 A CN 115373960A CN 202211026488 A CN202211026488 A CN 202211026488A CN 115373960 A CN115373960 A CN 115373960A
Authority
CN
China
Prior art keywords
database
query performance
performance data
preset
index rule
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202211026488.6A
Other languages
Chinese (zh)
Inventor
王鹏鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN202211026488.6A priority Critical patent/CN115373960A/en
Publication of CN115373960A publication Critical patent/CN115373960A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3409Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment for performance assessment
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3452Performance evaluation by statistical analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/30Monitoring
    • G06F11/34Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
    • G06F11/3466Performance evaluation by tracing or monitoring
    • G06F11/3476Data logging

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Quality & Reliability (AREA)
  • General Physics & Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Evolutionary Biology (AREA)
  • Probability & Statistics with Applications (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a method, a device and a storage medium for analyzing query performance of a database, which are applied to the field of artificial intelligence and the field of finance.

Description

Database query performance analysis method and device and storage medium
Technical Field
The invention belongs to the technical field of intelligent operation and maintenance of databases, and particularly relates to a database query performance analysis method, a database query performance analysis device and a storage medium.
Background
With the acceleration of social digital transformation, the scale of the database is rapidly increased, the data query requests are rapidly increased by services, and the analysis of the query response performance of the database gradually becomes the content of the normalized operation and maintenance work.
In the prior art, operation and maintenance personnel of most enterprises do not have the capability of analyzing the query performance of the database and cannot bear the use cost of high professional database managers to carry out the work, and the query performance of the database is maintained in a poor state for a long time, so that poor user experience is caused, the result of user loss is caused, and enterprise loss is caused.
Disclosure of Invention
In view of the above problems, the present application provides a method, an apparatus, and a storage medium for analyzing database query performance, in order to ensure long-term stable operation of an enterprise and improve the database query performance analysis capability, the specific scheme is as follows:
a database query performance analysis method comprises the following steps:
acquiring current query performance data of a database and a preset query performance index rule of the database;
comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report;
and sending the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
Optionally, the preset query performance index rule of the database is generated in the following manner:
acquiring historical query performance data of the database and an initial query performance index rule of the database;
and adjusting the initial query performance index rule of the database based on the prior expert experience and the historical query performance data of the database to obtain a preset query performance index rule of the database.
Optionally, the obtaining of the historical query performance data of the database includes:
acquiring initial query performance data of the database;
and integrating and summarizing the initial query performance data of the database to obtain the initial query performance data of the database after the integration and summarization as historical query performance data of the database.
Optionally, after the comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report, the method further includes:
if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds a preset query performance index rule of the database, generating alarm notification information;
and sending the alarm notification information to a terminal of a database operation and maintenance worker so that the database operation and maintenance worker maintains the query performance of the database.
A database query performance analysis apparatus, comprising:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring current query performance data of a database and a preset query performance index rule of the database;
the generating unit is used for comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report;
and the sending unit is used for sending the database query performance analysis report to a terminal of a database operation and maintenance worker so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
Optionally, the preset query performance index rule of the database is generated in the following manner:
the first acquisition subunit is used for acquiring historical query performance data of the database and an initial query performance index rule of the database;
and the adjusting subunit is used for adjusting the initial query performance index rule of the database based on the prior expert experience and the historical query performance data of the database to obtain the preset query performance index rule of the database.
Optionally, the first obtaining subunit includes:
the second acquisition subunit is used for acquiring initial query performance data of the database;
and the processing subunit is used for integrating and summarizing the initial query performance data of the database to obtain the initial query performance data of the database after the integration and summarization as historical query performance data of the database.
Optionally, the apparatus further comprises:
a generating subunit, configured to generate alarm notification information if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds a preset query performance index rule of the database;
and the sending subunit is used for sending the alarm notification information to a terminal of a database operation and maintenance worker so as to maintain the query performance of the database by the database operation and maintenance worker.
A database query performance analysis device comprising a memory and a processor;
the memory is used for storing programs;
the processor is used for executing the program and realizing the steps of the intelligent matching method according to any one of claims 1 to 4.
A readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the intelligent matching method of any one of claims 1 to 4.
Based on the technical scheme, the method, the device and the storage medium for analyzing the query performance of the database provided by the invention form the query performance index rule suitable for the self condition of an enterprise after acquiring the current query performance data of the database and the preset query performance index rule of the database, compare the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report, and send the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment, the query performance capability of the database is improved, and the long-term stable operation of the database is ensured.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the application. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a schematic structural diagram of a database query performance analysis system disclosed in an embodiment of the present application;
fig. 2 is a schematic flowchart of a database query performance analysis method according to an embodiment of the present invention;
FIG. 3 is a schematic flowchart illustrating a method for determining a preset query performance indicator rule of the database according to the present invention;
FIG. 4 is a schematic flow chart illustrating a method for obtaining historical query performance data of the database according to the present invention;
FIG. 5 is a schematic flow chart illustrating a method after comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report according to the present invention;
fig. 6 is a schematic structural diagram of an apparatus for analyzing database query performance according to an embodiment of the present disclosure;
fig. 7 is a block diagram of a hardware structure of a database query performance analysis device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the database index monitoring method, device and storage medium provided by the invention can be used in the fields of artificial intelligence, block chaining, distributed, cloud computing, big data, internet of things, mobile internet, network security, chip, virtual reality, augmented reality, holography, quantum computing, quantum communication, quantum measurement, digital twinning or finance. The foregoing is merely an example, and does not limit the application fields of the database index monitoring method, apparatus, and storage medium provided by the present invention.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first," "second," and the like in the description and in the claims, and in the drawings described above, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the terms so used are interchangeable under appropriate circumstances and are merely descriptive of the invention in its embodiments for distinguishing between objects of the same nature. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of elements is not necessarily limited to those elements, but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
In order to ensure long-term stable operation of an enterprise and improve the database query performance analysis capability, the invention provides a database query performance analysis method, which is further described in detail with reference to the accompanying drawings and specific embodiments.
It should be noted that the database query performance analysis method provided by the present invention may be executed by a database query performance analysis system, and for convenience of understanding, the database query performance analysis system is first introduced in the present application.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a database query performance analysis system according to an embodiment of the present invention. The database query performance analysis system comprises an interaction module, an expert experience base module, a query analysis service module and a data agent module, wherein the expert experience base module is connected with the query analysis service module, a calculation storage module, a database module and a message service module, the expert experience base module is connected with the data agent module, the calculation storage module is connected with the expert experience base module and the data agent module, the database module is connected with the data agent module, and the message service module is connected with the query analysis service module.
The expert experience library module comprises an expert module and an index rule library module.
On the basis of the database query performance analysis system provided by the embodiment, the database query performance analysis method provided by the embodiment of the invention is introduced as follows:
referring to fig. 2, fig. 2 is a schematic flow chart illustrating a database query performance analysis method according to an embodiment of the present invention. The method is applied to a database query performance analysis system, and can comprise the following steps:
step S101: and acquiring current query performance data of the database and a preset query performance index rule of the database.
In this step, the database agent module can be started through the interaction module, the current query performance data of the database can be obtained through the database agent module, the current operation state information of the database can be obtained at the same time, the preset query performance index rule of the database can be obtained through the expert experience base module,
it should be noted that the current operation state information of the database mainly refers to database query execution time, application query waiting number, load routing information, query retrieval hit rate of view/storage process/cache, index query execution depth, and the like.
Step S102: and comparing the current query performance data of the database with a preset query performance index rule of the database to generate a database query performance analysis report.
In this step, the current query performance data of the database may be compared with the preset query performance index rule of the database through the query analysis service module, so as to generate a database query performance analysis report.
In the application, the expert experience and the rule can be obtained through the interaction module, the expert module and the index rule base module of the expert experience base module can be used for analyzing and processing based on the expert experience and the rule, the current running state information of the database is combined, the current query performance data of the database is compared with the preset query performance index rule of the database through the query analysis service module, a performance analysis result is obtained, and a database query performance analysis report can be generated based on the performance analysis result through the query performance analysis service module.
It should be noted that the query performance of the database includes the database query performance specifically referred to herein, including query response time, query name neutralization rate, and the like.
Step S103: and sending the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
In this step, the database query performance analysis report may be sent to a terminal of the database operation and maintenance staff through the message service module, so that the database operation and maintenance staff may view the database query performance analysis report and perform corresponding handling, and the database operation and maintenance staff may perform necessary handling work through the handling service module of the index service.
In the method, the historical query performance data and the running state information of the database are subjected to reasoning analysis by using the prior expert knowledge to form a new knowledge rule base, and optimization guidance suggestions for adjusting query indexes, views, storage processes, caches and database scripts are given.
In summary, according to the database query performance analysis method provided by the present invention, after the current query performance data of the database and the preset query performance index rule of the database are obtained, the query performance index rule suitable for the self condition of the enterprise is formed, the current query performance data of the database is compared with the preset query performance index rule of the database to generate the database query performance analysis report, and the database query performance analysis report is sent to the terminal of the database operation and maintenance staff, so that the database operation and maintenance staff can check the database query performance analysis report and perform corresponding handling, thereby improving the capability of the database query performance and ensuring the long-term stable operation of the database.
On the basis of the embodiment disclosed in the present invention, in another embodiment of the present invention, a specific implementation manner of determining the query performance indicator rule of the preset database is described in detail.
As an implementation manner, please refer to fig. 3, which is a flowchart illustrating a method for determining a query performance indicator rule of a preset database according to the present invention. The method may comprise the steps of:
step S201: and acquiring historical query performance data of the database and an initial query performance index rule of the database.
In this step, the historical query performance data of the database and the initial query performance index rule of the database may be obtained through the expert experience library module.
In the present application, details of obtaining the historical query performance data of the database will be described in detail through the following embodiments, and will not be described herein.
Step S202: and adjusting the initial query performance index rule of the database based on the prior expert experience and the historical query performance data of the database to obtain a preset query performance index rule of the database.
In this step, the initial query performance index rule of the database may be adjusted by the expert experience base module based on the prior expert experience and the historical query performance data of the database, so as to obtain the preset query performance index rule of the database.
In summary, in the method for determining the query performance indicator rule of the preset database provided by the embodiment of the present invention, the initial query performance indicator rule of the database is adjusted through the duration query performance data of the database and the prior expert experience, so as to form the query performance indicator rule suitable for the self condition of the enterprise.
On the basis of the embodiments disclosed in the present invention, in yet another embodiment of the present invention, a specific implementation manner for obtaining the historical query performance data of the database is described in detail.
As an implementation manner, please refer to fig. 4, which is a flowchart illustrating a method for obtaining historical query performance data of a database according to the present invention. The method may comprise the steps of:
step S301: initial query performance data for a database is obtained.
In this step, the initial query performance data of the database may be obtained through the computation storage module.
Step S302: and performing integration and summarization on the initial query performance data of the database to obtain the initial query performance data of the database after the integration and summarization as historical query performance data of the database.
In this step, the initial query performance data of the database may be integrated and summarized by the expert experience library module, and the initial query performance data of the database after the integration and summarization is obtained as the historical query performance data of the database.
In summary, the method for obtaining historical query performance data of a database according to the embodiments of the present invention integrates and summarizes the initial query performance data of the database, so as to form integrated and summarized information for use.
On the basis of the embodiment disclosed in the present invention, in another embodiment of the present invention, a detailed description is given to a specific implementation manner after the step S102 compares the current query performance data of the database with the preset query performance index rule of the database, and generates the database query performance analysis report.
As an implementation manner, please refer to fig. 5, which is a flowchart illustrating a method for generating a database query performance analysis report after comparing current query performance data of a database with a preset query performance index rule of the database according to the present invention. The method may comprise the steps of:
step S401: and if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds the preset query performance index rule of the database, generating alarm notification information.
In this step, if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds the preset query performance index rule of the database, the query analysis service module may generate an alarm notification message and send the alarm notification message to the message service module.
Step S402: and sending the alarm notification information to a terminal of the database operation and maintenance personnel so that the database operation and maintenance personnel can maintain the query performance of the database.
In this step, the alarm notification information may be sent to the terminal of the database operation and maintenance staff through the message service module, so that the database operation and maintenance staff may maintain the database.
In the application, the database operation and maintenance personnel check the alarm notification information and adopt a proposed emergency disposal strategy.
In summary, the method for notifying the database operation and maintenance personnel through the alarm notification information according to the embodiment of the present invention is advantageous to timely process and maintain the query performance of the database if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds the preset query performance index rule of the database.
Referring to fig. 6, fig. 6 is a schematic structural diagram of a database query performance analysis device disclosed in an embodiment of the present application, where the database query performance analysis device is applied to a database query performance analysis system, and the database query performance analysis system includes an interaction module, an expert experience base module connected to the interaction module, a query analysis service module, and a data agent module, where the expert experience base module is connected to the query analysis service module, a computation storage module connected to the expert experience base module and the data agent module, a database module connected to the data agent module, and a message service module connected to the query analysis service module, where the expert experience base module includes an expert module and an index rule base module. The apparatus may include:
the obtaining unit 11 is configured to obtain current query performance data of a database and a preset query performance index rule of the database.
The generating unit 12 is configured to compare the current query performance data of the database with the preset query performance index rule of the database, and generate a database query performance analysis report.
And the sending unit 13 is configured to send the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker views the database query performance analysis report and performs corresponding treatment.
As an implementation manner, the preset query performance index rule of the database is generated by adopting the following manner:
and the first acquisition subunit is used for acquiring historical query performance data of the database and an initial query performance index rule of the database.
And the adjusting subunit is used for adjusting the initial query performance index rule of the database based on the prior expert experience and the historical query performance data of the database to obtain the preset query performance index rule of the database.
As an implementation, the first obtaining subunit includes:
and the second acquisition subunit is used for acquiring the initial query performance data of the database.
And the processing subunit is used for integrating and summarizing the initial query performance data of the database to obtain the initial query performance data of the database after integration and summarization as historical query performance data of the database.
As an implementable way, the apparatus further comprises:
and the generating subunit is configured to generate alarm notification information if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds a preset query performance index rule of the database.
And the sending subunit is used for sending the alarm notification information to a terminal of a database operation and maintenance worker so that the database operation and maintenance worker maintains the query performance of the database.
Referring to fig. 7, fig. 7 is a block diagram of a hardware structure of a database index monitoring device according to an embodiment of the present application, where the hardware structure of the database index monitoring device may include: at least one processor 1, at least one communication interface 2, at least one memory 3 and at least one communication bus 4.
In the embodiment of the present application, the number of the processor 1, the communication interface 2, the memory 3, and the communication bus 4 is at least one, and the processor 1, the communication interface 2, and the memory 3 complete mutual communication through the communication bus 4.
The processor 1 may be a central processing unit CPU, or an Application Specific Integrated Circuit ASIC (Application Specific Integrated Circuit), or one or more Integrated circuits or the like configured to implement embodiments of the present invention.
The memory 3 may comprise a high-speed RAM memory, and may further comprise a non-volatile memory (non-volatile memory) or the like, such as at least one disk memory.
Wherein the memory stores a program and the processor can call the program stored in the memory, the program for:
acquiring current query performance data of a database and a preset query performance index rule of the database;
comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report;
and sending the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
Alternatively, the detailed function and the extended function of the program may be as described above.
Embodiments of the present application further provide a readable storage medium, which may store a program adapted to be executed by a processor, where the program is configured to:
acquiring current query performance data of a database and a preset query performance index rule of the database;
comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report;
and sending the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
Alternatively, the detailed function and the extended function of the program may refer to the above description.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of additional like elements in a process, method, article, or apparatus that comprises the element.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
It should be noted that the above-described embodiments of the apparatus are merely schematic, where the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. In addition, in the drawings of the embodiment of the apparatus provided by the present invention, the connection relationship between the modules indicates that there is a communication connection therebetween, and may be specifically implemented as one or more communication buses or signal lines. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that the present invention may be implemented by software plus necessary general hardware, and may also be implemented by special hardware including special integrated circuits, special CPUs, special memories, special components and the like. Generally, functions performed by computer programs can be easily implemented by corresponding hardware, and specific hardware structures for implementing the same functions may be various, such as analog circuits, digital circuits, or dedicated circuits. However, the implementation of a software program is a more preferable embodiment for the present invention. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a readable storage medium, such as a floppy disk, a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk of a computer, and includes instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present invention.
In summary, the above embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same. Although the present invention has been described in detail with reference to the above embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the above embodiments may be modified, or some technical features may be equivalently replaced. And such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims (10)

1. A database query performance analysis method is characterized by comprising the following steps:
acquiring current query performance data of a database and a preset query performance index rule of the database;
comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report;
and sending the database query performance analysis report to a terminal of a database operation and maintenance worker, so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
2. The method of claim 1, wherein the preset query performance indicator rule of the database is generated as follows:
acquiring historical query performance data of the database and an initial query performance index rule of the database;
and adjusting the initial query performance index rule of the database based on the prior expert experience and the historical query performance data of the database to obtain a preset query performance index rule of the database.
3. The method of claim 2, wherein the obtaining historical query performance data for the database comprises:
acquiring initial query performance data of the database;
and performing integration and summarization on the initial query performance data of the database to obtain the initial query performance data of the database after the integration and summarization as historical query performance data of the database.
4. The method of claim 1, after comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report, further comprising:
if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds a preset query performance index rule of the database, generating alarm notification information;
and sending the alarm notification information to a terminal of a database operation and maintenance worker so that the database operation and maintenance worker maintains the query performance of the database.
5. A database query performance analysis apparatus, comprising:
the device comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring current query performance data of a database and a preset query performance index rule of the database;
the generating unit is used for comparing the current query performance data of the database with the preset query performance index rule of the database to generate a database query performance analysis report;
and the sending unit is used for sending the database query performance analysis report to a terminal of a database operation and maintenance worker so that the database operation and maintenance worker can check the database query performance analysis report and perform corresponding treatment.
6. The apparatus of claim 5, wherein the preset query performance indicator rule of the database is generated as follows:
the first acquisition subunit is used for acquiring historical query performance data of the database and an initial query performance index rule of the database;
and the adjusting subunit is used for adjusting the initial query performance index rule of the database based on the prior expert experience and the historical query performance data of the database to obtain the preset query performance index rule of the database.
7. The apparatus of claim 6, wherein the first obtaining subunit comprises:
the second acquisition subunit is used for acquiring initial query performance data of the database;
and the processing subunit is used for integrating and summarizing the initial query performance data of the database to obtain the initial query performance data of the database after the integration and summarization as historical query performance data of the database.
8. The apparatus of claim 5, further comprising:
the generating subunit is configured to generate alarm notification information if the database query performance analysis report indicates that the current query performance data of the database reaches or exceeds a preset query performance index rule of the database;
and the sending subunit is used for sending the alarm notification information to a terminal of a database operation and maintenance worker so that the database operation and maintenance worker maintains the query performance of the database.
9. A database query performance analysis device comprising a memory and a processor;
the memory is used for storing programs;
the processor is used for executing the program and realizing the steps of the intelligent matching method according to any one of claims 1 to 4.
10. A readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the intelligent matching method according to any one of claims 1 to 4.
CN202211026488.6A 2022-08-25 2022-08-25 Database query performance analysis method and device and storage medium Pending CN115373960A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211026488.6A CN115373960A (en) 2022-08-25 2022-08-25 Database query performance analysis method and device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211026488.6A CN115373960A (en) 2022-08-25 2022-08-25 Database query performance analysis method and device and storage medium

Publications (1)

Publication Number Publication Date
CN115373960A true CN115373960A (en) 2022-11-22

Family

ID=84066847

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211026488.6A Pending CN115373960A (en) 2022-08-25 2022-08-25 Database query performance analysis method and device and storage medium

Country Status (1)

Country Link
CN (1) CN115373960A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116737522A (en) * 2023-06-21 2023-09-12 山东日照发电有限公司 System performance optimization method

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116737522A (en) * 2023-06-21 2023-09-12 山东日照发电有限公司 System performance optimization method

Similar Documents

Publication Publication Date Title
CN108874640B (en) Cluster performance evaluation method and device
CN113656179A (en) Scheduling method and device of cloud computing resources, electronic equipment and storage medium
CN113987086A (en) Data processing method, data processing device, electronic device, and storage medium
CN115373960A (en) Database query performance analysis method and device and storage medium
CN112948223A (en) Method and device for monitoring operation condition
CN114398343A (en) Database abnormal key processing method, device, equipment and medium
CN112767045B (en) Lost user recovery method and device and electronic equipment
CN114022711A (en) Industrial identification data caching method and device, medium and electronic equipment
CN110677271B (en) Big data alarm method, device, equipment and storage medium based on ELK
CN112968796A (en) Network security situation awareness method and device and computer equipment
CN116627771A (en) Log acquisition method, device, electronic equipment and readable storage medium
CN108255710B (en) Script abnormity detection method and terminal thereof
CN115374088A (en) Database health degree analysis method, device and equipment and readable storage medium
CN116205624A (en) Equipment operation management method based on digital twin and related products
CN114496312A (en) Data processing method and device based on online inquiry and computer equipment
CN114186961A (en) Business approval process configuration method and device, computer equipment and storage medium
CN115373942A (en) Database index monitoring method and device and storage medium
CN113946493A (en) Monitoring threshold determination and monitoring alarm method, device, equipment and medium
US8880546B1 (en) System, method, and computer program for refining a set of keywords utilizing historical activity thresholds
CN112148712A (en) Data processing method, device, equipment and medium
CN115378842B (en) Resource monitoring method, device, storage medium and equipment
CN111143328A (en) Agile business intelligent data construction method, system, equipment and storage medium
CN115604041B (en) Security agent method, system, apparatus, computer device, and storage medium
CN114374727B (en) Data calling method and device based on artificial intelligence, electronic equipment and medium
CN115378842A (en) Resource monitoring method, device, storage medium and equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination