Database using JMeter to create a database (MYSQL) test

My environment: Mysql:mysql-essential-5.1.51-win32

JDBC Driver: I've uploaded it to csdn. Previous: http://download.csdn.net/detail/paulwinflo/8818921

jmeter:jmeter-2.4 any version is OK.

1. First we have a database that can be tested, of course, there must be data, or how to measure it? In my previous article, Eclipse connects to MySQL database (fool's article), which teaches you how to bulk insert data through a program.

Take a look at my data:

I may be a bit verbose: no matter how you use it, there's a bit of data in your database.

2.

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 see

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 number of users, start time, number of cycles on the thread Group page

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

Here's the result:

The other results of the picture will not be posted. Hehe!! Talking in pictures, it looks simple, but rather long.

Database using JMeter to create a database (MYSQL) test