Use jmeter to create a database (MySQL) for testing

Okay! I always think that I am not smart, so I use the most detailed and clear way to write thisArticle. I believe, what I can understand is something you can understand.

 

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

JDBC driver: I have uploaded to csdn last: http://download.csdn.net/source/3451945

Jmeter: any version of The jmeter-2.4.

1. First, we need a database that can be tested. Of course, there must be data in it. Otherwise, how should we test it? My previous article 《Connecting eclipse to MySQL database), Which teaches you how to passProgramInsert data in batches.

Let's take a look at my data:

I may be a bit wordy :) no matter what method you use, you need a bit of data in your database.

2.

Open jmeter and click test plan,

Click Browse... to add your JDBC driver.

3.

Add a thread group,

Right-click "thread group" and add a "JDBC connection configuration" below"

To configure the JDBC connection configuration page.

4.

Right-click "thread group" and add a "JDBC request" below"

5.

Add assertions.

Right-click the thread group ----> Add ---> assertion ----> response assertion.

6.

Let's add some listeners to view them.

Add an asserted result:

Right-click the thread group ----> Add ---> listener ----> result asserted.

Add a graphic result:

Right-click the thread group ----> Add ---> listener ----> graph result.

Add a view result tree:

Right-click the thread group ----> Add ---> listener ----> View the result tree.

The following is a list of the added items:

7.

Set the number of users, start time, and number of cycles on the thread group page.

Click "run"-"start" in the menu bar"

The result is as follows:

 

The other results will not be pasted. Hey !! It looks simple but long to speak with images ..