The third--jmeter test database MySQL

JMeter Analog 100 user access to MySQL database

1, the MySQL database driver "Mysql-connector-java-5.1.15-bin.jar" into the JMeter Lib directory, the new thread Group 100 "Simulation 100 Users", the number of cycles 10 times, Start all threads in 10s.

2. Select "JDBC Connection configuration" in the right-click Configuration Component, Variable name to configure custom name Csmsdatabase, configure database Maximum connections and database configuration information.

3. Select the JDBC request in the right-sampler, a query for a JDBC request, note that the variable name in the JDBC request must be consistent with the JDBC Connection configuration

"Csmsdatabase", test multiple databases, configure multiple JDBC Connection configurations, assign different variable name.

Note that if you want to use a query condition, the Query Type "Prepared Select Statement" is required to simulate queries based on ID.

4. Configure the Listener "view result tree" and "Aggregation report".

5, Test the aggregation report.

6,Adjust the maximum number of connections, and constantly test the database query limit.

The third--jmeter test database MySQL