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

Database pressure test method and system, and computer storage medium

A database and execution plan technology, applied in the software field, can solve the problem of high cost of pressure measurement, and achieve the effect of reducing labor costs and workload

Pending Publication Date: 2022-01-21
HANGZHOU ANHENG INFORMATION TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present application provides a database stress testing method, system, and computer storage medium to at least solve the problem that in the prior art, stress testers need to redeploy the test environment and execute it repeatedly when stress testing different databases, resulting in stress testing costly technical issues

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 pressure test method and system, and computer storage medium
  • Database pressure test method and system, and computer storage medium
  • Database pressure test method and system, and computer storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0057] Such as figure 2 As shown, it is a flow chart of the database pressure testing method in the first embodiment of the present invention, and the method includes the following steps:

[0058] Step S101, obtaining the created stress test task, and generating a corresponding stress test instance according to the execution plan and stress test task information in the stress test task;

[0059] Specifically, the execution plan can be used to set a single timing and periodic execution plan by itself through setting up or configuring the execution plan template;

[0060] The execution plan template mainly defines multiple pressure test conditions, and different pressure test conditions specify the execution time and repeated execution times. Generate the underlying specific execution plan by configuring the specified execution date of the execution plan template, so as to realize the rapid configuration of the execution plan for the pressure test task;

[0061] A CronTask st...

Embodiment 2

[0081] Please combine Figure 3 to Figure 8 As shown, it is a flow chart of the database stress testing method in the second embodiment of the present invention, and the step of generating a corresponding stress testing instance according to the execution plan and the stress testing task information in the stress testing task described in step S101 is further include:

[0082] Execute the execution plan set by yourself, and execute it regularly and periodically through a single stress test condition set by yourself, and generate the stress test instance in summary.

[0083] Alternatively, execute the execution plan configured in the execution plan template in the stress testing task, and execute periodically according to multiple stress testing conditions defined in the template, specifying the execution time for different stress testing conditions, and generate the stress testing instance in summary.

[0084] For details, please refer to Figure 7 to Figure 8 , the executio...

Embodiment 3

[0119] The present invention also provides a database pressure measurement system, such as Figure 9 As shown, the system includes:

[0120] The acquiring module 10 is configured to acquire the created stress testing task, and generate a corresponding stress testing instance according to the execution plan and the stress testing task information in the stress testing task;

[0121] A task scheduling module 20, configured to regularly trigger the stress test task according to the stress test instance, and generate a specific stress test task thread;

[0122] A database adaptation module 30, configured to connect the stress testing task thread to the database to be tested, and construct an adapted test environment according to the database configuration information of the database to be tested;

[0123] The database stress testing module 40 is configured to invoke the test environment, connect to the database to be stress tested, and execute the stress testing task.

[0124] S...

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 relates to a database pressure test method and system, and a computer storage medium. The method comprises the following steps: obtaining a created pressure test task, and generating a corresponding pressure test instance according to an execution plan and pressure test task information in the pressure test task; triggering the pressure test task at regular time according to the pressure test instance, and generating specific pressure test task threads; connecting the pressure test task threads with a database to be subjected to pressure test, and constructing an adaptive test environment according to database configuration information of the database to be subjected to pressure test; calling the test environment, connecting with the database to be subjected to pressure test, and executing a pressure test task. The workload of pressure test personnel is reduced through pressure test tasks executed regularly and periodically; meanwhile, the pressure test tasks consume less time in server resources, the pressure test personnel can create a plurality of database pressure test tasks, non-professional pressure test personnel can create proper pressure test tasks only through simple training, and an accurate pressure test report can be obtained after waiting, so that the labor cost of the database pressure test is reduced.

Description

technical field [0001] The present application relates to the field of software technology, in particular to a database pressure testing method, system and computer storage medium. Background technique [0002] As the underlying structure of the system architecture, the performance and stability of the database directly determine whether the entire system can run stably and reliably. As the basic quality assurance behavior of the database, database stress testing is an important part of the entire system testing. The results of database stress testing It also affects the system design. [0003] However, in the prior art, the results of a single database stress test are often affected by multiple dimensions such as memory, CPU availability, disk space, and network bandwidth, resulting in errors in the results of a single database stress test. Among them, there is a risk of short-term fluctuations in network bandwidth. There is a large deviation between the database pressure ...

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/36
CPCG06F11/3684G06F11/3688G06F11/3664
Inventor 王旭毅范渊刘博
Owner HANGZHOU ANHENG INFORMATION TECH CO LTD