Background
Because the blogger is responsible for testing the project requires a large database throughput, recently upgraded, updated a database middleware-mycat. Query some information, understand that this is Ali's an open source project, based on MySQL, is for the disk read and write, the theoretical reading and writing speed will be slightly less than MySQL.
After communicating with the team leader, after the function test is completed, the performance of the upgraded Mycat is measured.
Environment preparation
1. Download JMeter
can access the following address for download, it is recommended to download the zip version, because the zip is a green version, no installation, after decompression can be used,
Jmeter
2. Download the MySQL database driver package
can be downloaded in my csdn shared files, also can be downloaded on the MySQL website
CSDN
MySQL official website
3. The database to be tested
JMeter Configuration
1. Start JMeter Graphical interface
Click JMeter Extract directory under the Jmeter.bat file technology to start the JMeter graphical interface, such as Bo Master's directory for
D:\Program Files\apache-jmeter-3.1\bin
2. Load MySQL driver package
Click on "Test Plan" and click "Browse" below to select the MySQL driver package we downloaded earlier in the popup window.
3. Create a new thread group and add the JDBC Connection configuration as shown
4. Configuring the JDBC Connection configuration
5. Add JDBC Request
6. Configure the JDBC Request
Note: 1, the value of the data that needs to be parameterized is replaced by "?"
2.
7. Configuring assertions and viewing results
Right-click the thread group----> Add---> Listener----> Result assertion.
Right-click the thread group----> Add---> Listener----> Graphical results.
Right-click the thread group----> Add---> Listener----> View the results tree.
8. Click to run to see results in the results tree or the assertion results
9, configure the number of threads, click to run
View Graphical Results
This jmeter configuration has been completed ~
Test results and related analysis follow-up supplement ~
JMeter testing MySQL Database middleware Mycat