Create a Database test plan

Establish a test plan to test the database server.

You will create 50 user 2 SQL requests to send to the database server. Repeat these tests 100 times.

Total number of requests = 2 x x = Ten ' JDBC requests

To build this test plan, you need to use the following Elements:thread Group, JDBC Request, Summary report.

The following example uses the MySQL database driver. With this driver, he contains. jar files (for example: Mysql-connector-java-x.x.x-bin.jar) that must be copied to JMeter./lib Road. JMeter ' s classpath detailed description.

1 adding the thread Group

You need a valid database, a database table, a user-level access table.

2 Adding a JDBC request

ADD-Config Element-to JDBC Connection Configuration

Variable Name: A unique value is required to identify the configuration, which uses the JDBC sampler to determine which configuration to use.

Database URL:

JDBC Driver class:

Username:

Password:

Create a Database test plan