JMeter testing MySQL Performance

1. Download JDBC. Unzip the JDBC and copy the Mysql-connector-java-version-ga-bin.jar file to Jmeter/lib

2. Open the JMeter and set the JDBC request.

1) dtbase url:jdbc:mysql://localhost:3306/datebasename. of which localhost : 3306, this is the server address you tested, Datebasename, this is the database name you tested. This URL is a connection to JDBC

2) Driver Class:org.gjt.mm.mysql.Driver or Com.mysql.jdbc.Driver If you can't connect to the database, you can try the other

3) Username: Login name for this database

4) Password: This is the login password for the database

5) write the SQL statement in SQL Query string to test.

Graphic explanation

Open JMeter, click Test Plan,

Click on the "Browse ..." button to add your JDBC driver.

3. Add a thread group, right-click on "Thread Group" and add a "JDBC Connection Configuration" below

To configure the JDBC Connection configuration page.

4. Right click on "Thread Group" and add a "JDBC request" below.

5. Add an assertion. Right-click the thread group----> Add---> Assert----> Response assertion.

6. Let's add some listeners to the line to view

Add an assertion result:

Right-click the thread group----> Add---> Listener----> Result assertion.

Add a graphical result:

Right-click the thread group----> Add---> Listener----> Graphical results.

Add a view result tree:

Right-click the thread group----> Add---> Listener----> View the results tree.

Here is a list of all the things to add:

7. Set the number of users, start time and number of cycles in the thread Group page

Click the menu bar "Run"----"Start"

Here's the result:

Seemingly complex database performance testing, in fact, is very simple, just follow the steps to be able to

JMeter testing MySQL Performance