CN101093462A - Automatization method for testing schooling pressure on database application - Google Patents
Automatization method for testing schooling pressure on database application Download PDFInfo
- Publication number
- CN101093462A CN101093462A CN 200610028054 CN200610028054A CN101093462A CN 101093462 A CN101093462 A CN 101093462A CN 200610028054 CN200610028054 CN 200610028054 CN 200610028054 A CN200610028054 A CN 200610028054A CN 101093462 A CN101093462 A CN 101093462A
- Authority
- CN
- China
- Prior art keywords
- database
- record
- testing
- concurrent
- schooling
- 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.)
- Granted
Links
Images
Abstract
A method for automatically testing pressure of databank application cluster carries out integration of connection mode and connection number as well as cocurrent process then records performance data of databank in process operation in order to analyze performance difference of databank application cluster and single host under multi-cocurrent treatment pressure.
Description
Technical field
The present invention relates to the method for testing of Computer Database, relate in particular to automatization method for testing schooling pressure on database application.
Background technology
The mega project database adopts aggregated structure usually now, for analyzing the difference of cluster and single host performance under many concurrent processing of big data quantity pressure, need make up multiple factors such as connected mode, number of connection, concurrent processes, and in the performance data of moving the front and back database of record.Do not having under the situation of testing tool, all be by manual record in the past, poor efficiency extremely consuming time, and error easily.
Summary of the invention
Purpose of the present invention is exactly to provide a kind of automatization method for testing schooling pressure on database application for the defective that overcomes above-mentioned prior art existence.
Purpose of the present invention can be achieved through the following technical solutions: automatization method for testing schooling pressure on database application is characterized in that this method may further comprise the steps:
(1) client can select to connect independent example or cluster
In the database connection profile, dispose three Connection Service: each node respectively disposes a Service name that connects separately, disposes a Service name that connects cluster again;
(2) a plurality of storing processs of concurrent execution
A plurality of storing processs are carried out on the backstage in shell;
(3) automatic database of record internal performance index
Key index in the database of record interior views forms snapshot, so that compare before and after the process operation;
(4) automatically perform system monitoring command record operating system performance index
In the script that carries into execution a plan, when the concurrent process operation while, start the index of OS monitor command supervisory system CPU, internal memory, disk I, the result outputs to specified file;
(5) record test process daily record
In database, create log sheet, the operation information of record the process;
(6) testing scheme illustrates in configuration file, the soluble execution configuration file of script.
Described configuration file format is as follows: scenario name, connected mode, data volume, concurrent process number.
Described scheme is by name self-defined, and described connected mode connects for the r-cluster, and the s-single node connects, and described data volume comprises thousand or ten thousand, the storing process quantity that described concurrent process number is concurrent execution for the data scale of test.
Compared with prior art, the present invention is intended to propose an automated testing method, so that realize test purpose efficiently and accurately.
Description of drawings
Fig. 1 is a test automation method flow diagram of the present invention.
Embodiment
As shown in Figure 1, a kind of automatization method for testing schooling pressure on database application, this method comprises reads the arrangements file, generate the data of given size, determine to connect the mode of database instance, the storing process of quantity is formulated in the concurrent execution in backstage, carries out the OS monitor command and outputs to specified file, steps such as database of record performance snapshot.Specifically, this method comprises following content:
One, test is prepared:
Write the test data of storing process generation formulation scale.
The storing process that big data quantity is handled is write in the simulation practical application.
Two, measuring technology scheme function point:
A) client can select to connect independent example or cluster
In the database connection profile, dispose three Connection Service: each node respectively disposes a Service name that connects separately, disposes a Service name that connects cluster again.
B) a plurality of storing processs of concurrent execution
A plurality of storing processs are carried out on the backstage in shell.
C) automatic database of record internal performance index
Key index in the database of record interior views forms snapshot, so that compare before and after the process operation.
D) automatically perform system monitoring command record operating system performance index
In the script that carries into execution a plan, when the concurrent process operation while, start indexs such as OS monitor command supervisory system CPU, internal memory, disk I, the result outputs to specified file.
E) record test process daily record
In database, create log sheet, the operation information of record the process.
F) testing scheme illustrates in configuration file, the soluble execution configuration file of script.
Configuration file format is as follows:
Scenario name connected mode data volume concurrent process number.
Illustrate:
Scenario name: self-defined;
Connected mode: the r-cluster connects the s-single node and connects;
Data volume: the data scale of test, as thousand or ten thousand;
Concurrent process number: the storing process quantity of concurrent execution.
Do not have testing scheme of bar record description, can carry out a plurality of testing schemes.
Example:
sch04r834
sch04r838
sch04r1304
sch04r2008。
Claims (3)
1. automatization method for testing schooling pressure on database application is characterized in that, this method may further comprise the steps:
(1) client can select to connect independent example or cluster
In the database connection profile, dispose three Connection Service: each node respectively disposes a Service name that connects separately, disposes a Service name that connects cluster again;
(2) a plurality of storing processs of concurrent execution
A plurality of storing processs are carried out on the backstage in shell;
(3) automatic database of record internal performance index
Key index in the database of record interior views forms snapshot, so that compare before and after the process operation;
(4) automatically perform system monitoring command record operating system performance index
In the script that carries into execution a plan, when the concurrent process operation while, start the index of OS monitor command supervisory system CPU, internal memory, disk I, the result outputs to specified file;
(5) record test process daily record
In database, create log sheet, the operation information of record the process;
(6) testing scheme illustrates in configuration file, the soluble execution configuration file of script.
2. automatization method for testing schooling pressure on database application according to claim 1 is characterized in that, described configuration file format is as follows: scenario name, connected mode, data volume, concurrent process number.
3. automatization method for testing schooling pressure on database application according to claim 2, it is characterized in that, described scheme is by name self-defined, described connected mode connects for the r-cluster, the s-single node connects, described data volume comprises thousand or ten thousand, the storing process quantity that described concurrent process number is concurrent execution for the data scale of test.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2006100280544A CN101093462B (en) | 2006-06-22 | 2006-06-22 | Automatization method for testing schooling pressure on database application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2006100280544A CN101093462B (en) | 2006-06-22 | 2006-06-22 | Automatization method for testing schooling pressure on database application |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101093462A true CN101093462A (en) | 2007-12-26 |
| CN101093462B CN101093462B (en) | 2011-02-09 |
Family
ID=38991735
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2006100280544A Active CN101093462B (en) | 2006-06-22 | 2006-06-22 | Automatization method for testing schooling pressure on database application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101093462B (en) |
Cited By (21)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102035697A (en) * | 2010-12-31 | 2011-04-27 | 中国电子科技集团公司第十五研究所 | Concurrent connections performance testing system and method for file system |
| CN102609472A (en) * | 2012-01-18 | 2012-07-25 | 深圳市同洲视讯传媒有限公司 | Method and system for implementing performance test of distributed database system |
| CN103064760A (en) * | 2012-12-19 | 2013-04-24 | 华为技术有限公司 | Backup method and backup device |
| CN103297286A (en) * | 2012-02-23 | 2013-09-11 | 百度在线网络技术（北京）有限公司 | Distributed cluster reliability test system, method and device |
| CN101789002B (en) * | 2010-01-22 | 2013-09-11 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test device and method for server |
| CN103631703A (en) * | 2012-08-21 | 2014-03-12 | 腾讯科技（深圳）有限公司 | Software performance testing method and device in Android device |
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN104679651A (en) * | 2015-02-09 | 2015-06-03 | 百度在线网络技术（北京）有限公司 | Automatic testing method and executing node |
| CN104866425A (en) * | 2015-05-22 | 2015-08-26 | 国云科技股份有限公司 | Database pressure testing method |
| CN105302729A (en) * | 2015-12-09 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Storage system testing method based on database application |
| WO2017016422A1 (en) * | 2015-07-29 | 2017-02-02 | 阿里巴巴集团控股有限公司 | Cloud-based database detection method and device |
| CN106470133A (en) * | 2015-08-20 | 2017-03-01 | 阿里巴巴集团控股有限公司 | System pressure method of testing and device |
| CN107885654A (en) * | 2017-05-05 | 2018-04-06 | 平安科技（深圳）有限公司 | Data library test method and system |
| CN108228437A (en) * | 2017-12-29 | 2018-06-29 | 广东欧珀移动通信有限公司 | Promote method, apparatus, electronic device and the storage medium of test and appraisal accuracy |
| CN108255661A (en) * | 2016-12-29 | 2018-07-06 | 北京京东尚科信息技术有限公司 | A kind of method and system for realizing Hadoop cluster monitorings |
| CN108985459A (en) * | 2018-05-30 | 2018-12-11 | 华为技术有限公司 | The method and apparatus of training pattern |
| CN109828871A (en) * | 2018-12-25 | 2019-05-31 | 北京奇安信科技有限公司 | Equipment automatization test macro |
| CN110633183A (en) * | 2019-08-01 | 2019-12-31 | 平安科技（深圳）有限公司 | Method and related device for monitoring execution progress of software product |
| CN111294252A (en) * | 2019-07-29 | 2020-06-16 | 展讯半导体(成都)有限公司 | Cluster test system |
| CN111444068A (en) * | 2020-03-03 | 2020-07-24 | Oppo广东移动通信有限公司 | System performance testing method and device, computer equipment and storage medium |
| CN113204485A (en) * | 2021-05-08 | 2021-08-03 | 山东英信计算机技术有限公司 | Memory database pressure testing method, system, terminal and storage medium |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5664173A (en) * | 1995-11-27 | 1997-09-02 | Microsoft Corporation | Method and apparatus for generating database queries from a meta-query pattern |
| CN100349133C (en) * | 2005-03-18 | 2007-11-14 | 中国工商银行股份有限公司 | Bank host operation pressure test system |
| CN100346308C (en) * | 2005-11-24 | 2007-10-31 | 华为技术有限公司 | Automatic test method based on database operation |
-
2006
- 2006-06-22 CN CN2006100280544A patent/CN101093462B/en active Active
Cited By (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789002B (en) * | 2010-01-22 | 2013-09-11 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test device and method for server |
| CN102035697B (en) * | 2010-12-31 | 2012-04-18 | 中国电子科技集团公司第十五研究所 | Concurrent connections performance testing system and method for file system |
| CN102035697A (en) * | 2010-12-31 | 2011-04-27 | 中国电子科技集团公司第十五研究所 | Concurrent connections performance testing system and method for file system |
| CN102609472A (en) * | 2012-01-18 | 2012-07-25 | 深圳市同洲视讯传媒有限公司 | Method and system for implementing performance test of distributed database system |
| CN103297286B (en) * | 2012-02-23 | 2016-12-14 | 百度在线网络技术（北京）有限公司 | The test system of the reliability of distributed type assemblies, method and apparatus |
| CN103297286A (en) * | 2012-02-23 | 2013-09-11 | 百度在线网络技术（北京）有限公司 | Distributed cluster reliability test system, method and device |
| CN103631703A (en) * | 2012-08-21 | 2014-03-12 | 腾讯科技（深圳）有限公司 | Software performance testing method and device in Android device |
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN103064760A (en) * | 2012-12-19 | 2013-04-24 | 华为技术有限公司 | Backup method and backup device |
| CN103064760B (en) * | 2012-12-19 | 2015-08-05 | 华为技术有限公司 | Backup method and backup device |
| CN104679651B (en) * | 2015-02-09 | 2018-08-10 | 百度在线网络技术（北京）有限公司 | A kind of automated testing method and execute node |
| CN104679651A (en) * | 2015-02-09 | 2015-06-03 | 百度在线网络技术（北京）有限公司 | Automatic testing method and executing node |
| CN104866425A (en) * | 2015-05-22 | 2015-08-26 | 国云科技股份有限公司 | Database pressure testing method |
| WO2017016422A1 (en) * | 2015-07-29 | 2017-02-02 | 阿里巴巴集团控股有限公司 | Cloud-based database detection method and device |
| CN106470133A (en) * | 2015-08-20 | 2017-03-01 | 阿里巴巴集团控股有限公司 | System pressure method of testing and device |
| CN106470133B (en) * | 2015-08-20 | 2019-12-03 | 菜鸟智能物流控股有限公司 | System pressure testing method and device |
| CN105302729A (en) * | 2015-12-09 | 2016-02-03 | 浪潮电子信息产业股份有限公司 | Storage system testing method based on database application |
| CN108255661A (en) * | 2016-12-29 | 2018-07-06 | 北京京东尚科信息技术有限公司 | A kind of method and system for realizing Hadoop cluster monitorings |
| CN107885654A (en) * | 2017-05-05 | 2018-04-06 | 平安科技（深圳）有限公司 | Data library test method and system |
| CN108228437A (en) * | 2017-12-29 | 2018-06-29 | 广东欧珀移动通信有限公司 | Promote method, apparatus, electronic device and the storage medium of test and appraisal accuracy |
| CN108228437B (en) * | 2017-12-29 | 2021-08-31 | Oppo广东移动通信有限公司 | Method and device for improving evaluation accuracy, electronic device and storage medium |
| CN108985459A (en) * | 2018-05-30 | 2018-12-11 | 华为技术有限公司 | The method and apparatus of training pattern |
| CN109828871A (en) * | 2018-12-25 | 2019-05-31 | 北京奇安信科技有限公司 | Equipment automatization test macro |
| CN111294252A (en) * | 2019-07-29 | 2020-06-16 | 展讯半导体(成都)有限公司 | Cluster test system |
| CN110633183A (en) * | 2019-08-01 | 2019-12-31 | 平安科技（深圳）有限公司 | Method and related device for monitoring execution progress of software product |
| CN110633183B (en) * | 2019-08-01 | 2022-06-24 | 平安科技（深圳）有限公司 | Method and related device for monitoring execution progress of software product |
| CN111444068A (en) * | 2020-03-03 | 2020-07-24 | Oppo广东移动通信有限公司 | System performance testing method and device, computer equipment and storage medium |
| CN111444068B (en) * | 2020-03-03 | 2023-09-19 | Oppo广东移动通信有限公司 | System performance test method, device, computer equipment and storage medium |
| CN113204485A (en) * | 2021-05-08 | 2021-08-03 | 山东英信计算机技术有限公司 | Memory database pressure testing method, system, terminal and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101093462B (en) | 2011-02-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101093462B (en) | Automatization method for testing schooling pressure on database application | |
| US10929260B2 (en) | Traffic capture and debugging tools for identifying root causes of device failure during automated testing | |
| US10955461B2 (en) | Smart and efficient protocol logic analyzer configured within automated test equipment (ATE) hardware | |
| CN103578568B (en) | The performance test methods of solid state hard disc and device | |
| CN102831052B (en) | Test exemple automation generating apparatus and method | |
| US9569325B2 (en) | Method and system for automated test and result comparison | |
| CN105223889A (en) | A kind of method being applicable to the automatic monitoring PMC RAID card daily record of producing line | |
| CN110718264A (en) | Method and device for testing information of solid state disk, computer equipment and storage medium | |
| CN108363678B (en) | Rapid automatic processing system for fuel cell stack test data | |
| CN108984332A (en) | A kind of device and method of location-server delay machine failure | |
| CN104317684A (en) | Method for synchronously automatic testing of bandwidth and transmission rate of multiple USB (Universal Serial Bus) interfaces | |
| CN106681878A (en) | Method for testing PCIE channel bandwidth | |
| CN112231163A (en) | Multifunctional computer detection equipment and operation method thereof | |
| CN112187589A (en) | System testing method based on flow playback | |
| CN109918221B (en) | Hard disk error reporting analysis method, system, terminal and storage medium | |
| CN114325405A (en) | Battery pack consistency analysis method, modeling method, device, equipment and medium | |
| CN111352783A (en) | Method and system for automatically controlling hard disk identification and test | |
| CN100576182C (en) | The real-time monitoring system of computer documents and method | |
| US7415560B2 (en) | Method of automatically monitoring computer system debugging routine | |
| CN112486748B (en) | Test system and test method thereof | |
| CN111835590A (en) | Automatic interface test architecture and test method for cloud host product | |
| CN113111009A (en) | Software testing device and testing method | |
| CN105242880A (en) | Method for automatically creating Raid and executing pressure testing | |
| CN114281659B (en) | Method and system for reproducing server BUG based on firmware version | |
| CN114356061B (en) | Power failure detection method, device, system and detection equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |