JMeter connecting MySQL

1. Put Mysql-connector-java-5.1.7-bin.jar into the bin folder of the JMeter installation directory

2. Load driver in top level catalogue < test plan >

3. Add JDBC Connection Configuration

4. Configure Database Information

1)Variable name cannot be empty

2) Database URL format: jdbc:mysql://server IP: Port number/Database

Add parameters after the database allowmultiqueries=true, you can execute multiple MySQL statements at the same time;

3) JDBC Driver Class:com.mysql.jdbc.Driver

4) Enter the user name and password for the database

5. Add JDBC Request

6. Adding variables and query statements

The variable name must be consistent with the variable name in the JDBC Connection configuration

7. Execute Query statement

JMeter connecting MySQL