"Turn" JMeter learning notes--a simple method of database performance testing

Prerequisites: One database: The test database has a table with two fields in the User table: Username, Passworld.

Requirements: Insert data into the database in large quantities, 1000/s

In fact, as in the previous method, for the sake of simplicity, I will stick it out.

1. Create a test plan to import the database driver packages that we use.

2. Add a thread group and set our number of virtual users, start time, and number of cycles

3. Create a thread, and under threads, create a JDBC Connection configuration that sets the relevant information.

4. Create a JDBC Request. We need to do an insert operation on the database. (Detailed settings, fancy notes)

5. Add the listener, we choose to add "graphical results" and "view result tree", click "Start" on the menu bar---> Run.

Check out our running results.

During testing, the database commands allow you to see how much data is being inserted into the current database

"Graphical result analysis"The parameters at the bottom of the chart have the following meanings: Number of samples: Total number of requests sent to the server. Latest Sample: The number representing the time, which is the time the server responds to the last request. Throughput: The number of requests that the server processes per minute. Average: Total elapsed time divided by the number of requests sent to the server. Median: The number representing the time, half of the server response time is below this value and the other half is higher than the value. Deviation: The server response time change, the size of the discrete measure value, or, in other words, the distribution of the data. General use of aggregated reports, graphical results to assist analysis of the aggregation report, the response time can not exceed customer requirements, is qualified, for example, can not exceed the response time of 3s, more than 3s is unqualified "thinking" how to bulk insert different data into the database? For details, please refer to the article "Turn to" jmeter study notes-parameterization "
"Reprint Link" http://www.cnblogs.com/fnng/archive/2011/08/03/2126775.html

"Turn" JMeter learning notes--a simple method of database performance testing