My environment: Mysql:mysql-essential-5.1.51-win32
JDBC Driver: I've uploaded it to csdn. Previous: http://download.csdn.net/source/3451945
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:
Go: Create a database (Mysql) test using JMeter