JMeter testing MySQL Database middleware Mycat

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