sysbench 压测 安装

本文详细介绍sysbench工具的安装与使用,涵盖CPU、磁盘IO、数据库等多方面性能测试,特别聚焦于OLTP测试场景,提供详实的测试命令与结果分析。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

    sysbench是一款开源的多线程性能测试工具,可以执行CPU/内存/线程/IO/数据库等方面的性能测试。

更重要的我们是用来做OLTP的测试

http://imysql.com/2014/10/17/sysbench-full-user-manual.shtml

下载地址:http://imysql.com/wp-content/uploads/2014/09/sysbench-0.4.12-1.1.tgz

sysbench-0.4.12-1.1.tgz

tar -zxvf sysbench-0.4.12-1.1.tgz

cd sysbench-0.4.12-1.1

sysbench支持以下几种测试模式:

 

1、CPU运算性能

2、磁盘IO性能

3、调度程序性能

4、内存分配及传输速度

5、POSIX线程性能

6、数据库性能(OLTP基准测试)

目前sysbench主要支持 mysql,drizzle,pgsql,oracle 等几种数据库。

二、编译安装

前提是安装了编译环境:

     包括gcc  libtool  openssl  openssl-devel

编译非常简单,可参考 README 文档,简单步骤如下:

https://github.com/akopytov/sysbench/releases/tag/1.0.9

[root@mysqlcentos01 sysbench-1.0.9]#  ./autogen.sh

[root@mysqlcentos01 sysbench-1.0.9]# ./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib   --with-mysql

[root@mysqlcentos01 sysbench-1.0.9]# make

[root@mysqlcentos01 sysbench-1.0.9]# make install

环境变量:

安装完成之后会在目录下生产sysbench命令

直接cp到

[root@mysqlcentos01 sysbench-1.0.9]# pwd

/opt/sysbench-1.0.9

[root@mysqlcentos01 sysbench-1.0.9]# cp sysbench /usr/local/bin/sysbench

sysbench报错:

[root@mysqlcentos01 include]# sysbench --help

sysbench: error while loading shared libraries: libmysqlclient.so

.20: cannot open shared object file: No such file or directory

ln -s /opt/mysql/mysql-5.7.18-linux-glibc2.5-x86_64/lib/libmysqlclient.so  /usr/lib64/libmysqlclient.so.20

[root@centos03mm test]# sysbench --threads=10 --max-time=300 threads run 
sysbench: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
[root@centos03mm test]#

解决方法:
vi /etc/profile
export LD_LIBRARY_PATH=/usr/local/mysql/lib
source /etc/profile

测试cpu

[root@mysqlcentos01 sysbench-1.0.9]# sysbench --test=cpu --num-threads=4 --max-time=10 run

WARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.

WARNING: --num-threads is deprecated, use --threads instead

WARNING: --max-time is deprecated, use --time instead

sysbench 1.0.9 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:

Number of threads: 4

Initializing random number generator from current time

 

 

Prime numbers limit: 10000

 

Initializing worker threads...

 

Threads started!

 

CPU speed:

    events per second:   888.00

 

General statistics:

    total time:                          10.0020s

    total number of events:              8883

 

Latency (ms):

         min:                                  1.00

         avg:                                  4.49

         max:                                304.61

         95th percentile:                     33.12

         sum:                              39893.75

 

Threads fairness:

    events (avg/stddev):           2220.7500/35.22

    execution time (avg/stddev):   9.9734/0.03

 

[root@mysqlcentos01 sysbench-1.0.9]#

 

 

根据以上提示修改为:

[root@mysqlcentos01 opt]# sysbench cpu --threads=4 --time=10 run

sysbench 1.0.9 (using bundled LuaJIT 2.1.0-beta2)

 

Running the test with following options:

Number of threads: 4

Initializing random number generator from current time

 

 

Prime numbers limit: 10000

 

Initializing worker threads...

 

Threads started!

 

CPU speed:

    events per second:   930.90

 

General statistics:

    total time:                          10.0008s

    total number of events:              9311

 

Latency (ms):

         min:                                  1.00

         avg:                                  4.28

         max:                                 64.02

         95th percentile:                     33.12

         sum:                              39882.94

 

Threads fairness:

    events (avg/stddev):           2327.7500/5.89

    execution time (avg/stddev):   9.9707/0.02

 

[root@mysqlcentos01 opt]#

 

 

OLTP测试:

 

先生成一份测试数据

[root@mysqlcentos01 opt]# sysbench --mysql-host=127.0.0.1 --mysql-port=3306   --mysql-sock=/tmp/mysql3306.sock --mysql-user=root --mysql-password=evis123   /opt/sysbench-1.0.9/tests/include/oltp_legacy/oltp.lua   --oltp_tables_count=10 --oltp-table-size=100000 --rand-init=on prepare 

sysbench 1.0.9 (using bundled LuaJIT 2.1.0-beta2)

 

Creating table 'sbtest1'...

Inserting 100000 records into 'sbtest1'

Creating secondary indexes on 'sbtest1'...

Creating table 'sbtest2'...

Inserting 100000 records into 'sbtest2'

Creating secondary indexes on 'sbtest2'...

Creating table 'sbtest3'...

Inserting 100000 records into 'sbtest3'

Creating secondary indexes on 'sbtest3'...

Creating table 'sbtest4'...

Inserting 100000 records into 'sbtest4'

Creating secondary indexes on 'sbtest4'...

Creating table 'sbtest5'...

Inserting 100000 records into 'sbtest5'

Creating secondary indexes on 'sbtest5'...

Creating table 'sbtest6'...

Inserting 100000 records into 'sbtest6'

Creating secondary indexes on 'sbtest6'...

Creating table 'sbtest7'...

Inserting 100000 records into 'sbtest7'

Creating secondary indexes on 'sbtest7'...

Creating table 'sbtest8'...

Inserting 100000 records into 'sbtest8'

Creating secondary indexes on 'sbtest8'...

Creating table 'sbtest9'...

Inserting 100000 records into 'sbtest9'

Creating secondary indexes on 'sbtest9'...

Creating table 'sbtest10'...

Inserting 100000 records into 'sbtest10'

Creating secondary indexes on 'sbtest10'...

[root@mysqlcentos01 opt]#

 

开始测试:

[root@mysqlcentos01 opt]# sysbench --mysql-host=127.0.0.1 --mysql-port=3306   --mysql-user=root --mysql-password=evis123     /opt/sysbench-1.0.9/tests/include/oltp_legacy/oltp.lua  --mysql-table-engine=innodb --oltp_tables_count=10 --oltp-table-size=100000 --num-threads=2 --oltp-read-only=off  --report-interval=10 --rand-type=uniform --max-time=1800 --max-requests=0 --percentile=99 run >> sysbench_insert_200_20170930.log

 

[root@mysqlcentos01 opt]#

[root@mysqlcentos01 opt]#

 

测试结果:

 

[root@mysqlcentos01 opt]# cat  sysbench_insert_200_20170930.log

WARNING: --num-threads is deprecated, use --threads instead

WARNING: --max-time is deprecated, use --time instead

sysbench 1.0.9 (using bundled LuaJIT 2.1.0-beta2)

 

Running the test with following options:

Number of threads: 2

Report intermediate results every 10 second(s)

Initializing random number generator from current time

 

 

Initializing worker threads...

 

Threads started!

 

[ 10s ] thds: 2 tps: 6.00 qps: 121.47 (r/w/o: 85.28/23.99/12.20) lat (ms,99%): 719.92 err/s: 0.00 reconn/s: 0.00

[ 20s ] thds: 2 tps: 5.70 qps: 115.20 (r/w/o: 81.00/22.80/11.40) lat (ms,99%): 623.33 err/s: 0.00 reconn/s: 0.00

[ 30s ] thds: 2 tps: 6.40 qps: 128.30 (r/w/o: 89.90/25.60/12.80) lat (ms,99%): 1032.01 err/s: 0.00 reconn/s: 0.00

[ 40s ] thds: 2 tps: 7.00 qps: 138.70 (r/w/o: 96.70/28.00/14.00) lat (ms,99%): 909.80 err/s: 0.00 reconn/s: 0.00

[ 50s ] thds: 2 tps: 6.90 qps: 138.00 (r/w/o: 96.60/27.60/13.80) lat (ms,99%): 846.57 err/s: 0.00 reconn/s: 0.00

[ 60s ] thds: 2 tps: 4.60 qps: 92.60 (r/w/o: 65.00/18.40/9.20) lat (ms,99%): 846.57 err/s: 0.00 reconn/s: 0.00

[ 70s ] thds: 2 tps: 5.10 qps: 101.50 (r/w/o: 70.80/20.50/10.20) lat (ms,99%): 1427.08 err/s: 0.00 reconn/s: 0.00

[ 80s ] thds: 2 tps: 6.30 qps: 126.81 (r/w/o: 89.10/25.10/12.60) lat (ms,99%): 759.88 err/s: 0.00 reconn/s: 0.00

[ 90s ] thds: 2 tps: 5.60 qps: 111.68 (r/w/o: 78.08/22.40/11.20) lat (ms,99%): 1191.92 err/s: 0.00 reconn/s: 0.00

[ 100s ] thds: 2 tps: 6.00 qps: 120.72 (r/w/o: 84.61/24.10/12.00) lat (ms,99%): 1149.76 err/s: 0.00 reconn/s: 0.00

[ 110s ] thds: 2 tps: 7.00 qps: 139.41 (r/w/o: 97.50/27.90/14.00) lat (ms,99%): 846.57 err/s: 0.00 reconn/s: 0.00

[ 120s ] thds: 2 tps: 4.60 qps: 92.29 (r/w/o: 64.69/18.40/9.20) lat (ms,99%): 1427.08 err/s: 0.00 reconn/s: 0.00

[ 130s ] thds: 2 tps: 6.40 qps: 128.01 (r/w/o: 89.50/25.70/12.80) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 140s ] thds: 2 tps: 6.20 qps: 124.21 (r/w/o: 87.01/24.80/12.40) lat (ms,99%): 1069.86 err/s: 0.00 reconn/s: 0.00

[ 150s ] thds: 2 tps: 6.10 qps: 120.70 (r/w/o: 84.20/24.30/12.20) lat (ms,99%): 1013.60 err/s: 0.00 reconn/s: 0.00

[ 160s ] thds: 2 tps: 6.20 qps: 124.49 (r/w/o: 87.29/24.80/12.40) lat (ms,99%): 926.33 err/s: 0.00 reconn/s: 0.00

[ 170s ] thds: 2 tps: 6.60 qps: 132.41 (r/w/o: 92.80/26.40/13.20) lat (ms,99%): 1050.76 err/s: 0.00 reconn/s: 0.00

[ 180s ] thds: 2 tps: 6.40 qps: 128.70 (r/w/o: 90.10/25.80/12.80) lat (ms,99%): 682.06 err/s: 0.00 reconn/s: 0.00

[ 190s ] thds: 2 tps: 6.70 qps: 131.80 (r/w/o: 91.80/26.60/13.40) lat (ms,99%): 995.51 err/s: 0.00 reconn/s: 0.00

[ 200s ] thds: 2 tps: 6.20 qps: 126.10 (r/w/o: 88.80/24.90/12.40) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 210s ] thds: 2 tps: 7.20 qps: 142.09 (r/w/o: 99.00/28.70/14.40) lat (ms,99%): 694.45 err/s: 0.00 reconn/s: 0.00

[ 220s ] thds: 2 tps: 7.20 qps: 145.99 (r/w/o: 102.60/29.00/14.40) lat (ms,99%): 657.93 err/s: 0.00 reconn/s: 0.00

[ 230s ] thds: 2 tps: 6.10 qps: 121.50 (r/w/o: 85.00/24.30/12.20) lat (ms,99%): 1109.09 err/s: 0.00 reconn/s: 0.00

[ 240s ] thds: 2 tps: 7.60 qps: 150.61 (r/w/o: 105.10/30.30/15.20) lat (ms,99%): 580.02 err/s: 0.00 reconn/s: 0.00

[ 250s ] thds: 2 tps: 7.30 qps: 147.11 (r/w/o: 103.30/29.20/14.60) lat (ms,99%): 475.79 err/s: 0.00 reconn/s: 0.00

[ 260s ] thds: 2 tps: 6.00 qps: 120.29 (r/w/o: 84.30/24.00/12.00) lat (ms,99%): 831.46 err/s: 0.00 reconn/s: 0.00

[ 270s ] thds: 2 tps: 6.30 qps: 125.89 (r/w/o: 88.09/25.20/12.60) lat (ms,99%): 1327.91 err/s: 0.00 reconn/s: 0.00

[ 280s ] thds: 2 tps: 8.20 qps: 162.71 (r/w/o: 113.51/32.80/16.40) lat (ms,99%): 520.62 err/s: 0.00 reconn/s: 0.00

[ 290s ] thds: 2 tps: 7.50 qps: 151.10 (r/w/o: 106.10/30.00/15.00) lat (ms,99%): 530.08 err/s: 0.00 reconn/s: 0.00

[ 300s ] thds: 2 tps: 7.20 qps: 143.90 (r/w/o: 100.70/28.80/14.40) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 310s ] thds: 2 tps: 6.90 qps: 138.81 (r/w/o: 97.30/27.70/13.80) lat (ms,99%): 893.56 err/s: 0.00 reconn/s: 0.00

[ 320s ] thds: 2 tps: 6.70 qps: 132.50 (r/w/o: 92.40/26.70/13.40) lat (ms,99%): 746.32 err/s: 0.00 reconn/s: 0.00

[ 330s ] thds: 2 tps: 5.60 qps: 112.80 (r/w/o: 79.20/22.40/11.20) lat (ms,99%): 846.57 err/s: 0.00 reconn/s: 0.00

[ 340s ] thds: 2 tps: 6.40 qps: 127.40 (r/w/o: 88.90/25.70/12.80) lat (ms,99%): 733.00 err/s: 0.00 reconn/s: 0.00

[ 350s ] thds: 2 tps: 7.20 qps: 144.50 (r/w/o: 101.40/28.70/14.40) lat (ms,99%): 926.33 err/s: 0.00 reconn/s: 0.00

[ 360s ] thds: 2 tps: 7.00 qps: 140.09 (r/w/o: 98.10/28.00/14.00) lat (ms,99%): 569.67 err/s: 0.00 reconn/s: 0.00

[ 370s ] thds: 2 tps: 6.30 qps: 125.41 (r/w/o: 87.60/25.20/12.60) lat (ms,99%): 682.06 err/s: 0.00 reconn/s: 0.00

[ 380s ] thds: 2 tps: 2.30 qps: 44.60 (r/w/o: 30.80/9.20/4.60) lat (ms,99%): 2362.72 err/s: 0.00 reconn/s: 0.00

[ 390s ] thds: 2 tps: 4.10 qps: 84.40 (r/w/o: 59.80/16.40/8.20) lat (ms,99%): 1304.21 err/s: 0.00 reconn/s: 0.00

[ 400s ] thds: 2 tps: 4.20 qps: 83.30 (r/w/o: 58.10/16.80/8.40) lat (ms,99%): 1352.03 err/s: 0.00 reconn/s: 0.00

[ 410s ] thds: 2 tps: 3.80 qps: 74.60 (r/w/o: 51.80/15.20/7.60) lat (ms,99%): 1213.57 err/s: 0.00 reconn/s: 0.00

[ 420s ] thds: 2 tps: 6.40 qps: 129.80 (r/w/o: 91.40/25.60/12.80) lat (ms,99%): 995.51 err/s: 0.00 reconn/s: 0.00

[ 430s ] thds: 2 tps: 5.90 qps: 118.60 (r/w/o: 83.10/23.70/11.80) lat (ms,99%): 995.51 err/s: 0.00 reconn/s: 0.00

[ 440s ] thds: 2 tps: 7.50 qps: 149.80 (r/w/o: 104.80/30.00/15.00) lat (ms,99%): 493.24 err/s: 0.00 reconn/s: 0.00

[ 450s ] thds: 2 tps: 8.20 qps: 163.60 (r/w/o: 114.50/32.70/16.40) lat (ms,99%): 467.30 err/s: 0.00 reconn/s: 0.00

[ 460s ] thds: 2 tps: 6.60 qps: 131.10 (r/w/o: 91.50/26.40/13.20) lat (ms,99%): 893.56 err/s: 0.00 reconn/s: 0.00

[ 470s ] thds: 2 tps: 7.30 qps: 146.19 (r/w/o: 102.40/29.20/14.60) lat (ms,99%): 682.06 err/s: 0.00 reconn/s: 0.00

[ 480s ] thds: 2 tps: 7.40 qps: 148.10 (r/w/o: 103.70/29.60/14.80) lat (ms,99%): 802.05 err/s: 0.00 reconn/s: 0.00

[ 490s ] thds: 2 tps: 7.40 qps: 148.40 (r/w/o: 103.90/29.70/14.80) lat (ms,99%): 502.20 err/s: 0.00 reconn/s: 0.00

[ 500s ] thds: 2 tps: 6.20 qps: 123.80 (r/w/o: 86.70/24.70/12.40) lat (ms,99%): 960.30 err/s: 0.00 reconn/s: 0.00

[ 510s ] thds: 2 tps: 7.10 qps: 142.30 (r/w/o: 99.70/28.40/14.20) lat (ms,99%): 746.32 err/s: 0.00 reconn/s: 0.00

[ 520s ] thds: 2 tps: 8.20 qps: 162.40 (r/w/o: 113.20/32.80/16.40) lat (ms,99%): 719.92 err/s: 0.00 reconn/s: 0.00

[ 530s ] thds: 2 tps: 7.20 qps: 144.60 (r/w/o: 101.40/28.80/14.40) lat (ms,99%): 802.05 err/s: 0.00 reconn/s: 0.00

[ 540s ] thds: 2 tps: 7.20 qps: 144.51 (r/w/o: 101.30/28.80/14.40) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 550s ] thds: 2 tps: 7.10 qps: 141.70 (r/w/o: 99.10/28.40/14.20) lat (ms,99%): 1213.57 err/s: 0.00 reconn/s: 0.00

[ 560s ] thds: 2 tps: 6.60 qps: 131.89 (r/w/o: 92.30/26.40/13.20) lat (ms,99%): 831.46 err/s: 0.00 reconn/s: 0.00

[ 570s ] thds: 2 tps: 6.70 qps: 133.60 (r/w/o: 93.40/26.80/13.40) lat (ms,99%): 646.19 err/s: 0.00 reconn/s: 0.00

[ 580s ] thds: 2 tps: 3.70 qps: 74.20 (r/w/o: 52.00/14.80/7.40) lat (ms,99%): 2082.91 err/s: 0.00 reconn/s: 0.00

[ 590s ] thds: 2 tps: 3.60 qps: 73.00 (r/w/o: 51.40/14.40/7.20) lat (ms,99%): 2985.89 err/s: 0.00 reconn/s: 0.00

[ 600s ] thds: 2 tps: 7.30 qps: 144.70 (r/w/o: 100.90/29.20/14.60) lat (ms,99%): 520.62 err/s: 0.00 reconn/s: 0.00

[ 610s ] thds: 2 tps: 7.40 qps: 147.50 (r/w/o: 103.10/29.60/14.80) lat (ms,99%): 493.24 err/s: 0.00 reconn/s: 0.00

[ 620s ] thds: 2 tps: 3.50 qps: 71.30 (r/w/o: 50.30/14.00/7.00) lat (ms,99%): 2198.52 err/s: 0.00 reconn/s: 0.00

[ 630s ] thds: 2 tps: 8.10 qps: 162.00 (r/w/o: 113.40/32.40/16.20) lat (ms,99%): 502.20 err/s: 0.00 reconn/s: 0.00

[ 640s ] thds: 2 tps: 7.00 qps: 140.40 (r/w/o: 98.40/28.00/14.00) lat (ms,99%): 909.80 err/s: 0.00 reconn/s: 0.00

[ 650s ] thds: 2 tps: 6.10 qps: 122.10 (r/w/o: 85.50/24.40/12.20) lat (ms,99%): 909.80 err/s: 0.00 reconn/s: 0.00

[ 660s ] thds: 2 tps: 7.40 qps: 147.37 (r/w/o: 102.98/29.59/14.80) lat (ms,99%): 943.16 err/s: 0.00 reconn/s: 0.00

[ 670s ] thds: 2 tps: 6.60 qps: 131.73 (r/w/o: 92.12/26.41/13.20) lat (ms,99%): 612.21 err/s: 0.00 reconn/s: 0.00

[ 680s ] thds: 2 tps: 7.40 qps: 148.69 (r/w/o: 104.29/29.60/14.80) lat (ms,99%): 590.56 err/s: 0.00 reconn/s: 0.00

[ 690s ] thds: 2 tps: 7.90 qps: 157.41 (r/w/o: 110.00/31.60/15.80) lat (ms,99%): 493.24 err/s: 0.00 reconn/s: 0.00

[ 700s ] thds: 2 tps: 6.80 qps: 136.80 (r/w/o: 96.00/27.20/13.60) lat (ms,99%): 861.95 err/s: 0.00 reconn/s: 0.00

[ 710s ] thds: 2 tps: 8.20 qps: 164.51 (r/w/o: 115.20/32.90/16.40) lat (ms,99%): 493.24 err/s: 0.00 reconn/s: 0.00

[ 720s ] thds: 2 tps: 7.40 qps: 146.80 (r/w/o: 102.50/29.50/14.80) lat (ms,99%): 580.02 err/s: 0.00 reconn/s: 0.00

[ 730s ] thds: 2 tps: 6.70 qps: 132.90 (r/w/o: 92.70/26.80/13.40) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 740s ] thds: 2 tps: 5.90 qps: 119.30 (r/w/o: 83.90/23.60/11.80) lat (ms,99%): 816.63 err/s: 0.00 reconn/s: 0.00

[ 750s ] thds: 2 tps: 7.10 qps: 142.40 (r/w/o: 99.80/28.40/14.20) lat (ms,99%): 816.63 err/s: 0.00 reconn/s: 0.00

[ 760s ] thds: 2 tps: 7.90 qps: 157.60 (r/w/o: 110.20/31.60/15.80) lat (ms,99%): 520.62 err/s: 0.00 reconn/s: 0.00

[ 770s ] thds: 2 tps: 6.30 qps: 125.80 (r/w/o: 88.00/25.20/12.60) lat (ms,99%): 816.63 err/s: 0.00 reconn/s: 0.00

[ 780s ] thds: 2 tps: 6.30 qps: 126.69 (r/w/o: 88.89/25.20/12.60) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 790s ] thds: 2 tps: 6.80 qps: 135.10 (r/w/o: 94.30/27.20/13.60) lat (ms,99%): 634.66 err/s: 0.00 reconn/s: 0.00

[ 800s ] thds: 2 tps: 7.00 qps: 140.41 (r/w/o: 98.40/28.00/14.00) lat (ms,99%): 559.50 err/s: 0.00 reconn/s: 0.00

[ 810s ] thds: 2 tps: 6.50 qps: 129.29 (r/w/o: 90.30/26.00/13.00) lat (ms,99%): 773.68 err/s: 0.00 reconn/s: 0.00

[ 820s ] thds: 2 tps: 7.10 qps: 142.90 (r/w/o: 100.10/28.60/14.20) lat (ms,99%): 943.16 err/s: 0.00 reconn/s: 0.00

[ 830s ] thds: 2 tps: 6.30 qps: 126.90 (r/w/o: 89.20/25.10/12.60) lat (ms,99%): 601.29 err/s: 0.00 reconn/s: 0.00

[ 840s ] thds: 2 tps: 5.20 qps: 102.40 (r/w/o: 71.30/20.70/10.40) lat (ms,99%): 1013.60 err/s: 0.00 reconn/s: 0.00

[ 850s ] thds: 2 tps: 4.90 qps: 98.50 (r/w/o: 69.10/19.60/9.80) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 860s ] thds: 2 tps: 7.20 qps: 143.40 (r/w/o: 100.20/28.80/14.40) lat (ms,99%): 1280.93 err/s: 0.00 reconn/s: 0.00

[ 870s ] thds: 2 tps: 5.40 qps: 108.69 (r/w/o: 76.30/21.60/10.80) lat (ms,99%): 816.63 err/s: 0.00 reconn/s: 0.00

[ 880s ] thds: 2 tps: 7.80 qps: 157.01 (r/w/o: 110.11/31.30/15.60) lat (ms,99%): 539.71 err/s: 0.00 reconn/s: 0.00

[ 890s ] thds: 2 tps: 6.50 qps: 128.10 (r/w/o: 89.20/25.90/13.00) lat (ms,99%): 877.61 err/s: 0.00 reconn/s: 0.00

[ 900s ] thds: 2 tps: 7.00 qps: 141.20 (r/w/o: 99.20/28.00/14.00) lat (ms,99%): 926.33 err/s: 0.00 reconn/s: 0.00

[ 910s ] thds: 2 tps: 7.10 qps: 142.39 (r/w/o: 99.80/28.40/14.20) lat (ms,99%): 580.02 err/s: 0.00 reconn/s: 0.00

[ 920s ] thds: 2 tps: 7.30 qps: 145.50 (r/w/o: 101.40/29.50/14.60) lat (ms,99%): 682.06 err/s: 0.00 reconn/s: 0.00

[ 930s ] thds: 2 tps: 6.00 qps: 118.51 (r/w/o: 82.80/23.70/12.00) lat (ms,99%): 1050.76 err/s: 0.00 reconn/s: 0.00

[ 940s ] thds: 2 tps: 7.70 qps: 154.90 (r/w/o: 108.70/30.80/15.40) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 950s ] thds: 2 tps: 6.70 qps: 134.20 (r/w/o: 94.00/26.80/13.40) lat (ms,99%): 646.19 err/s: 0.00 reconn/s: 0.00

[ 960s ] thds: 2 tps: 7.50 qps: 149.01 (r/w/o: 104.00/30.00/15.00) lat (ms,99%): 520.62 err/s: 0.00 reconn/s: 0.00

[ 970s ] thds: 2 tps: 7.50 qps: 150.99 (r/w/o: 106.00/30.00/15.00) lat (ms,99%): 1170.65 err/s: 0.00 reconn/s: 0.00

[ 980s ] thds: 2 tps: 6.50 qps: 131.10 (r/w/o: 91.90/26.20/13.00) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 990s ] thds: 2 tps: 6.60 qps: 131.40 (r/w/o: 92.00/26.20/13.20) lat (ms,99%): 846.57 err/s: 0.00 reconn/s: 0.00

[ 1000s ] thds: 2 tps: 7.00 qps: 139.80 (r/w/o: 97.80/28.00/14.00) lat (ms,99%): 759.88 err/s: 0.00 reconn/s: 0.00

[ 1010s ] thds: 2 tps: 5.50 qps: 109.90 (r/w/o: 76.90/22.00/11.00) lat (ms,99%): 1771.29 err/s: 0.00 reconn/s: 0.00

[ 1020s ] thds: 2 tps: 4.70 qps: 94.10 (r/w/o: 65.90/18.80/9.40) lat (ms,99%): 2405.65 err/s: 0.00 reconn/s: 0.00

[ 1030s ] thds: 2 tps: 7.90 qps: 157.81 (r/w/o: 110.40/31.60/15.80) lat (ms,99%): 569.67 err/s: 0.00 reconn/s: 0.00

[ 1040s ] thds: 2 tps: 8.10 qps: 163.50 (r/w/o: 114.50/32.80/16.20) lat (ms,99%): 634.66 err/s: 0.00 reconn/s: 0.00

[ 1050s ] thds: 2 tps: 6.20 qps: 123.20 (r/w/o: 86.40/24.40/12.40) lat (ms,99%): 960.30 err/s: 0.00 reconn/s: 0.00

[ 1060s ] thds: 2 tps: 6.30 qps: 126.30 (r/w/o: 88.30/25.40/12.60) lat (ms,99%): 1191.92 err/s: 0.00 reconn/s: 0.00

[ 1070s ] thds: 2 tps: 8.20 qps: 162.40 (r/w/o: 113.40/32.60/16.40) lat (ms,99%): 502.20 err/s: 0.00 reconn/s: 0.00

[ 1080s ] thds: 2 tps: 7.50 qps: 151.20 (r/w/o: 106.00/30.20/15.00) lat (ms,99%): 569.67 err/s: 0.00 reconn/s: 0.00

[ 1090s ] thds: 2 tps: 6.20 qps: 122.50 (r/w/o: 85.50/24.60/12.40) lat (ms,99%): 1032.01 err/s: 0.00 reconn/s: 0.00

[ 1100s ] thds: 2 tps: 6.60 qps: 131.90 (r/w/o: 92.30/26.40/13.20) lat (ms,99%): 943.16 err/s: 0.00 reconn/s: 0.00

[ 1110s ] thds: 2 tps: 7.20 qps: 144.89 (r/w/o: 101.70/28.80/14.40) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 1120s ] thds: 2 tps: 7.70 qps: 154.11 (r/w/o: 107.90/30.80/15.40) lat (ms,99%): 511.33 err/s: 0.00 reconn/s: 0.00

[ 1130s ] thds: 2 tps: 5.70 qps: 114.20 (r/w/o: 79.80/23.00/11.40) lat (ms,99%): 1013.60 err/s: 0.00 reconn/s: 0.00

[ 1140s ] thds: 2 tps: 7.60 qps: 151.31 (r/w/o: 105.91/30.20/15.20) lat (ms,99%): 831.46 err/s: 0.00 reconn/s: 0.00

[ 1150s ] thds: 2 tps: 8.20 qps: 165.09 (r/w/o: 115.90/32.80/16.40) lat (ms,99%): 694.45 err/s: 0.00 reconn/s: 0.00

[ 1160s ] thds: 2 tps: 5.80 qps: 115.40 (r/w/o: 80.60/23.20/11.60) lat (ms,99%): 816.63 err/s: 0.00 reconn/s: 0.00

[ 1170s ] thds: 2 tps: 6.70 qps: 135.50 (r/w/o: 95.00/27.10/13.40) lat (ms,99%): 846.57 err/s: 0.00 reconn/s: 0.00

[ 1180s ] thds: 2 tps: 6.90 qps: 135.10 (r/w/o: 94.00/27.30/13.80) lat (ms,99%): 1129.24 err/s: 0.00 reconn/s: 0.00

[ 1190s ] thds: 2 tps: 6.10 qps: 123.21 (r/w/o: 86.60/24.40/12.20) lat (ms,99%): 877.61 err/s: 0.00 reconn/s: 0.00

[ 1200s ] thds: 2 tps: 6.40 qps: 127.80 (r/w/o: 89.40/25.60/12.80) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 1210s ] thds: 2 tps: 6.00 qps: 120.20 (r/w/o: 84.20/24.00/12.00) lat (ms,99%): 877.61 err/s: 0.00 reconn/s: 0.00

[ 1220s ] thds: 2 tps: 6.70 qps: 133.40 (r/w/o: 93.20/26.80/13.40) lat (ms,99%): 960.30 err/s: 0.00 reconn/s: 0.00

[ 1230s ] thds: 2 tps: 7.20 qps: 144.50 (r/w/o: 101.30/28.80/14.40) lat (ms,99%): 759.88 err/s: 0.00 reconn/s: 0.00

[ 1240s ] thds: 2 tps: 6.60 qps: 132.10 (r/w/o: 92.50/26.40/13.20) lat (ms,99%): 634.66 err/s: 0.00 reconn/s: 0.00

[ 1250s ] thds: 2 tps: 6.90 qps: 137.20 (r/w/o: 95.80/27.60/13.80) lat (ms,99%): 893.56 err/s: 0.00 reconn/s: 0.00

[ 1260s ] thds: 2 tps: 7.10 qps: 142.30 (r/w/o: 99.70/28.40/14.20) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 1270s ] thds: 2 tps: 7.50 qps: 150.50 (r/w/o: 105.50/30.00/15.00) lat (ms,99%): 787.74 err/s: 0.00 reconn/s: 0.00

[ 1280s ] thds: 2 tps: 7.20 qps: 143.70 (r/w/o: 100.50/28.80/14.40) lat (ms,99%): 590.56 err/s: 0.00 reconn/s: 0.00

[ 1290s ] thds: 2 tps: 7.20 qps: 145.20 (r/w/o: 102.00/28.80/14.40) lat (ms,99%): 877.61 err/s: 0.00 reconn/s: 0.00

[ 1300s ] thds: 2 tps: 6.60 qps: 132.61 (r/w/o: 92.80/26.60/13.20) lat (ms,99%): 694.45 err/s: 0.00 reconn/s: 0.00

[ 1310s ] thds: 2 tps: 6.20 qps: 122.00 (r/w/o: 85.00/24.60/12.40) lat (ms,99%): 995.51 err/s: 0.00 reconn/s: 0.00

[ 1320s ] thds: 2 tps: 5.70 qps: 114.30 (r/w/o: 80.10/22.80/11.40) lat (ms,99%): 995.51 err/s: 0.00 reconn/s: 0.00

[ 1330s ] thds: 2 tps: 6.90 qps: 137.80 (r/w/o: 96.40/27.60/13.80) lat (ms,99%): 926.33 err/s: 0.00 reconn/s: 0.00

[ 1340s ] thds: 2 tps: 7.20 qps: 143.09 (r/w/o: 99.90/28.80/14.40) lat (ms,99%): 623.33 err/s: 0.00 reconn/s: 0.00

[ 1350s ] thds: 2 tps: 7.10 qps: 143.10 (r/w/o: 100.50/28.40/14.20) lat (ms,99%): 943.16 err/s: 0.00 reconn/s: 0.00

[ 1360s ] thds: 2 tps: 7.70 qps: 155.70 (r/w/o: 109.30/31.00/15.40) lat (ms,99%): 539.71 err/s: 0.00 reconn/s: 0.00

[ 1370s ] thds: 2 tps: 7.30 qps: 145.10 (r/w/o: 101.50/29.00/14.60) lat (ms,99%): 977.74 err/s: 0.00 reconn/s: 0.00

[ 1380s ] thds: 2 tps: 7.20 qps: 144.50 (r/w/o: 101.10/29.00/14.40) lat (ms,99%): 646.19 err/s: 0.00 reconn/s: 0.00

[ 1390s ] thds: 2 tps: 7.50 qps: 149.40 (r/w/o: 104.60/29.80/15.00) lat (ms,99%): 646.19 err/s: 0.00 reconn/s: 0.00

[ 1400s ] thds: 2 tps: 7.60 qps: 151.30 (r/w/o: 105.70/30.40/15.20) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 1410s ] thds: 2 tps: 6.90 qps: 137.90 (r/w/o: 96.50/27.60/13.80) lat (ms,99%): 1013.60 err/s: 0.00 reconn/s: 0.00

[ 1420s ] thds: 2 tps: 6.80 qps: 135.30 (r/w/o: 94.50/27.20/13.60) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 1430s ] thds: 2 tps: 7.60 qps: 154.10 (r/w/o: 108.50/30.40/15.20) lat (ms,99%): 511.33 err/s: 0.00 reconn/s: 0.00

[ 1440s ] thds: 2 tps: 7.10 qps: 142.20 (r/w/o: 99.50/28.50/14.20) lat (ms,99%): 861.95 err/s: 0.00 reconn/s: 0.00

[ 1450s ] thds: 2 tps: 6.60 qps: 131.10 (r/w/o: 91.60/26.30/13.20) lat (ms,99%): 1149.76 err/s: 0.00 reconn/s: 0.00

[ 1460s ] thds: 2 tps: 7.20 qps: 144.60 (r/w/o: 101.20/29.00/14.40) lat (ms,99%): 601.29 err/s: 0.00 reconn/s: 0.00

[ 1470s ] thds: 2 tps: 7.90 qps: 156.79 (r/w/o: 109.60/31.40/15.80) lat (ms,99%): 458.96 err/s: 0.00 reconn/s: 0.00

[ 1480s ] thds: 2 tps: 7.00 qps: 141.01 (r/w/o: 99.00/28.00/14.00) lat (ms,99%): 559.50 err/s: 0.00 reconn/s: 0.00

[ 1490s ] thds: 2 tps: 7.00 qps: 139.90 (r/w/o: 97.80/28.10/14.00) lat (ms,99%): 877.61 err/s: 0.00 reconn/s: 0.00

[ 1500s ] thds: 2 tps: 6.10 qps: 120.90 (r/w/o: 84.40/24.30/12.20) lat (ms,99%): 926.33 err/s: 0.00 reconn/s: 0.00

[ 1510s ] thds: 2 tps: 7.50 qps: 150.30 (r/w/o: 105.30/30.00/15.00) lat (ms,99%): 816.63 err/s: 0.00 reconn/s: 0.00

[ 1520s ] thds: 2 tps: 6.20 qps: 125.30 (r/w/o: 88.10/24.80/12.40) lat (ms,99%): 861.95 err/s: 0.00 reconn/s: 0.00

[ 1530s ] thds: 2 tps: 7.00 qps: 138.80 (r/w/o: 96.80/28.00/14.00) lat (ms,99%): 1149.76 err/s: 0.00 reconn/s: 0.00

[ 1540s ] thds: 2 tps: 7.20 qps: 142.80 (r/w/o: 99.60/28.80/14.40) lat (ms,99%): 530.08 err/s: 0.00 reconn/s: 0.00

[ 1550s ] thds: 2 tps: 7.90 qps: 159.21 (r/w/o: 111.80/31.60/15.80) lat (ms,99%): 493.24 err/s: 0.00 reconn/s: 0.00

[ 1560s ] thds: 2 tps: 7.30 qps: 145.80 (r/w/o: 102.00/29.20/14.60) lat (ms,99%): 1013.60 err/s: 0.00 reconn/s: 0.00

[ 1570s ] thds: 2 tps: 7.50 qps: 150.90 (r/w/o: 105.70/30.20/15.00) lat (ms,99%): 861.95 err/s: 0.00 reconn/s: 0.00

[ 1580s ] thds: 2 tps: 7.60 qps: 151.20 (r/w/o: 105.80/30.20/15.20) lat (ms,99%): 569.67 err/s: 0.00 reconn/s: 0.00

[ 1590s ] thds: 2 tps: 7.00 qps: 140.79 (r/w/o: 98.79/28.00/14.00) lat (ms,99%): 569.67 err/s: 0.00 reconn/s: 0.00

[ 1600s ] thds: 2 tps: 5.10 qps: 101.81 (r/w/o: 71.20/20.40/10.20) lat (ms,99%): 1129.24 err/s: 0.00 reconn/s: 0.00

[ 1610s ] thds: 2 tps: 3.90 qps: 77.60 (r/w/o: 54.20/15.60/7.80) lat (ms,99%): 1678.14 err/s: 0.00 reconn/s: 0.00

[ 1620s ] thds: 2 tps: 2.80 qps: 55.80 (r/w/o: 39.00/11.20/5.60) lat (ms,99%): 2045.74 err/s: 0.00 reconn/s: 0.00

[ 1630s ] thds: 2 tps: 6.70 qps: 134.80 (r/w/o: 94.60/26.80/13.40) lat (ms,99%): 893.56 err/s: 0.00 reconn/s: 0.00

[ 1640s ] thds: 2 tps: 6.60 qps: 130.80 (r/w/o: 91.20/26.40/13.20) lat (ms,99%): 960.30 err/s: 0.00 reconn/s: 0.00

[ 1650s ] thds: 2 tps: 8.40 qps: 169.00 (r/w/o: 118.60/33.60/16.80) lat (ms,99%): 773.68 err/s: 0.00 reconn/s: 0.00

[ 1660s ] thds: 2 tps: 7.40 qps: 148.00 (r/w/o: 103.50/29.70/14.80) lat (ms,99%): 669.89 err/s: 0.00 reconn/s: 0.00

[ 1670s ] thds: 2 tps: 6.50 qps: 130.80 (r/w/o: 91.80/26.00/13.00) lat (ms,99%): 580.02 err/s: 0.00 reconn/s: 0.00

[ 1680s ] thds: 2 tps: 7.20 qps: 142.10 (r/w/o: 99.00/28.70/14.40) lat (ms,99%): 877.61 err/s: 0.00 reconn/s: 0.00

[ 1690s ] thds: 2 tps: 7.40 qps: 148.59 (r/w/o: 104.19/29.60/14.80) lat (ms,99%): 682.06 err/s: 0.00 reconn/s: 0.00

[ 1700s ] thds: 2 tps: 5.30 qps: 106.91 (r/w/o: 74.90/21.40/10.60) lat (ms,99%): 802.05 err/s: 0.00 reconn/s: 0.00

[ 1710s ] thds: 2 tps: 5.60 qps: 111.79 (r/w/o: 78.29/22.30/11.20) lat (ms,99%): 943.16 err/s: 0.00 reconn/s: 0.00

[ 1720s ] thds: 2 tps: 7.90 qps: 156.60 (r/w/o: 109.30/31.50/15.80) lat (ms,99%): 787.74 err/s: 0.00 reconn/s: 0.00

[ 1730s ] thds: 2 tps: 6.80 qps: 136.80 (r/w/o: 96.00/27.20/13.60) lat (ms,99%): 580.02 err/s: 0.00 reconn/s: 0.00

[ 1740s ] thds: 2 tps: 7.20 qps: 144.39 (r/w/o: 101.09/28.90/14.40) lat (ms,99%): 520.62 err/s: 0.00 reconn/s: 0.00

[ 1750s ] thds: 2 tps: 5.50 qps: 109.60 (r/w/o: 76.70/21.90/11.00) lat (ms,99%): 1235.62 err/s: 0.00 reconn/s: 0.00

[ 1760s ] thds: 2 tps: 3.30 qps: 66.70 (r/w/o: 46.90/13.20/6.60) lat (ms,99%): 2985.89 err/s: 0.00 reconn/s: 0.00

[ 1770s ] thds: 2 tps: 7.20 qps: 142.72 (r/w/o: 99.52/28.80/14.40) lat (ms,99%): 831.46 err/s: 0.00 reconn/s: 0.00

[ 1780s ] thds: 2 tps: 7.60 qps: 152.50 (r/w/o: 106.90/30.40/15.20) lat (ms,99%): 773.68 err/s: 0.00 reconn/s: 0.00

[ 1790s ] thds: 2 tps: 7.20 qps: 143.30 (r/w/o: 100.10/28.80/14.40) lat (ms,99%): 580.02 err/s: 0.00 reconn/s: 0.00

[ 1800s ] thds: 2 tps: 6.30 qps: 126.71 (r/w/o: 88.90/25.20/12.60) lat (ms,99%): 943.16 err/s: 0.00 reconn/s: 0.00

SQL statistics:

    queries performed:

        read:                            167258

        write:                           47788

        other:                           23894

        total:                           238940

    transactions:                        11947  (6.64 per sec.)

总共11947次事物,平均每秒6.64次

    queries:                             238940 (132.74 per sec.)

    ignored errors:                      0      (0.00 per sec.)

    reconnects:                          0      (0.00 per sec.)

 

General statistics:

    total time:                          1800.0792s

    total number of events:              11947

 

Latency (ms):

         min:                                  2.52最小事件时间

         avg:                                301.34

         max:                               2994.72

         99th percentile:                   1050.76

         sum:                            3600075.99

 

Threads fairness:

    events (avg/stddev):           5973.5000/0.50

    execution time (avg/stddev):   1800.0380/0.02

 

[root@mysqlcentos01 opt]#

[root@mysqlcentos01 opt]#

 

总结:

官方的sysbench是不支持--oltp_tables_count=10这个参数的,我们使用的是percona的分支,所以sysbench做oltp的测试并不是很完善,个人愿意用tpcc-mysql

 

 

 

对磁盘IO性能的测试:

创建初始化fileio文件:

[root@mysqlcentos01 ~]# sysbench --test=fileio --file-num=16 --file-total-size=2G prepare

WARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.

sysbench 1.0.9 (using bundled LuaJIT 2.1.0-beta2)

 

16 files, 131072Kb each, 2048Mb total

Creating files for the test...

Extra file open flags: 0

Creating file test_file.0

Creating file test_file.1

Creating file test_file.2

Creating file test_file.3

Creating file test_file.4

Creating file test_file.5

Creating file test_file.6

Creating file test_file.7

Creating file test_file.8

Creating file test_file.9

Creating file test_file.10

Creating file test_file.11

Creating file test_file.12

Creating file test_file.13

Creating file test_file.14

Creating file test_file.15

2147483648 bytes written in 2.85 seconds (718.41 MiB/sec).

[root@mysqlcentos01 ~]#

 

### Sysbench 对 MySQL 进行试的工作原理 #### 试参数配置 通过命令行指定多个参数来控制试行为。例如,在给定的命令中设置了线程数、表数量以及每张表的数据量等重要参数[^1]。 ```bash sysbench --threads=10 --tables=10 --table-size=100000 \ --rand-type=uniform --report-interval=1 --time=60 \ --mysql-user=root --mysql-password=root \ --mysql-socket=/data/mysql/db_zhumh/mysql.sock \ /usr/share/sysbench/oltp_read_write.lua run ``` 上述命令中的`--threads=10`指定了并发执行的试线程数目;而`--tables=10`定义了用于试的表格总数目,每个表含有`--table-size=100000`条记录。随机数据生成方式由`--rand-type=uniform`决定,意味着每次操作选取记录的方式遵循均匀分布规律。此外还设定了报告间隔时间(`--report-interval`)和整个试持续的时间长度(`--time`)。 #### 数据库连接设置 为了能够顺利访问目标MySQL实例,需要提供必要的认证信息如用户名密码(`--mysql-user`, `--mysql-password`),同时也需指出具体的套接字文件路径以便建立本地连接(`--mysql-socket`)。 #### 负载模式选择 采用OLTP(在线事务处理)读写混合负载脚本(`/usr/share/sysbench/oltp_read_write.lua`)作为模拟真实应用场景下的工作负荷模型。此Lua脚本内部实现了多种SQL查询语句组合,包括但不限于插入新纪录、更新现有字段值、删除特定条件匹配项以及检索满足一定约束的结果集等基本CRUD操作。 当运行该命令时,Sysbench会依据所设定的各项参数启动相应数量的工作进程或线程池,并按照预定义的概率权重循环调用不同类型的SQL指令向被数据库发起请求直至达到预定时限为止。期间定期输出性能统计摘要供后续分析评估之用。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值