Supercharge Your Innovation With Domain-Expert AI Agents!

Database performance analysis method and device based on SQL

An analysis method and database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of inability to achieve statistical comparison, long analysis process, and inability to save analysis results.

Inactive Publication Date: 2017-12-15
HANGZHOU LVWAN NETWORK TECH CO LTD
View PDF7 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, because database optimization is a long-term process, long-term performance data is required for statistical comparison and analysis. However, common log analysis tools, such as mysqldumpslow, mysqlslap, etc., can only perform one-time analysis and cannot save the analysis results. It is impossible to achieve statistical comparison, and the analysis process is also very long, and the work efficiency is low

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
  • Database performance analysis method and device based on SQL
  • Database performance analysis method and device based on SQL
  • Database performance analysis method and device based on SQL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals designate the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary and are intended to explain the present invention and should not be construed as limiting the present invention.

[0035] The SQL-based database performance analysis method and device according to the embodiments of the present invention will be described below with reference to the accompanying drawings.

[0036] figure 1 It is a schematic flowchart of a SQL-based database performance analysis method provided by an embodiment of the present invention.

[0037] like figure 1 As shown, the method includes the following steps:

[0038] Step S101, extracting SQL instructions from the log of the database.

[0039] Specifically, the database i...

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 database performance analysis method and device based on SQL. The method comprises the steps that an SQL instruction is extracted from logs of a database; the extracted SQL instruction is analyzed, running information of database query based on the SQL instruction is obtained; based on the running information, statistics are conducted, and multiple performance parameters are obtained respectively. The technical problems that in the prior art, an SQL database cannot be automatically analyzed, statistical comparison cannot be conducted on data, thus the analysis process is long, the working efficiency is low and the analysis results cannot be shown are solved.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a SQL-based database performance analysis method and device. Background technique [0002] During the rapid development of the Internet wave, with the continuous growth of website visits and the increasingly complex business logic, the MySQL database usually becomes the bottleneck of the system, restricting the growth of website concurrency and the improvement of system response speed. [0003] In order to optimize and improve the performance of the database, you can find the root cause of the problem and optimize it by analyzing the slow log and general log of the database. However, because database optimization is a long-term process, long-term performance data is required for statistical comparison and analysis. However, common log analysis tools, such as mysqldumpslow, mysqlslap, etc., can only perform one-time analysis and cannot save the analysis results. Statistical ...

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): G06F17/30G06F11/34
Inventor 袁野刘又
Owner HANGZHOU LVWAN NETWORK TECH CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com