Shulou(Shulou.com)06/01 Report--

This article will explain in detail how JMeter conducts stress testing on MySQL databases. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Install and configure JMeter download

Download the binary zip on the official website.

Configure environment variables

Then extract it to your favorite location, configure the environment variables, and create a new JMETER_HOME.

Then add% JMETER_HOME%\ bin to path

Add to the front of the CLASSPATH

% JMETER_HOME%\ lib\ ext\ ApacheJMeter_core.jar;%JMETER_HOME%\ lib\ jorphan.jar;%JMETER_HOME%\ lib\ logkit-2.0.jar

Import MySQL driver

Put the MySQL driver in the lib folder of the extracted jmeter root directory (you don't have to teach this download)

Click the browse below to find the driver in your lib and double-click

2. Start JMeter

Open the command line and enter jmeter.bat to automatically open the graphical interface of jmeter. It is recommended to check Chinese.

3. Start stress test configuration

Right-click TestPlan to create a new thread group

The number of threads is the number of simulated users, and the Ramp-Up time is how long it takes for the user to complete the request.

The following means that within 1 second, 100 users request the database at the same time, and the number of loops represents a total of 5 executions. It is recommended to set a larger number of threads for good results.

Right-click the thread group to add a JDBC configuration element, which only needs to configure the

Right-click the thread group and add a JDBC Request sampler. Test is the pool name configured earlier, and the SQL statement is written in the box. The type can be queried or modified.

Right-click the thread group, add a few listeners, this is to see the test results, you can add more to play by yourself.

Observation result

If most of the result tree is full of errors, it means that the number of threads is too large, that is, your database cannot afford it.

This is the end of the article on "how JMeter conducts stress testing on MySQL database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.