Jmeter JDBC Request-mysql

To test MySQL data with JMeter, you can use a JDBC request, if the test is a newly created component, and if there are multiple requests, you can create multiple JDBC Connection cobfiguration and corresponding JDBC requests:

A new thread group, as shown, can also create a new group, thread groups are easy to debug with:

Second, the new JDBC Connection cobfiguration:

On this page, you need to configure the following data:

Variable Name Bound to Pool: This value should be unique throughout the test plan so that the JDBC sampler distinguishes between different connection configurations;

Database ULR-Connection address: JDBC:MYSQL://10.10.21.188:3306/HLF

JDBC Driver Class-database driver: Com.mysql.jdbc.Driver

Username-User logging in to the database

Password-Password for login database

Here to download a jar package (Http://pan.baidu.com/s/1i48TKbV), Mysql-connector-java-5.1.26-bin.jar, I put this jar package into the Lib/ext directory, can also be placed in the Lib directory

Third, create a new JDBC request, Varibale Name Bound to pool and JDBC Connection cobfiguration, enter the SQL statement to execute as shown in:

Iv. Add the listener, I often use is as follows:

The result of the execution is as shown in the request success:

Jmeter JDBC Request-mysql