JMeter Test MySQL Database

Prerequisite: The MySQL database is installed and the JMeter installation package is downloaded

1. Open JMeter

2, download Mysql-connector-java.jar, the jar package is copied to the JMeter bin directory by default, because the Bin directory is opened by default

3. Add the jar package to the JMeter test plan

4. Right-click Test Plan, add, configure components, JDBC Connection configuration

5. Configuring content in the JDBC Connection configuration

Database URL:JDBC:MYSQL://LOCALHOST:3306/XKD

JDBC Connection Configuration:com.mysql.jdbc.Driver

6. Right-click Test Plan, add-SAMPLER-JDBC request

7. Configure the JDBC request to write SQL statements

8. Add the appropriate listener

9. Add the thread group, configure the thread group, and move the previously configured JDBC to the thread group

10. Database data:

11. Operation

JMeter Test MySQL Database