JMeter using record 1--JDBC Test

Scenario: Stress test for Web application and MySQL database using JMeter

JMeter is a very powerful test tool. Can be used to test the Web, database. Since 07 has been used since the love of it, the following record in a project for its simple use.

Project Sub-database testing and Web application testing

The database test is relatively simple. The JDBC driver of the database to be tested is put into the JMeter Lib directory, a new thread group, a 100 thread, a loop of 10 times, 10 seconds to start all threads, and a JDBC connection configuration to increase the CRUD operations to be performed. Click Start button. Then through the summary report to see performance.

Set up a thread group. Start 100 threads (10s end), each thread loops through all steps 10 times, and a step goes wrong and continues to run:

JDBC Connection configuration:

Crud in C, because some fields of data require uniqueness. Therefore, a counter (counter) is added. To guarantee the uniqueness of the field in the database:

Counter:

Run Ctrl+r, can see test data summary in summary report

Ability to see the interaction of each request in the view result tree for easy debug

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvy2xvdwrfbgw=/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center ">

Many other Debug. Able to pass the JMeter interface. Option-"Log Viewer" to help debug jmeter the problem encountered during execution. you want the log viewer to display a lot of other logs that can change the jmeter.properties below the bin directory

Log_level.jmeter=info
Log_level.jmeter.junit=debug
#log_level. Jmeter.control=debug
#log_level. Jmeter.testbeans=debug
#log_level. Jmeter.engine=debug
#log_level. Jmeter.threads=debug
#log_level. Jmeter.gui=warn
#log_level. Jmeter.testelement=debug
#log_level. Jmeter.util=warn
#log_level. Jmeter.util.classfinder=warn
#log_level. Jmeter.test=debug
#log_level. Jmeter.protocol.http=debug
# for Cookiemanager, AuthManager etc:
#log_level. Jmeter.protocol.http.control=debug
#log_level. Jmeter.protocol.ftp=warn
#log_level. Jmeter.protocol.jdbc=debug
#log_level. Jmeter.protocol.java=warn
#log_level. Jmeter.testelements.property=debug
Log_level.jorphan=info

Next:JMeter use record 2--Web test

JMeter using record 1--JDBC Test