CN104866425A - Database pressure testing method - Google Patents
Database pressure testing method Download PDFInfo
- Publication number
- CN104866425A CN104866425A CN201510266856.8A CN201510266856A CN104866425A CN 104866425 A CN104866425 A CN 104866425A CN 201510266856 A CN201510266856 A CN 201510266856A CN 104866425 A CN104866425 A CN 104866425A
- Authority
- CN
- China
- Prior art keywords
- database
- test
- jdbc
- jmeter
- result
- 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
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The present invention relates to the technical field of database testing, and in particular relates to a database pressure testing method. According to the present invention, a test plan is newly created and a database JDBC configuration is provided, by using a JMeter tool; then a request is sent via the JDBC for testing; and finally a test result is collected via a graphic result. The method according to the present invention can well reflect whether a database object needs to be optimized, and can be widely applied for database performance testing for a software product.
Description
Technical field
The present invention relates to database technical field of measurement and test, the method for particularly a kind of database pressure test.
Background technology
Talk about test, what first appear in one's mind in people's brain is exactly test for software correctness, namely what is often called functional test.But software is only function is correctly inadequate.In actual development, other NOT-function factor is also had also to play a crucial factor, the response speed of such as software.Affect a lot of because have of software responses speed, some is because algorithm is efficient not; Also some may by the impact of user's number of concurrent.Current database server is indispensable in most enterprises project, and carrying out pressure test for database is to find out: whether database object can bear the access from multiple user effectively.These objects are mainly: index, trigger, storing process and lock.By the test for SQL statement and storing process, JMeter can well reflect that database object is the need of optimization.
Summary of the invention
The technical matters that the present invention solves is a kind of method providing database pressure test, efficiently solves the performance of database and the problem of stability.
The technical scheme that the present invention solves the problems of the technologies described above is:
Use JMeter instrument, newly-built test plan and configuration database JDBC connects configuration; Then sent request by JDBC and test; Test result is collected finally by graphic result; To reflect that database object is the need of optimization.
Described method mainly comprises the steps:
1st step, installation JMeter instrument, configure JAVA environment and start JMeter;
2nd step, an establishment test plan, import used database-driven bag;
3rd step, an interpolation sets of threads, and Virtual User number, start-up time and cycle index are set;
4th step, an establishment thread, and below thread, create a JDBC and connect configuration, relevant information is set;
5th step, create JDBC request, database is done and increases, delete, change or look into test operation;
6th step, interpolation audiomonitor, can select to add " graphic result " and " checking bearing-age tree ";
7th step, startup optimization test plan, finally check testing results result.
Beneficial effect of the present invention: by using JMeter instrument, newly-built test plan and configuration database JDBC connect configuration, then sent request by JDBC and test, collect test result finally by graphic result, can well reflect that database object is the need of optimization; Efficiently solve the performance of database and the problem of stability.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the present invention is further described:
Fig. 1 is business process map of the present invention.
Embodiment
As shown in Figure 1, the method for a kind of database pressure test of the present invention, specifically comprises following step:
1st step, installation JMeter instrument, configure JAVA environment and start JMeter;
(1) first need java environment is installed, use the first step to be that JDK official website is downloaded.
(2) configure java environment ,-> environmental variance is set with mouse right click " computing machine "-> attribute-> AS.
(3) newly-built-> variable name of system variable->: JAVA_HOME
Variate-value: D: Program Files Java jdk1.7.0_05;
In system variable, find variable to be called: Path, then select-> editor, directly add after variate-value:; %JAVA_HOME% bin (remark sign, before have value, separating with branch below);
Newly-built-the > of system variable-> (this wants newly-built) variable name: classpath variable value:
%JAVA_HOME% lib; %JAVA_HOME% lib dt.jar; %JAVA_HOM E% lib tools.jar (remark sign)
(4) under last test, whether environmental variance is arranged successfully, keys in cmd carriage return input javac if there is following information: your Java environmental variance configuration successful in the search box in the lower left corner!
If occur ' javac ' is not inner or external command, the program that neither run
Or autoexec, reason is likely "; " number (setting in path path, branch will be noted! ! ! )
(5) JMeter latest edition is downloaded to official website
Under being put into a catalogue, directly D: apache-jmeter-2.12 run jmeter.bat exactly under bin.
2nd step, an establishment test plan, the database-driven bag we used imports;
3rd step, add a sets of threads, and our Virtual User number, start-up time and cycle index are set;
4th step, an establishment thread, and below thread, create a JDBC ConnectionConfiguration, relevant information is set;
5th step, we need to do test operation (additions and deletions change look into) to database to create JDBC Request.;
6th step, interpolation audiomonitor, select here to add " graphic result " and " checking bearing-age tree ";
7th step, startup optimization test plan, finally check testing results result.
Claims (2)
1. a method for database pressure test, is characterized in that: use JMeter instrument, newly-built test plan and configuration database JDBC connects configuration; Then sent request by JDBC and test; Test result is collected finally by graphic result; To reflect that database object is the need of optimization.
2. the method for database performance measurement according to claim 1, is characterized in that: described method mainly comprises the steps:
1st step, installation JMeter instrument, configure JAVA environment and start JMeter;
2nd step, an establishment test plan, import used database-driven bag;
3rd step, an interpolation sets of threads, and Virtual User number, start-up time and cycle index are set;
4th step, an establishment thread, and below thread, create a JDBC and connect configuration, relevant information is set;
5th step, create JDBC request, database is done and increases, delete, change or look into test operation;
6th step, interpolation audiomonitor, can select to add " graphic result " and " checking bearing-age tree ";
7th step, startup optimization test plan, finally check testing results result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510266856.8A CN104866425A (en) | 2015-05-22 | 2015-05-22 | Database pressure testing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510266856.8A CN104866425A (en) | 2015-05-22 | 2015-05-22 | Database pressure testing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104866425A true CN104866425A (en) | 2015-08-26 |
Family
ID=53912271
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510266856.8A Pending CN104866425A (en) | 2015-05-22 | 2015-05-22 | Database pressure testing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104866425A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105426301A (en) * | 2015-10-27 | 2016-03-23 | 浪潮电子信息产业股份有限公司 | Linux platform based Oracle database pressure test method |
| CN107659468A (en) * | 2017-10-10 | 2018-02-02 | 深圳市吉祥腾达科技有限公司 | A kind of method of testing of Router Security reliability |
| CN107704568A (en) * | 2017-09-29 | 2018-02-16 | 马上消费金融股份有限公司 | A kind of method and device of test data addition |
| CN109376139A (en) * | 2018-08-15 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Centralized database monitoring method, computer installation and storage medium |
| CN111078527A (en) * | 2019-11-08 | 2020-04-28 | 北京深思数盾科技股份有限公司 | Auxiliary system and method for pressure testing of server |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093462A (en) * | 2006-06-22 | 2007-12-26 | 上海全成通信技术有限公司 | Automatization method for testing schooling pressure on database application |
| US20130159353A1 (en) * | 2011-12-20 | 2013-06-20 | International Business Machines Corporation | Generating a test workload for a database |
| CN103916283A (en) * | 2012-12-31 | 2014-07-09 | 北京新媒传信科技有限公司 | Server pressure test system and method |
-
2015
- 2015-05-22 CN CN201510266856.8A patent/CN104866425A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093462A (en) * | 2006-06-22 | 2007-12-26 | 上海全成通信技术有限公司 | Automatization method for testing schooling pressure on database application |
| US20130159353A1 (en) * | 2011-12-20 | 2013-06-20 | International Business Machines Corporation | Generating a test workload for a database |
| CN103916283A (en) * | 2012-12-31 | 2014-07-09 | 北京新媒传信科技有限公司 | Server pressure test system and method |
Non-Patent Citations (1)
| Title |
|---|
| 16WYFHXWQ: "Jmeter性能测试中文手册", 《百度学术》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105426301A (en) * | 2015-10-27 | 2016-03-23 | 浪潮电子信息产业股份有限公司 | Linux platform based Oracle database pressure test method |
| CN107704568A (en) * | 2017-09-29 | 2018-02-16 | 马上消费金融股份有限公司 | A kind of method and device of test data addition |
| CN107704568B (en) * | 2017-09-29 | 2019-03-26 | 马上消费金融股份有限公司 | A kind of method and device of test data addition |
| CN107659468A (en) * | 2017-10-10 | 2018-02-02 | 深圳市吉祥腾达科技有限公司 | A kind of method of testing of Router Security reliability |
| CN109376139A (en) * | 2018-08-15 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Centralized database monitoring method, computer installation and storage medium |
| CN111078527A (en) * | 2019-11-08 | 2020-04-28 | 北京深思数盾科技股份有限公司 | Auxiliary system and method for pressure testing of server |
| CN111078527B (en) * | 2019-11-08 | 2021-01-26 | 北京深思数盾科技股份有限公司 | Auxiliary system and method for pressure testing of server |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105550241B (en) | Multi-dimensional database querying method and device | |
| CN102135938B (en) | Software product testing method and system | |
| CN104866425A (en) | Database pressure testing method | |
| CN110515896B (en) | Model resource management method, model file manufacturing method, device and system | |
| CN202339542U (en) | Software product test system | |
| CN103778133A (en) | Database object changing method and device | |
| CN103873318A (en) | Website automated testing method and automated testing system | |
| LU503512B1 (en) | Operating method for construction of knowledge graph based on naming rule and caching mechanism | |
| CN103905231A (en) | Method and device for unified management of device types | |
| CN110955714A (en) | Method and device for converting unstructured text into structured text | |
| EP2933731A1 (en) | Method for configuring browser bookmarks, device and terminal thereof | |
| CN116302930A (en) | Application testing method and device | |
| CN101425070B (en) | Deadlock positioning method, deadlock positioning device and data system | |
| CN115033894A (en) | Software component supply chain safety detection method and device based on knowledge graph | |
| CN105930354B (en) | Storage model conversion method and device | |
| CN113962597A (en) | Data analysis method and device, electronic equipment and storage medium | |
| US20130318499A1 (en) | Test script generation | |
| CN104572638B (en) | Data read-write method and device | |
| CN104915435A (en) | Data query method and device | |
| CN105302547A (en) | Fault injection method for Verilog HDL design | |
| CN111639016A (en) | Big data log analysis method and device and computer storage medium | |
| CN115757174A (en) | Database difference detection method and device | |
| CN110472125B (en) | Multistage page cascading crawling method and equipment based on web crawler | |
| CN111209322A (en) | Financial information acquisition and processing system and method | |
| CN115292194B (en) | Method for debugging flow, electronic equipment and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150826 |
|
| WD01 | Invention patent application deemed withdrawn after publication |