JMeter Test MySQL Database

1. The first step is to download the JDBC driver: Mysql-connector-java.jar, put the jar package in JMeter lib\ext.

2. Add the jar package to the test plan, and see.

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7F/3B/wKiom1cXMpfSXSUqAAG4QpBqP38040.jpg "title=" Plan.jpg "alt=" Wkiom1cxmpfsxsuqaag4qpbqp38040.jpg "/>

3. Add JDBC Connection configuration, Focus: Variable name and database connection configuration, see

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/7F/39/wKioL1cXNJrhCwl8AAK19fsLHmc671.jpg "title=" Configuration.jpg "alt=" Wkiol1cxnjrhcwl8aak19fslhmc671.jpg "/>

4. Add JDBC request,variable name and keep it consistent.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/7F/3B/wKiom1cXNG-B5wp3AAFIdn48DB4827.jpg "title=" Request.jpg "alt=" Wkiom1cxng-b5wp3aafidn48db4827.jpg "/>

5. Add view results tree, execute, and view results, see

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/7F/3B/wKiom1cXNOai0v6xAAFuKYKTnPA554.jpg "title=" Result.jpg "alt=" Wkiom1cxnoai0v6xaafukyktnpa554.jpg "/>

6. Note: If you need to execute more than one statement at a time, at the 3rd step, add the following information after the database URL

Jdbc:mysql://172.16.14.28:3306/shop?allowmultiqueries=true

JMeter Test MySQL Database