CN111090572A - System and method for performing performance test on MySQL database - Google Patents
System and method for performing performance test on MySQL database Download PDFInfo
- Publication number
- CN111090572A CN111090572A CN201911310490.4A CN201911310490A CN111090572A CN 111090572 A CN111090572 A CN 111090572A CN 201911310490 A CN201911310490 A CN 201911310490A CN 111090572 A CN111090572 A CN 111090572A
- Authority
- CN
- China
- Prior art keywords
- module
- mysql database
- data
- test
- tested
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3438—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment monitoring of user actions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3466—Performance evaluation by tracing or monitoring
- G06F11/3476—Data logging
Abstract
The invention discloses a system for performing performance test on a MySQL database, which comprises a configuration file module, a scheduling module, a monitoring module, an execution module and a data analysis module, wherein the configuration file module is connected with the scheduling module, the scheduling module is connected with the monitoring module, the execution module and the data analysis module, the monitoring module, the execution module and the data analysis module are connected with an example of the MySQL database to be tested, the scheduling module reads the information of the configuration file module, traverses the information of the example of each MySQL database to be tested and the data of each performance parameter, calls the execution module to execute the test, and calls the data analysis module to perform result analysis. The system can support the MySQL database examples with different specifications to perform performance test together, and returns the resource monitoring result after the test is finished, so that the data result can be collected, compared and analyzed conveniently. The invention also provides a method for testing the performance of the MySQL database.
Description
Technical Field
The invention relates to a system and a method for performing performance test on a MySQL database, belonging to the technical field of Internet application tools.
Background
The MySQL database is an open source relational database management system that uses a structured query language for database management. On the premise that it is open source, anyone can download it under the permission of General Public License and modify it according to personalized needs. Therefore, the specifications of a CPU and a memory for operating the MySQL database are not limited, the variety is wide, and different specifications need to traverse different performance test parameters. There is also a large difference in performance values obtained with different specifications and performance parameters.
Meanwhile, in each performance test, besides paying attention to the performance test result obtained after the performance test tool is executed, the system resource of the tested system needs to be monitored, and the performance test result and the system resource monitoring data are combined together to analyze the performance bottleneck of the database. Because of the multiple specifications, the parameters to be traversed by each specification are multiple, the manual execution time is long, the finally obtained data is often complicated, and the analysis and comparison of the data are also very time-consuming.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention provides a system for performing performance test on a MySQL database, which can support multiple MySQL database examples with different specifications to perform performance test together, and returns a resource monitoring result after the test is finished, so that the data result can be collected, compared and analyzed conveniently.
In order to achieve the purpose, the system for performing performance test on the MySQL database comprises a configuration file module, a scheduling module, a monitoring module, an execution module and a data analysis module, wherein the configuration file module is connected with the scheduling module, the scheduling module is connected with the monitoring module, the execution module and the data analysis module, the monitoring module, the execution module and the data analysis module are connected with the MySQL database examples to be tested, the scheduling module reads the information of the configuration file module, traverses the information of each MySQL database example to be tested and each performance parameter data, calls the execution module to execute the test, and calls the data analysis module to perform result analysis.
Further, the data in the configuration file comprises a Host IP (Internet protocol) of the MySQL database example to be tested, a user name and a password of the MySQL database, parameters of a performance test tool, a log file in the execution process and a result data storage path.
Further, the data analysis module comprises a test tool, and analyzes the performance test result and the resource monitoring data to generate a test execution result file.
Further, the monitoring module is connected with and issues a resource monitoring tool to the MySQL database example to be monitored through the remote SSH, and simultaneously monitors and returns resource monitoring data.
Further, the execution module executes the MySQL performance test and stores the test result.
The invention also provides a test method of the system for performing the performance test on the MySQL database, which comprises the following steps:
s1: the tester modifies the configuration file in the configuration file module and calls the test tool;
s2: the scheduling module reads the information of all MySQL databases to be tested and all performance parameter data from the configuration file module, and the storage paths of the logs and the result files;
s3: the scheduling module sequentially traverses the information and the performance parameter data of the MySQL database example to be tested, transmits the data of the Host IP, the user name, the password and the like of the MySQL database example to be tested to the monitoring module, and calls the monitoring module to monitor the resource of the MySQL database example to be tested;
s4: the monitoring module issues a resource monitoring tool to the MySQL database example to be monitored in an SSH remote login mode, and starts to monitor the resource;
s5: the scheduling module transmits data such as Host IP, MySQL user name and password, performance test parameters and the like of the MySQL database example to be tested to the execution module, and calls the execution module to start performance test;
s6: the execution module prepares test data and executes performance test on the MySQL database example to be tested, and generates a performance test result and a resource monitoring result after the test is finished;
s7: and after all the MySQL database examples to be tested and all the performance parameter data are executed in a traversing way, the scheduling module calls the data analysis module to process all the test data to obtain a final test result.
The system for performing the performance test on the MySQL database can support various MySQL database examples with different specifications to perform the performance test together, and returns the resource monitoring result after the test is finished, so that the data result can be summarized, compared and analyzed conveniently.
Drawings
The present invention will be further described and illustrated with reference to the following drawings.
Fig. 1 is a block diagram of a system for performing performance testing on MySQL database according to a preferred embodiment of the present invention.
Detailed Description
The technical solution of the present invention will be more clearly and completely explained by the description of the preferred embodiments of the present invention with reference to the accompanying drawings.
As shown in fig. 1, a system for performing a performance test on a MySQL database according to a preferred embodiment of the present invention includes a configuration file module, a scheduling module, a monitoring module, an execution module, and a data analysis module.
The system comprises a configuration file module, a scheduling module, a monitoring module, an execution module and a data analysis module, wherein the configuration file module is connected with the scheduling module, the scheduling module is connected with the monitoring module, the execution module and the data analysis module, the monitoring module, the execution module and the data analysis module are connected with the MySQL database examples to be tested, the scheduling module reads the configuration file module information, traverses each MySQL database example information to be tested and each performance parameter data, calls the execution module to execute the test, and calls the data analysis module to analyze the result.
Specifically, the data in the configuration file includes a Host IP of the MySQL database example to be tested, a user name, a password, a user name and a password of the MySQL database, parameters of the performance testing tool, a log file in the execution process, and a result data storage path.
The data analysis module comprises a test tool, and analyzes the performance test result and the resource monitoring data to generate a test execution result file.
The monitoring module is connected with and issues a resource monitoring tool to the MySQL database example to be monitored through the remote SSH, and simultaneously monitors and returns resource monitoring data.
And the execution module executes the MySQL performance test and stores the test result.
The invention also provides a test method of the system for performing the performance test on the MySQL database, which comprises the following steps:
s1: the tester modifies the configuration file in the configuration file module and calls the test tool;
s2: the scheduling module reads the information of all MySQL databases to be tested and all performance parameter data from the configuration file module, and the storage paths of the logs and the result files;
s3: the scheduling module sequentially traverses the information and the performance parameter data of the MySQL database example to be tested, transmits the data of the Host IP, the user name, the password and the like of the MySQL database example to be tested to the monitoring module, and calls the monitoring module to monitor the resource of the MySQL database example to be tested;
s4: the monitoring module issues a resource monitoring tool to the MySQL database example to be monitored in an SSH remote login mode, and starts to monitor the resource;
s5: the scheduling module transmits data such as Host IP, MySQL user name and password, performance test parameters and the like of the MySQL database example to be tested to the execution module, and calls the execution module to start performance test;
s6: the execution module prepares test data and executes performance test on the MySQL database example to be tested, and generates a performance test result and a resource monitoring result after the test is finished;
s7: and after all the MySQL database examples to be tested and all the performance parameter data are executed in a traversing way, the scheduling module calls the data analysis module to process all the test data to obtain a final test result.
The system for performing the performance test on the MySQL database supports performance test on a plurality of MySQL examples with different specifications, supports the example with each specification to traverse a plurality of different performance parameters for performing the performance test, automatically issues the resource monitoring tool to the tested example before the test, returns the resource monitoring result after the test is finished, and analyzes the performance test result and the resource monitoring result after the test is finished to obtain the summary result data of each performance parameter of each specification, thereby facilitating the comparative analysis.
The above detailed description merely describes preferred embodiments of the present invention and does not limit the scope of the invention. Without departing from the spirit and scope of the present invention, it should be understood that various changes, substitutions and alterations can be made herein by those skilled in the art without departing from the spirit and scope of the invention as defined by the appended claims and their equivalents. The scope of the invention is defined by the claims.
Claims (6)
1. A system for performing performance test on a MySQL database is characterized by comprising a configuration file module, a scheduling module, a monitoring module, an executing module and a data analysis module, wherein the configuration file module is connected with the scheduling module, the scheduling module is connected with the monitoring module, the executing module and the data analysis module, the monitoring module, the executing module and the data analysis module are connected with an example of the MySQL database to be tested, the scheduling module reads information of the configuration file module, traverses information of the example of each MySQL database to be tested and data of each performance parameter, calls the executing module to execute test, and calls the data analysis module to perform result analysis.
2. The system according to claim 1, wherein the data in the configuration file includes a Host IP, a user name, a password of the MySQL database instance to be tested, a user name and a password of the MySQL database, parameters of a performance testing tool, a log file during execution, and a result data storage path.
3. The system according to claim 1, wherein the data analysis module comprises a test tool for analyzing the performance test result and the resource monitoring data to generate a test execution result file.
4. The system according to claim 1, wherein the monitoring module connects and issues a resource monitoring tool to the MySQL database instance to be tested via the remote SSH, and monitors and returns resource monitoring data.
5. The system for performing performance testing on a MySQL database according to claim 1, wherein the execution module performs MySQL performance testing and saves the test results.
6. A method of testing the performance of a MySQL database according to any of claims 1-5, comprising the steps of:
s1: the tester modifies the configuration file in the configuration file module and calls the test tool;
s2: the scheduling module reads the information of all MySQL databases to be tested and all performance parameter data from the configuration file module, and the storage paths of the logs and the result files;
s3: the scheduling module sequentially traverses the information and the performance parameter data of the MySQL database example to be tested, transmits the data of the Host IP, the user name, the password and the like of the MySQL database example to be tested to the monitoring module, and calls the monitoring module to monitor the resource of the MySQL database example to be tested;
s4: the monitoring module issues a resource monitoring tool to the MySQL database example to be monitored in an SSH remote login mode, and starts to monitor the resource;
s5: the scheduling module transmits data such as HostIP, MySQL user name and password, performance test parameters and the like of the MySQL database example to be tested to the execution module, and calls the execution module to start performance test;
s6: the execution module prepares test data and executes performance test on the MySQL database example to be tested, and generates a performance test result and a resource monitoring result after the test is finished;
s7: and after all the MySQL database examples to be tested and all the performance parameter data are executed in a traversing way, the scheduling module calls the data analysis module to process all the test data to obtain a final test result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911310490.4A CN111090572A (en) | 2019-12-18 | 2019-12-18 | System and method for performing performance test on MySQL database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911310490.4A CN111090572A (en) | 2019-12-18 | 2019-12-18 | System and method for performing performance test on MySQL database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111090572A true CN111090572A (en) | 2020-05-01 |
Family
ID=70395727
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911310490.4A Pending CN111090572A (en) | 2019-12-18 | 2019-12-18 | System and method for performing performance test on MySQL database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111090572A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783785A (en) * | 2021-02-01 | 2021-05-11 | 紫光云技术有限公司 | General test method for Nosql database performance |
| CN112835778A (en) * | 2021-02-25 | 2021-05-25 | 紫光云技术有限公司 | Universal test method for RDS database performance, electronic equipment and server |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN108255712A (en) * | 2017-12-29 | 2018-07-06 | 曙光信息产业(北京)有限公司 | The test system and test method of data system |
| CN109753438A (en) * | 2019-01-14 | 2019-05-14 | 上海挚极信息科技有限公司 | Testing Platform and method based on jmeter |
-
2019
- 2019-12-18 CN CN201911310490.4A patent/CN111090572A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103729361A (en) * | 2012-10-12 | 2014-04-16 | 百度在线网络技术（北京）有限公司 | Method and device for testing performance of database |
| CN108255712A (en) * | 2017-12-29 | 2018-07-06 | 曙光信息产业(北京)有限公司 | The test system and test method of data system |
| CN109753438A (en) * | 2019-01-14 | 2019-05-14 | 上海挚极信息科技有限公司 | Testing Platform and method based on jmeter |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783785A (en) * | 2021-02-01 | 2021-05-11 | 紫光云技术有限公司 | General test method for Nosql database performance |
| CN112835778A (en) * | 2021-02-25 | 2021-05-25 | 紫光云技术有限公司 | Universal test method for RDS database performance, electronic equipment and server |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20180253373A1 (en) | Systems and methods for automated web performance testing for cloud apps in use-case scenarios | |
| CN107302450B (en) | Data acquisition task changing method and device | |
| US7970755B2 (en) | Test execution of user SQL in database server code | |
| CN102684927B (en) | A kind of method and apparatus of patrolling and examining the network equipment | |
| WO2018184420A1 (en) | Software testing method, apparatus, electronic device, and medium | |
| EP3975482B1 (en) | Quantitative network testing framework for 5g and subsequent generation networks | |
| CN105022691A (en) | Highly automatic software testing method based on UML diagram | |
| CN112965871A (en) | Vehicle fault prompt information acquisition method and device and storage medium | |
| US9164759B2 (en) | Test management domain asset discovery and analysis | |
| CN111090572A (en) | System and method for performing performance test on MySQL database | |
| CN110209700B (en) | Data stream association method and device, electronic equipment and storage medium | |
| WO2023123943A1 (en) | Interface automation testing method and apparatus, and medium, device and program | |
| CN112579399B (en) | Cloud service testing method and device, electronic equipment and computer storage medium | |
| CN106855844B (en) | Performance test method and system | |
| CN110377519B (en) | Performance capacity test method, device and equipment of big data system and storage medium | |
| CN106407432B (en) | Query method and device for Oracle data warehouse | |
| KR101830936B1 (en) | Performance Improving System Based Web for Database and Application | |
| WO2017167015A1 (en) | Method and device for server device security management and computer storage medium | |
| CN116431522A (en) | Automatic test method and system for low-code object storage gateway | |
| CN113238901B (en) | Multi-device automatic testing method and device, storage medium and computer device | |
| CN116346395A (en) | Industrial control network asset identification method, system, equipment and storage medium | |
| CN112671565B (en) | 5G core network topology discovery method and device based on signaling link | |
| CN106855843B (en) | Performance analysis method and device of Web system | |
| CN111158653B (en) | SQL language-based integrated development and execution system for real-time computing program | |
| CN115878448A (en) | Database test method, distributed database and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200501 |