mysql5.6 Pressure test Sysbench tool

In the face of high-concurrency large-traffic servers, according to business needs often need to database, operating system I/O, bandwidth and so on to do stress testing. To determine when to do load balancing, add servers, etc. to prepare for business support. The Linux system can analyze the pressure of the system through iotop,dstat,top and so on. There are a lot of good tools for MySQL SYSBENCH,TPCC and so on.

Today, use Sysbench to test the mysql5.6.23 community version, server comparison slag, 4 core cpu,16g, disk speed 9600 But the results of the test is still relatively satisfactory.

Through stress testing, you can have a basic understanding of the processing power of the server. There is a picture of the truth. Straight up.

The 1,sysbench CPU test uses a 64-bit integer to test the time it takes to calculate the prime number until a maximum value.

2, test the performance of the thread scheduler. Testing the behavior of the thread scheduler for high load scenarios

3, the File IO performance test generates the required test files, the total file size 5g,16 a concurrent thread

4, the mutex test, which tests the performance of the mutex by simulating all threads running concurrently at the same time and briefly requesting the mutex.

5, Memory test, Memory test test the continuous read and write performance of memory

6MySQL database thing processing test

mysql5.6 Pressure test Sysbench tool