Sysbench pressure measurement MySQL

172.16.26.33
--mysql-socket=/tmp/mysql3306.sock

Sysbench three steps to load MySQL: Prepare------cleanup
We're all using Sysbench's own LUA script to test MySQL.

# #1. Test MySQL using Oltp_read_write.lua script to test MySQL prep stage: mysql-uroot-pllill2018-e "CREATE Database sbtest;" Sysbench/usr/shar E/sysbench/oltp_read_write.lua--mysql-host=172.16.26.33--mysql-port=3306--mysql-user=root--mysql-password= ' llill2018 '--mysql-socket=/tmp/mysql3306.sock--mysql-db=sbtest--db-driver=mysql--tables=20--table-size=5000000- -threads=32 Prepare test phase: Sysbench/usr/share/sysbench/oltp_read_write.lua--mysql-host=172.16.26.33--mysql-port= 3306--mysql-user=root--mysql-password= ' llill2018 '--mysql-socket=/tmp/mysql3306.sock--mysql-db=sbtest-- Db-driver=mysql--tables=10--table-size=10000--threads=32--report-interval=10--time=120 Run output is as follows: Purge data: Sysbench/ Usr/share/sysbench/oltp_read_write.lua--mysql-host=172.16.26.33--mysql-port=3306--mysql-user=root-- mysql-password= ' llill2018 '--mysql-socket=/tmp/mysql3306.sock--mysql-db=sbtest--db-driver=mysql--tables=10-- table-size=10000--threads=32 cleanup# #2. The file test for the Iosysbench FileIO helpsysbench of the measurement disk needs to be prepare, rThree phases of UN and cleanup. Prepare is the preparation phase that produces the required test file, run is the test phase, and cleanup is the file that the cleanup test produces. For example, create 4 files with a total size of 2G test: Prep phase: Sysbench FileIO--file-num=4--file-total-size=2g Prepare output: 180 seconds to test, 1 threads, random number request 1000 00000 times, Random read performance. Test execution: Sysbench fileio--time=180--events=100000000--threads=1--file-num=4--file-total-size=2g--file-io-mode=sync- -FILE-TEST-MODE=RNDRD--file-block-size=16384 Run output: IOPS = reads/s + writes/s purge test-generated files: Sysbench FileIO--file-num=4- -file-total-size=2g Cleanup # #3. The CPU is Sysbench CPU Helpsysbench CPU--time=300--threads=4 run# #4. Memory Pressure test Sysbench memories Help

　　

Sysbench pressure measurement MySQL