These two days received a task to
TestThe performance of a server, customer requirements to
DatabaseWithin the 1000/s (each inserted 1000 data) processing capacity, then the brain gambling, thinking is to use LR, because the LR contact is not deep, only know that the LR implementation of parameterization can call the data inside the database, to the inside of a large number of data inserted, have not tried before. Looked through the information, found a "a special database
Performance Testing, the idea is: by writing a
JavaProgram to iterate through the data and write a batch file to invoke the Java program. The batch file is then invoked through the system () function of the LR to
pressure test。 But for me this rookie, a lot of details do not understand. For example, that batch of processing let me very embarrassed. Oh. In fact, through the jmeter is very simple to complete, you can refer to my previous article
articleJMeter CREATE DATABASE (MYSQL) test. Prerequisites: One database: The test database has a table with two fields in the User table: Username, Passworld. Requirements: To a large number of data inserted into the database, 1000/s in fact, the same way as before, for the sake of simplicity, I would like to post it. 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. To add a listener, we choose to add "graphical results" and "View results tree" Here, 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
A simple method of database performance testing
