Using JMeter to realize the change and deletion of MySQL database

　　The main reference is the "use JMeter to create a database (Mysql) test".

My environment:

Mysql:mysql 5.6.21

JDBC Driver: I use 5.1.7, the lower version seems to have a problem, with this is no problem

jmeter:jmeter2.1.1

1. Open JMeter, click Test Plan

Click the "Browse" button to add the JDBC driver

2. Add Thread Group

JMeter performance testing, the most important is the thread group, the thread group is the equivalent of user activity

3. Add JDBC Connection Configuration

Configure JDBC with allowmultiqueries=true to execute multiple SQL statements

4. Add JDBC Request

Configure the JDBC Request page

Where Variable name is the same as the Variable name in the JDBC Connection configuration.

Add "View results tree" to see if the request was successful

Using JMeter to realize the change and deletion of MySQL database