Database performance testing method and device and storage medium

A database and performance technology, applied in the direction of electrical digital data processing, error detection/correction, instruments, etc., can solve problems such as large hardware investment, hardware platform that cannot support business systems, and low efficiency

Inactive Publication Date: 2019-11-08
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, with the explosive growth of data volume, the amount of data carried by mariaDB is increasing, which makes its hardware platform unable to support its existing business system; when will it expand and what configuration will it expand to? How to quickly evaluate the performance of mariaDB? Usually we need to invest a lot of manpower to build the environment and simulate real business for testing, which is inefficient and requires a huge investment in hardware

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 testing method and device and storage medium
  • Database performance testing method and device and storage medium
  • Database performance testing method and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to make the object, technical solution and advantages of the present invention clearer, the embodiments of the present invention will be further described in detail below in conjunction with specific embodiments and with reference to the accompanying drawings.

[0038] It should be noted that all expressions using "first" and "second" in the embodiments of the present invention are to distinguish two entities with the same name but different parameters or parameters that are not the same, see "first" and "second" It is only for the convenience of expression, and should not be construed as a limitation on the embodiments of the present invention, which will not be described one by one in the subsequent embodiments.

[0039] According to one aspect of the present invention, the embodiment of the present invention proposes a method for testing database performance, such as figure 1 As shown, it may include the steps of: setting a total calculation task; obtaining ...

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 database performance testing method. The method comprises the following steps: setting a total calculation task; obtaining the number of CPUs of the database; dividing the total computing task into a plurality of sub-computing tasks with the same number as the CPUs, and respectively distributing the sub-computing tasks to one CPU for processing; and recording the time when the database finishes processing each sub-computing task, and further judging the performance of the database based on the time. The invention further discloses computer equipment and a readable storage medium. According to the technical scheme, the performance of the database can be rapidly tested, the test efficiency is improved, and the hardware investment is reduced.

Description

technical field [0001] The invention relates to the field of performance testing, in particular to a method, device and storage medium for testing database performance. Background technique [0002] At present, the data generated by the application is mainly stored in the database for analysis, processing, and processing; and the security, stability, and high efficiency of the mariaDB database have prompted more and more companies to apply it to the production environment, thereby reducing their business operations. cost. However, with the explosive growth of data volume, the amount of data carried by mariaDB is increasing, which makes its hardware platform unable to support its existing business system; when will it expand and what configuration will it expand to? How to quickly evaluate the performance of mariaDB? Usually we need to invest a lot of manpower to build the environment and simulate real business for testing, which is inefficient and requires a huge investmen...

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): G06F11/34
CPCG06F11/3409G06F11/3419
Inventor 聂维
Owner INSPUR SUZHOU INTELLIGENT TECH CO LTD
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