MySQL基准测试之sysbench

Read

[root@DB1 tools]# wget https://github.com/akopytov/sysbench/archive/0.5.zip
[root@DB1 tools]# unzip sysbench-0.5.zip 
[root@DB1 tools]# yum install autoconf automake libtool
$ yum install m4 autoconf automake libtool
[root@DB1 sysbench-0.5]# ./autogen.sh 
[root@DB1 sysbench-0.5]# ./configure --with-<span class='keyword-inner'><a href="https://note.t4x.org/database/" title="database,mysql" target="_blank">MySQL</a></span>-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib
[root@DB1 db]# make && make install
[root@DB1 db]# pwd
/byrd/tools/sysbench-0.5/sysbench/tests/db
[root@DB1 db]# sysbench --test=cpu --cpu-max-prie=10000 run
sysbench: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory
[root@DB1 db]# ln -s /opt/mysql-5.7.16/lib/libmysqlclient.so.20 /usr/lib64/
[root@DB1 db]# sysbench --test=cpu --cpu-max-prie=10000 run   
General statistics:
    total time:                          13.9057s
    total number of events:              10000
    total time taken by event execution: 13.8733s
    response time:
         min:                                  1.22ms
         avg:                                  1.39ms
         max:                                  8.75ms
         approx.  95 percentile:               1.75ms

Threads fairness:
    events (avg/stddev):           10000.0000/0.00
    execution time (avg/stddev):   13.8733/0.00

[root@DB1 aa]# sysbench --test=fileio --file-total-size=2G prepare
2147483648 bytes written in 12.11 seconds (169.15 MB/sec).
[root@DB1 aa]# sysbench --test=fileio help
[root@DB1 aa]# sysbench --test=fileio --num-threads=8 --init-rng=on --file-total-size=2G --file-test-mode=rndrw --report-interval=1 run
Operations performed:  6003 reads, 3997 writes, 12800 Other = 22800 Total
Read 93.797Mb  Written 62.453Mb  Total transferred 156.25Mb  (8.9427Mb/sec)
  572.33 Requests/sec executed

General statistics:
    total time:                          17.4724s
    total number of events:              10000
    total time taken by event execution: 112.9210s
    response time:
         min:                                  0.01ms
         avg:                                 11.29ms
         max:                                600.92ms
         approx.  95 percentile:              84.17ms

Threads fairness:
    events (avg/stddev):           1250.0000/71.60
    execution time (avg/stddev):   14.1151/0.49

[root@DB1 tools]# wget https://github.com/akopytov/sysbench/archive/0.5.zip

[root@DB1 tools]# unzip sysbench-0.5.zip

[root@DB1 tools]# yum install autoconf automake libtool

$ yum install m4 autoconf automake libtool

[root@DB1 sysbench-0.5]# ./autogen.sh

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

[root@DB1 db]# make && make install

[root@DB1 db]# pwd

/byrd/tools/sysbench-0.5/sysbench/tests/db

[root@DB1 db]# sysbench --test=cpu --cpu-max-prie=10000 run

sysbench: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory

[root@DB1 db]# ln -s /opt/mysql-5.7.16/lib/libmysqlclient.so.20 /usr/lib64/

[root@DB1 db]# sysbench --test=cpu --cpu-max-prie=10000 run

General statistics:

total time: 13.9057s

total number of events: 10000

total time taken by event execution: 13.8733s

response time:

min: 1.22ms

avg: 1.39ms

max: 8.75ms

approx. 95 percentile: 1.75ms

Threads fairness:

events (avg/stddev): 10000.0000/0.00

execution time (avg/stddev): 13.8733/0.00

[root@DB1 aa]# sysbench --test=fileio --file-total-size=2G prepare

2147483648 bytes written in 12.11 seconds (169.15 MB/sec).

[root@DB1 aa]# sysbench --test=fileio help

[root@DB1 aa]# sysbench --test=fileio --num-threads=8 --init-rng=on --file-total-size=2G --file-test-mode=rndrw --report-interval=1 run

Operations performed: 6003 reads, 3997 writes, 12800 Other = 22800 Total

Read 93.797Mb Written 62.453Mb Total transferred 156.25Mb (8.9427Mb/sec)

572.33 Requests/sec executed

General statistics:

total time: 17.4724s

total number of events: 10000

total time taken by event execution: 112.9210s

response time:

min: 0.01ms

avg: 11.29ms

max: 600.92ms

approx. 95 percentile: 84.17ms

Threads fairness:

events (avg/stddev): 1250.0000/71.60

execution time (avg/stddev): 14.1151/0.49

mysql> create database abc;
Query OK, 1 row affected (0.16 sec)

mysql> grant all privileges on *.* to test@'localhost' identified by '123456';
Query OK, 0 rows affected, 2 warnings (0.20 sec)

[root@DB1 db]# sysbench --test=./oltp.lua --mysql-table-engine=innodb --oltp-table-size=10000 --mysql-db=abc --mysql-user=test --mysql-password=123456 --oltp-tables-count=10 --mysql-socker=/usr/local/mysql/tmp/mysql.sock prepare
sysbench 0.5:  multi-threaded system evaluation benchmark

Creating table 'sbtest1'...
Inserting 10000 records into 'sbtest1'
Creating secondary indexes on 'sbtest1'...
Creating table 'sbtest10'...
Inserting 10000 records into 'sbtest10'
Creating secondary indexes on 'sbtest10'...
mysql> select count(*) from sbtest1;  
+----------+
| count(*) |
+----------+
|    10000 |
+----------+
1 row in set (0.04 sec)

[root@DB1 db]# sysbench --test=./oltp.lua --mysql-table-engine=innodb --oltp-table-size=10000 --mysql-db=abc --mysql-user=test --mysql-password=123456 --oltp-tables-count=10 --mysql-socker=/usr/local/mysql/tmp/mysql.sock run
Initializing worker threads...

Threads started!

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           40000
        other:                           20000
        total:                           200000
    transactions:                        10000  (65.37 per sec.)
    read/write requests:                 180000 (1176.66 per sec.)
    other operations:                    20000  (130.74 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          152.9753s
    total number of events:              10000
    total time taken by event execution: 152.8901s
    response time:
         min:                                  6.36ms
         avg:                                 15.29ms
         max:                                475.18ms
         approx.  95 percentile:              40.06ms

Threads fairness:
    events (avg/stddev):           10000.0000/0.00
    execution time (avg/stddev):   152.8901/0.00

mysql> create database abc;

Query OK, 1 row affected (0.16 sec)

mysql> grant all privileges on *.* to test@'localhost' identified by '123456';

Query OK, 0 rows affected, 2 warnings (0.20 sec)

[root@DB1 db]# sysbench --test=./oltp.lua --mysql-table-engine=innodb --oltp-table-size=10000 --mysql-db=abc --mysql-user=test --mysql-password=123456 --oltp-tables-count=10 --mysql-socker=/usr/local/mysql/tmp/mysql.sock prepare

sysbench 0.5: multi-threaded system evaluation benchmark

Creating table 'sbtest1'...

Inserting 10000 records into 'sbtest1'

Creating secondary indexes on 'sbtest1'...

Creating table 'sbtest10'...

Inserting 10000 records into 'sbtest10'

Creating secondary indexes on 'sbtest10'...

mysql> select count(*) from sbtest1;

+----------+

| count(*) |

+----------+

| 10000 |

+----------+

1 row in set (0.04 sec)

Initializing worker threads...

Threads started!

OLTP test statistics:

queries performed:

write: 40000

other: 20000

total: 200000

transactions: 10000 (65.37 per sec.)

read/write requests: 180000 (1176.66 per sec.)

other operations: 20000 (130.74 per sec.)

ignored errors: 0 (0.00 per sec.)

reconnects: 0 (0.00 per sec.)

General statistics:

total time: 152.9753s

total number of events: 10000

total time taken by event execution: 152.8901s

response time:

min: 6.36ms

avg: 15.29ms

max: 475.18ms

approx. 95 percentile: 40.06ms

Threads fairness:

events (avg/stddev): 10000.0000/0.00

execution time (avg/stddev): 152.8901/0.00

$ wget https://github.com/akopytov/sysbench/archive/1.0.zip -O "sysbench-1.0.zip"
$ unzip sysbench-1.0.zip
$ cd sysbench-1.0
$ yum install automake libtool –y
$ ./autogen.sh
$ ./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib
$ make && make install
$ ln -s /usr/local/mysql/lib/libmysqlclient.so.20 /lib64/
$ sysbench --version                                     
sysbench 1.0.14
$ sysbench --test=./tests/include/oltp_legacy/oltp.lua
WARNING: the --test option is deprecated. You can pass a script name or path on the command line without any options.
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
$ sysbench ./tests/include/oltp_legacy/oltp.lua
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
####测试前,请建立在对应的mysql服务器建立sbtest的数据库####
$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.144 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=10 --time=120 --report-interval=10 prepare
####数据准备####
$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.144 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=10 --time=120 --report-interval=10 run >> /tmp/mysysbench.log
####测试结果####
$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.114 --mysql-port=3306 --mysql-user=root --mysql-password=admin cleanup
$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.114 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-tables-count=10 cleanup
####清理数据####

$ wget https://github.com/akopytov/sysbench/archive/1.0.zip -O "sysbench-1.0.zip"

$ unzip sysbench-1.0.zip

$ cd sysbench-1.0

$ yum install automake libtool –y

$ ./autogen.sh

$ ./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib

$ make && make install

$ ln -s /usr/local/mysql/lib/libmysqlclient.so.20 /lib64/

$ sysbench --version

sysbench 1.0.14

$ sysbench --test=./tests/include/oltp_legacy/oltp.lua

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

sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)

$ sysbench ./tests/include/oltp_legacy/oltp.lua

sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)

####测试前,请建立在对应的mysql服务器建立sbtest的数据库####

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.144 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=10 --time=120 --report-interval=10 prepare

####数据准备####

####测试结果####

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.114 --mysql-port=3306 --mysql-user=root --mysql-password=admin cleanup

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.114 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-tables-count=10 cleanup

####清理数据####

参数说明：

--oltp-test-mode：执行模式，包括simple、nontrx和complex，默认是complex。simple模式下只测试简单的查询；nontrx不仅测试查询，还测试插入更新等，但是不使用事务；complex模式下测试最全面，会测试增删改查，而且会使用事务。可以根据自己的需要选择测试模式。
--oltp-tables-count：测试的表数量，根据实际情况选择
--oltp-table-size：测试的表的大小，根据实际情况选择
--threads：客户端的并发连接数
--time：测试执行的时间，单位是秒，该值不要太短，可以选择120
--report-interval：生成报告的时间间隔，单位是秒，如10

--oltp-test-mode：执行模式，包括simple、nontrx和complex，默认是complex。simple模式下只测试简单的查询；nontrx不仅测试查询，还测试插入更新等，但是不使用事务；complex模式下测试最全面，会测试增删改查，而且会使用事务。可以根据自己的需要选择测试模式。

--oltp-tables-count：测试的表数量，根据实际情况选择

--oltp-table-size：测试的表的大小，根据实际情况选择

--threads：客户端的并发连接数

--time：测试执行的时间，单位是秒，该值不要太短，可以选择120

--report-interval：生成报告的时间间隔，单位是秒，如10

SourceByrd's Weblog-https://note.t4x.org/database/benchmark-test-sysbench/

生产测试：SourceByrd's Weblog-https://note.t4x.org/database/benchmark-test-sysbench/

3307 mysql-5.7.18

top - 16:04:34 up 145 days, 5:11, 2 users, load average: 13.76, 4.91, 3.56 Tasks: 122 total, 1 running, 121 sleeping, 0 stopped, 0 zombie %Cpu0 : 0.0 us, 0.3 sy, 0.0 ni, 99.3 id, 0.3 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu1 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu2 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu3 : 0.3 us, 0.0 sy, 0.0 ni, 99.7 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu4 : 0.3 us, 0.0 sy, 0.0 ni, 99.7 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu5 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu6 : 0.0 us, 0.3 sy, 0.0 ni, 91.3 id, 8.3 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu7 : 0.3 us, 0.3 sy, 0.0 ni, 98.3 id, 1.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 16267200 total, 408500 free, 1310660 used, 14548040 buff/cache KiB Swap: 0 total, 0 free, 0 used. 14588236 avail Mem

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

top - 16:04:34 up 145 days,  5:11,  2 users,  load average: 13.76, 4.91, 3.56
Tasks: 122 total,   1 running, 121 sleeping,   0 stopped,   0 zombie
%Cpu0  :  0.0 us,  0.3 sy,  0.0 ni, 99.3 id,  0.3 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu1  :  0.0 us,  0.0 sy,  0.0 ni,100.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu2  :  0.0 us,  0.0 sy,  0.0 ni,100.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu3  :  0.3 us,  0.0 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu4  :  0.3 us,  0.0 sy,  0.0 ni, 99.7 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu5  :  0.0 us,  0.0 sy,  0.0 ni,100.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu6  :  0.0 us,  0.3 sy,  0.0 ni, 91.3 id,  8.3 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu7  :  0.3 us,  0.3 sy,  0.0 ni, 98.3 id,  1.0 wa,  0.0 hi,  0.0 si,  0.0 st

KiB Mem : 16267200 total,   408500 free,  1310660 used, 14548040 buff/cache
KiB Swap:        0 total,        0 free,        0 used. 14588236 avail Mem

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.110 --mysql-port=3307 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=120 --time=120 --report-interval=10 run sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 120 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 10s ] thds: 120 tps: 501.69 qps: 10230.54 (r/w/o: 7189.88/2025.27/1015.39) lat (ms,95%): 484.44 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 994.89 qps: 19895.75 (r/w/o: 13927.49/3978.47/1989.78) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1084.97 qps: 21704.00 (r/w/o: 15190.88/4343.28/2169.84) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1109.18 qps: 22209.07 (r/w/o: 15530.00/4460.61/2218.46) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1109.77 qps: 22157.67 (r/w/o: 15532.12/4406.10/2219.45) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1112.68 qps: 22273.11 (r/w/o: 15582.23/4465.42/2225.46) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1087.15 qps: 21684.49 (r/w/o: 15175.96/4334.22/2174.31) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1065.20 qps: 21356.77 (r/w/o: 14939.05/4287.31/2130.41) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1069.54 qps: 21410.32 (r/w/o: 14990.00/4281.24/2139.07) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1100.10 qps: 21978.27 (r/w/o: 15383.28/4394.79/2200.20) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1102.31 qps: 22074.21 (r/w/o: 15451.25/4418.34/2204.62) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1090.72 qps: 21788.45 (r/w/o: 15270.04/4336.97/2181.43) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1741656 write: 497616 other: 248808 total: 2488080 transactions: 124404 (1034.71 per sec.) queries: 2488080 (20694.22 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2269s total number of events: 124404 Latency (ms): min: 28.85 avg: 115.80 max: 4325.06 95th percentile: 193.38 sum: 14406228.47 Threads fairness: events (avg/stddev): 1036.7000/10.61 execution time (avg/stddev): 120.0519/0.03 [ 10s ] thds: 120 tps: 724.64 qps: 14705.77 (r/w/o: 10310.28/2934.22/1461.27) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1092.68 qps: 21803.91 (r/w/o: 15275.53/4343.02/2185.36) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1106.84 qps: 22144.30 (r/w/o: 15492.56/4438.06/2213.68) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1123.65 qps: 22464.28 (r/w/o: 15715.59/4501.40/2247.30) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1122.11 qps: 22455.43 (r/w/o: 15728.39/4482.93/2244.11) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1135.23 qps: 22671.73 (r/w/o: 15863.74/4539.03/2268.96) lat (ms,95%): 170.48 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1121.33 qps: 22441.94 (r/w/o: 15725.47/4472.22/2244.25) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1046.77 qps: 20922.12 (r/w/o: 14632.79/4195.79/2093.54) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1130.70 qps: 22573.96 (r/w/o: 15803.44/4509.11/2261.41) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1091.37 qps: 21906.70 (r/w/o: 15338.08/4385.88/2182.74) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1115.83 qps: 22270.33 (r/w/o: 15585.04/4453.63/2231.66) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1101.23 qps: 21980.56 (r/w/o: 15379.49/4398.61/2202.45) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1809584 write: 517024 other: 258512 total: 2585120 transactions: 129256 (1074.73 per sec.) queries: 2585120 (21494.67 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2663s total number of events: 129256 Latency (ms): min: 28.48 avg: 111.50 max: 4328.88 95th percentile: 186.54 sum: 14411708.67 Threads fairness: events (avg/stddev): 1077.1333/13.46 execution time (avg/stddev): 120.0976/0.06 [ 10s ] thds: 120 tps: 715.63 qps: 14455.06 (r/w/o: 10148.42/2863.41/1443.23) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1114.99 qps: 22331.07 (r/w/o: 15632.31/4468.78/2229.98) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1085.37 qps: 21696.07 (r/w/o: 15170.83/4355.19/2170.05) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1113.54 qps: 22308.23 (r/w/o: 15626.01/4454.45/2227.77) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1084.01 qps: 21646.61 (r/w/o: 15153.47/4325.52/2167.61) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1098.91 qps: 21920.81 (r/w/o: 15320.46/4404.04/2196.32) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1072.52 qps: 21396.82 (r/w/o: 14975.12/4274.76/2146.93) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1052.51 qps: 21176.32 (r/w/o: 14850.15/4221.44/2104.72) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1054.19 qps: 20985.04 (r/w/o: 14665.32/4211.85/2107.87) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1033.86 qps: 20731.03 (r/w/o: 14517.86/4145.95/2067.22) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1070.58 qps: 21499.34 (r/w/o: 15051.55/4305.33/2142.47) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1119.97 qps: 22336.28 (r/w/o: 15656.54/4440.09/2239.65) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1767920 write: 505120 other: 252560 total: 2525600 transactions: 126280 (1050.27 per sec.) queries: 2525600 (21005.37 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2343s total number of events: 126280 Latency (ms): min: 27.15 avg: 114.09 max: 4205.80 95th percentile: 189.93 sum: 14407865.55 Threads fairness: events (avg/stddev): 1052.3333/10.99 execution time (avg/stddev): 120.0655/0.06 [ 10s ] thds: 120 tps: 967.68 qps: 19555.46 (r/w/o: 13705.21/3902.90/1947.35) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1211.97 qps: 24143.34 (r/w/o: 16900.41/4819.59/2423.35) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1269.18 qps: 25404.14 (r/w/o: 17787.05/5078.93/2538.16) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1497.62 qps: 29926.79 (r/w/o: 20943.47/5987.28/2996.04) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1442.09 qps: 28967.39 (r/w/o: 20271.36/5811.85/2884.18) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1517.23 qps: 30341.40 (r/w/o: 21240.05/6066.90/3034.45) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1532.91 qps: 30634.73 (r/w/o: 21453.09/6115.83/3065.81) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1565.99 qps: 31346.42 (r/w/o: 21932.50/6281.94/3131.97) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1530.75 qps: 30613.43 (r/w/o: 21431.82/6120.00/3061.60) lat (ms,95%): 127.81 err/s: 0.10 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1502.36 qps: 30027.92 (r/w/o: 21026.59/5996.62/3004.71) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1428.58 qps: 28593.02 (r/w/o: 20006.57/5729.30/2857.15) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1408.29 qps: 28141.96 (r/w/o: 19704.80/5620.57/2816.59) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2364208 write: 675486 other: 337743 total: 3377437 transactions: 168871 (1404.39 per sec.) queries: 3377437 (28087.89 per sec.) ignored errors: 1 (0.01 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2413s total number of events: 168871 Latency (ms): min: 27.16 avg: 85.32 max: 4618.14 95th percentile: 125.52 sum: 14407652.13 Threads fairness: events (avg/stddev): 1407.2583/19.71 execution time (avg/stddev): 120.0638/0.02 [ 10s ] thds: 120 tps: 947.66 qps: 19175.11 (r/w/o: 13434.97/3832.82/1907.32) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1550.36 qps: 30902.89 (r/w/o: 21635.94/6167.14/3099.82) lat (ms,95%): 114.72 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1471.70 qps: 29484.13 (r/w/o: 20641.85/5897.99/2944.29) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1551.19 qps: 31010.27 (r/w/o: 21707.51/6200.37/3102.39) lat (ms,95%): 116.80 err/s: 0.10 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1495.93 qps: 29922.25 (r/w/o: 20944.68/5985.61/2991.95) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1454.51 qps: 29088.90 (r/w/o: 20360.67/5819.22/2909.01) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1457.38 qps: 29138.75 (r/w/o: 20399.38/5825.21/2914.15) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1484.50 qps: 29714.60 (r/w/o: 20804.10/5940.90/2969.60) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1567.85 qps: 31348.18 (r/w/o: 21937.09/6275.80/3135.30) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1556.08 qps: 31092.20 (r/w/o: 21763.19/6216.44/3112.57) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1461.81 qps: 29227.92 (r/w/o: 20459.95/5844.94/2923.02) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1455.51 qps: 29212.57 (r/w/o: 20442.69/5858.25/2911.63) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2445324 write: 698661 other: 349331 total: 3493316 transactions: 174665 (1452.70 per sec.) queries: 3493316 (29054.15 per sec.) ignored errors: 1 (0.01 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2306s total number of events: 174665 Latency (ms): min: 28.25 avg: 82.46 max: 4539.16 95th percentile: 121.08 sum: 14402641.71 Threads fairness: events (avg/stddev): 1455.5417/17.66 execution time (avg/stddev): 120.0220/0.03

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.110 --mysql-port=3307 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=120 --time=120 --report-interval=10 run
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 120
Report intermediate results every 10 second(s)
Initializing random number generator from current time

Initializing worker threads...

Threads started!

[ 10s ] thds: 120 tps: 501.69 qps: 10230.54 (r/w/o: 7189.88/2025.27/1015.39) lat (ms,95%): 484.44 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 994.89 qps: 19895.75 (r/w/o: 13927.49/3978.47/1989.78) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1084.97 qps: 21704.00 (r/w/o: 15190.88/4343.28/2169.84) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1109.18 qps: 22209.07 (r/w/o: 15530.00/4460.61/2218.46) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1109.77 qps: 22157.67 (r/w/o: 15532.12/4406.10/2219.45) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1112.68 qps: 22273.11 (r/w/o: 15582.23/4465.42/2225.46) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1087.15 qps: 21684.49 (r/w/o: 15175.96/4334.22/2174.31) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1065.20 qps: 21356.77 (r/w/o: 14939.05/4287.31/2130.41) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1069.54 qps: 21410.32 (r/w/o: 14990.00/4281.24/2139.07) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1100.10 qps: 21978.27 (r/w/o: 15383.28/4394.79/2200.20) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1102.31 qps: 22074.21 (r/w/o: 15451.25/4418.34/2204.62) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1090.72 qps: 21788.45 (r/w/o: 15270.04/4336.97/2181.43) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1741656
        write:                           497616
        other:                           248808
        total:                           2488080
    transactions:                        124404 (1034.71 per sec.)
    queries:                             2488080 (20694.22 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2269s
    total number of events:              124404

Latency (ms):
         min:                                   28.85
         avg:                                  115.80
         max:                                 4325.06
         95th percentile:                      193.38
         sum:                             14406228.47

Threads fairness:
    events (avg/stddev):           1036.7000/10.61
    execution time (avg/stddev):   120.0519/0.03

[ 10s ] thds: 120 tps: 724.64 qps: 14705.77 (r/w/o: 10310.28/2934.22/1461.27) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1092.68 qps: 21803.91 (r/w/o: 15275.53/4343.02/2185.36) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1106.84 qps: 22144.30 (r/w/o: 15492.56/4438.06/2213.68) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1123.65 qps: 22464.28 (r/w/o: 15715.59/4501.40/2247.30) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1122.11 qps: 22455.43 (r/w/o: 15728.39/4482.93/2244.11) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1135.23 qps: 22671.73 (r/w/o: 15863.74/4539.03/2268.96) lat (ms,95%): 170.48 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1121.33 qps: 22441.94 (r/w/o: 15725.47/4472.22/2244.25) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1046.77 qps: 20922.12 (r/w/o: 14632.79/4195.79/2093.54) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1130.70 qps: 22573.96 (r/w/o: 15803.44/4509.11/2261.41) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1091.37 qps: 21906.70 (r/w/o: 15338.08/4385.88/2182.74) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1115.83 qps: 22270.33 (r/w/o: 15585.04/4453.63/2231.66) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1101.23 qps: 21980.56 (r/w/o: 15379.49/4398.61/2202.45) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1809584
        write:                           517024
        other:                           258512
        total:                           2585120
    transactions:                        129256 (1074.73 per sec.)
    queries:                             2585120 (21494.67 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2663s
    total number of events:              129256

Latency (ms):
         min:                                   28.48
         avg:                                  111.50
         max:                                 4328.88
         95th percentile:                      186.54
         sum:                             14411708.67

Threads fairness:
    events (avg/stddev):           1077.1333/13.46
    execution time (avg/stddev):   120.0976/0.06

[ 10s ] thds: 120 tps: 715.63 qps: 14455.06 (r/w/o: 10148.42/2863.41/1443.23) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1114.99 qps: 22331.07 (r/w/o: 15632.31/4468.78/2229.98) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1085.37 qps: 21696.07 (r/w/o: 15170.83/4355.19/2170.05) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1113.54 qps: 22308.23 (r/w/o: 15626.01/4454.45/2227.77) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1084.01 qps: 21646.61 (r/w/o: 15153.47/4325.52/2167.61) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1098.91 qps: 21920.81 (r/w/o: 15320.46/4404.04/2196.32) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1072.52 qps: 21396.82 (r/w/o: 14975.12/4274.76/2146.93) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1052.51 qps: 21176.32 (r/w/o: 14850.15/4221.44/2104.72) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1054.19 qps: 20985.04 (r/w/o: 14665.32/4211.85/2107.87) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1033.86 qps: 20731.03 (r/w/o: 14517.86/4145.95/2067.22) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1070.58 qps: 21499.34 (r/w/o: 15051.55/4305.33/2142.47) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1119.97 qps: 22336.28 (r/w/o: 15656.54/4440.09/2239.65) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1767920
        write:                           505120
        other:                           252560
        total:                           2525600
    transactions:                        126280 (1050.27 per sec.)
    queries:                             2525600 (21005.37 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2343s
    total number of events:              126280

Latency (ms):
         min:                                   27.15
         avg:                                  114.09
         max:                                 4205.80
         95th percentile:                      189.93
         sum:                             14407865.55

Threads fairness:
    events (avg/stddev):           1052.3333/10.99
    execution time (avg/stddev):   120.0655/0.06

[ 10s ] thds: 120 tps: 967.68 qps: 19555.46 (r/w/o: 13705.21/3902.90/1947.35) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1211.97 qps: 24143.34 (r/w/o: 16900.41/4819.59/2423.35) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1269.18 qps: 25404.14 (r/w/o: 17787.05/5078.93/2538.16) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1497.62 qps: 29926.79 (r/w/o: 20943.47/5987.28/2996.04) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1442.09 qps: 28967.39 (r/w/o: 20271.36/5811.85/2884.18) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1517.23 qps: 30341.40 (r/w/o: 21240.05/6066.90/3034.45) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1532.91 qps: 30634.73 (r/w/o: 21453.09/6115.83/3065.81) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1565.99 qps: 31346.42 (r/w/o: 21932.50/6281.94/3131.97) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1530.75 qps: 30613.43 (r/w/o: 21431.82/6120.00/3061.60) lat (ms,95%): 127.81 err/s: 0.10 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1502.36 qps: 30027.92 (r/w/o: 21026.59/5996.62/3004.71) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1428.58 qps: 28593.02 (r/w/o: 20006.57/5729.30/2857.15) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1408.29 qps: 28141.96 (r/w/o: 19704.80/5620.57/2816.59) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            2364208
        write:                           675486
        other:                           337743
        total:                           3377437
    transactions:                        168871 (1404.39 per sec.)
    queries:                             3377437 (28087.89 per sec.)
    ignored errors:                      1      (0.01 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2413s
    total number of events:              168871

Latency (ms):
         min:                                   27.16
         avg:                                   85.32
         max:                                 4618.14
         95th percentile:                      125.52
         sum:                             14407652.13

Threads fairness:
    events (avg/stddev):           1407.2583/19.71
    execution time (avg/stddev):   120.0638/0.02

[ 10s ] thds: 120 tps: 947.66 qps: 19175.11 (r/w/o: 13434.97/3832.82/1907.32) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1550.36 qps: 30902.89 (r/w/o: 21635.94/6167.14/3099.82) lat (ms,95%): 114.72 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1471.70 qps: 29484.13 (r/w/o: 20641.85/5897.99/2944.29) lat (ms,95%): 130.13 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1551.19 qps: 31010.27 (r/w/o: 21707.51/6200.37/3102.39) lat (ms,95%): 116.80 err/s: 0.10 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1495.93 qps: 29922.25 (r/w/o: 20944.68/5985.61/2991.95) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1454.51 qps: 29088.90 (r/w/o: 20360.67/5819.22/2909.01) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1457.38 qps: 29138.75 (r/w/o: 20399.38/5825.21/2914.15) lat (ms,95%): 127.81 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1484.50 qps: 29714.60 (r/w/o: 20804.10/5940.90/2969.60) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1567.85 qps: 31348.18 (r/w/o: 21937.09/6275.80/3135.30) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1556.08 qps: 31092.20 (r/w/o: 21763.19/6216.44/3112.57) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1461.81 qps: 29227.92 (r/w/o: 20459.95/5844.94/2923.02) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1455.51 qps: 29212.57 (r/w/o: 20442.69/5858.25/2911.63) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            2445324
        write:                           698661
        other:                           349331
        total:                           3493316
    transactions:                        174665 (1452.70 per sec.)
    queries:                             3493316 (29054.15 per sec.)
    ignored errors:                      1      (0.01 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2306s
    total number of events:              174665

Latency (ms):
         min:                                   28.25
         avg:                                   82.46
         max:                                 4539.16
         95th percentile:                      121.08
         sum:                             14402641.71

Threads fairness:
    events (avg/stddev):           1455.5417/17.66
    execution time (avg/stddev):   120.0220/0.03

3306 mysql-8.0.11

top - 17:02:00 up 145 days, 6:08, 2 users, load average: 16.33, 7.77, 5.46 Tasks: 122 total, 1 running, 121 sleeping, 0 stopped, 0 zombie %Cpu0 : 0.3 us, 0.0 sy, 0.0 ni, 97.0 id, 2.7 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu1 : 0.0 us, 0.3 sy, 0.0 ni, 92.0 id, 7.7 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu2 : 0.0 us, 0.0 sy, 0.0 ni, 99.0 id, 1.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu3 : 0.3 us, 0.0 sy, 0.0 ni, 99.3 id, 0.3 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu4 : 0.0 us, 0.0 sy, 0.0 ni,100.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu5 : 0.3 us, 0.0 sy, 0.0 ni, 98.7 id, 1.0 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu6 : 0.3 us, 0.7 sy, 0.0 ni, 80.3 id, 18.7 wa, 0.0 hi, 0.0 si, 0.0 st %Cpu7 : 0.7 us, 1.0 sy, 0.0 ni, 89.7 id, 8.7 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 16267200 total, 13417888 free, 1570128 used, 1279184 buff/cache KiB Swap: 0 total, 0 free, 0 used. 14330708 avail Mem

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

top - 17:02:00 up 145 days,  6:08,  2 users,  load average: 16.33, 7.77, 5.46
Tasks: 122 total,   1 running, 121 sleeping,   0 stopped,   0 zombie
%Cpu0  :  0.3 us,  0.0 sy,  0.0 ni, 97.0 id,  2.7 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu1  :  0.0 us,  0.3 sy,  0.0 ni, 92.0 id,  7.7 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu2  :  0.0 us,  0.0 sy,  0.0 ni, 99.0 id,  1.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu3  :  0.3 us,  0.0 sy,  0.0 ni, 99.3 id,  0.3 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu4  :  0.0 us,  0.0 sy,  0.0 ni,100.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu5  :  0.3 us,  0.0 sy,  0.0 ni, 98.7 id,  1.0 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu6  :  0.3 us,  0.7 sy,  0.0 ni, 80.3 id, 18.7 wa,  0.0 hi,  0.0 si,  0.0 st

%Cpu7  :  0.7 us,  1.0 sy,  0.0 ni, 89.7 id,  8.7 wa,  0.0 hi,  0.0 si,  0.0 st

KiB Mem : 16267200 total, 13417888 free,  1570128 used,  1279184 buff/cache
KiB Swap:        0 total,        0 free,        0 used. 14330708 avail Mem

# sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.110 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=120 --time=120 --report-interval=10 run sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 120 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 10s ] thds: 120 tps: 803.70 qps: 16190.28 (r/w/o: 11348.81/3222.38/1619.09) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1197.01 qps: 23987.93 (r/w/o: 16799.86/4793.75/2394.32) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1138.53 qps: 22762.20 (r/w/o: 15931.75/4553.40/2277.05) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1134.73 qps: 22707.54 (r/w/o: 15895.25/4542.83/2269.46) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1140.80 qps: 22789.97 (r/w/o: 15954.95/4553.41/2281.61) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1145.83 qps: 22923.81 (r/w/o: 16043.46/4588.70/2291.65) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1145.08 qps: 22890.88 (r/w/o: 16020.10/4580.61/2290.16) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1140.02 qps: 22848.24 (r/w/o: 15999.61/4568.59/2280.04) lat (ms,95%): 170.48 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1115.49 qps: 22293.12 (r/w/o: 15601.97/4460.16/2230.98) lat (ms,95%): 196.89 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1126.00 qps: 22499.60 (r/w/o: 15751.90/4495.70/2252.00) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1150.20 qps: 22987.26 (r/w/o: 16090.24/4596.61/2300.41) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1141.19 qps: 22837.64 (r/w/o: 15986.92/4568.35/2282.37) lat (ms,95%): 173.58 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1874698 write: 535628 other: 267814 total: 2678140 transactions: 133907 (1113.33 per sec.) queries: 2678140 (22266.64 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2718s total number of events: 133907 Latency (ms): min: 28.78 avg: 107.62 max: 4306.28 95th percentile: 186.54 sum: 14410528.60 Threads fairness: events (avg/stddev): 1115.8917/12.74 execution time (avg/stddev): 120.0877/0.03 [ 10s ] thds: 120 tps: 826.91 qps: 16647.06 (r/w/o: 11655.81/3326.73/1664.52) lat (ms,95%): 170.48 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1237.58 qps: 24782.98 (r/w/o: 17349.07/4958.74/2475.17) lat (ms,95%): 158.63 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1264.95 qps: 25269.89 (r/w/o: 17688.49/5051.50/2529.90) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1209.46 qps: 24112.29 (r/w/o: 16871.90/4822.06/2418.33) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1186.25 qps: 23780.29 (r/w/o: 16653.59/4753.10/2373.60) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1210.88 qps: 24227.30 (r/w/o: 16958.69/4847.34/2421.27) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1208.49 qps: 24272.90 (r/w/o: 16997.86/4856.76/2418.28) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1201.11 qps: 23939.45 (r/w/o: 16750.21/4788.23/2401.01) lat (ms,95%): 153.02 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1194.06 qps: 23864.48 (r/w/o: 16704.62/4772.53/2387.32) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1161.09 qps: 23147.63 (r/w/o: 16196.81/4629.55/2321.27) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1165.63 qps: 23464.26 (r/w/o: 16435.70/4696.50/2332.06) lat (ms,95%): 164.45 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1180.05 qps: 23530.18 (r/w/o: 16468.04/4700.95/2361.19) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1968498 write: 562428 other: 281214 total: 2812140 transactions: 140607 (1169.37 per sec.) queries: 2812140 (23387.48 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2372s total number of events: 140607 Latency (ms): min: 28.96 avg: 102.48 max: 4316.88 95th percentile: 161.51 sum: 14408791.61 Threads fairness: events (avg/stddev): 1171.7250/12.37 execution time (avg/stddev): 120.0733/0.05 [ 10s ] thds: 120 tps: 793.26 qps: 16014.47 (r/w/o: 11235.14/3180.82/1598.51) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1299.92 qps: 25956.56 (r/w/o: 18162.52/5194.19/2599.85) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1186.97 qps: 23792.09 (r/w/o: 16662.00/4756.06/2374.03) lat (ms,95%): 186.54 err/s: 0.10 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1186.00 qps: 23730.40 (r/w/o: 16609.40/4749.10/2371.90) lat (ms,95%): 164.45 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1165.04 qps: 23267.35 (r/w/o: 16281.69/4656.67/2328.99) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1218.10 qps: 24371.27 (r/w/o: 17065.25/4868.61/2437.41) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1171.00 qps: 23397.86 (r/w/o: 16372.58/4683.59/2341.70) lat (ms,95%): 179.94 err/s: 0.10 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1203.09 qps: 24111.22 (r/w/o: 16881.27/4823.36/2406.58) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1176.49 qps: 23501.15 (r/w/o: 16458.83/4689.35/2352.98) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1216.62 qps: 24327.02 (r/w/o: 17014.39/4879.58/2433.04) lat (ms,95%): 139.85 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1129.67 qps: 22568.12 (r/w/o: 15800.12/4508.47/2259.53) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1135.24 qps: 22820.03 (r/w/o: 15967.08/4582.47/2270.48) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1945188 write: 555764 other: 277882 total: 2778834 transactions: 138940 (1154.93 per sec.) queries: 2778834 (23098.95 per sec.) ignored errors: 2 (0.02 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2968s total number of events: 138940 Latency (ms): min: 28.64 avg: 103.72 max: 4784.91 95th percentile: 176.73 sum: 14410414.43 Threads fairness: events (avg/stddev): 1157.8333/13.19 execution time (avg/stddev): 120.0868/0.03 [ 10s ] thds: 120 tps: 890.36 qps: 18034.14 (r/w/o: 12632.92/3608.51/1792.71) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1068.33 qps: 21363.83 (r/w/o: 14956.57/4270.61/2136.65) lat (ms,95%): 204.11 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1058.84 qps: 21159.88 (r/w/o: 14813.25/4228.96/2117.68) lat (ms,95%): 204.11 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1225.19 qps: 24515.64 (r/w/o: 17163.19/4902.07/2450.38) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1206.46 qps: 24135.22 (r/w/o: 16890.28/4832.02/2412.91) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1215.73 qps: 24315.99 (r/w/o: 17020.39/4864.14/2431.47) lat (ms,95%): 153.02 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1176.04 qps: 23522.60 (r/w/o: 16465.89/4704.54/2352.17) lat (ms,95%): 183.21 err/s: 0.10 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1199.00 qps: 23978.87 (r/w/o: 16785.98/4794.89/2398.00) lat (ms,95%): 150.29 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1162.37 qps: 23243.81 (r/w/o: 16273.12/4645.96/2324.73) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1167.83 qps: 23361.44 (r/w/o: 16349.64/4676.13/2335.66) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1129.95 qps: 22598.12 (r/w/o: 15819.24/4518.98/2259.89) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1175.94 qps: 23503.77 (r/w/o: 16458.04/4693.85/2351.88) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1916390 write: 547538 other: 273769 total: 2737697 transactions: 136884 (1138.45 per sec.) queries: 2737697 (22769.16 per sec.) ignored errors: 1 (0.01 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2354s total number of events: 136884 Latency (ms): min: 29.56 avg: 105.27 max: 4442.04 95th percentile: 189.93 sum: 14410458.61 Threads fairness: events (avg/stddev): 1140.7000/14.40 execution time (avg/stddev): 120.0872/0.04 [ 10s ] thds: 120 tps: 830.03 qps: 16820.01 (r/w/o: 11787.16/3360.80/1672.05) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1134.53 qps: 22651.85 (r/w/o: 15861.96/4520.83/2269.06) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1318.75 qps: 26267.05 (r/w/o: 18374.23/5256.31/2636.51) lat (ms,95%): 132.49 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1237.17 qps: 24896.50 (r/w/o: 17431.45/4989.70/2475.35) lat (ms,95%): 137.35 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1276.61 qps: 25491.89 (r/w/o: 17849.00/5089.66/2553.23) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1211.32 qps: 24260.13 (r/w/o: 16981.83/4855.57/2422.73) lat (ms,95%): 130.13 err/s: 0.10 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1249.42 qps: 24977.92 (r/w/o: 17486.69/4992.38/2498.84) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1242.70 qps: 24841.85 (r/w/o: 17396.84/4959.61/2485.41) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1208.82 qps: 24188.44 (r/w/o: 16924.41/4846.39/2417.64) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1172.07 qps: 23345.22 (r/w/o: 16340.52/4662.16/2342.53) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1197.75 qps: 23996.50 (r/w/o: 16803.03/4796.38/2397.09) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1196.81 qps: 23991.02 (r/w/o: 16783.25/4814.15/2393.62) lat (ms,95%): 173.58 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2000390 write: 571538 other: 285769 total: 2857697 transactions: 142884 (1188.25 per sec.) queries: 2857697 (23765.16 per sec.) ignored errors: 1 (0.01 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2431s total number of events: 142884 Latency (ms): min: 29.59 avg: 100.83 max: 4464.45 95th percentile: 144.97 sum: 14406408.51 Threads fairness: events (avg/stddev): 1190.7000/14.89 execution time (avg/stddev): 120.0534/0.04

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203

# sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.110 --mysql-port=3306 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=120 --time=120 --report-interval=10 run
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 120
Report intermediate results every 10 second(s)
Initializing random number generator from current time

Initializing worker threads...

Threads started!

[ 10s ] thds: 120 tps: 803.70 qps: 16190.28 (r/w/o: 11348.81/3222.38/1619.09) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1197.01 qps: 23987.93 (r/w/o: 16799.86/4793.75/2394.32) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1138.53 qps: 22762.20 (r/w/o: 15931.75/4553.40/2277.05) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1134.73 qps: 22707.54 (r/w/o: 15895.25/4542.83/2269.46) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1140.80 qps: 22789.97 (r/w/o: 15954.95/4553.41/2281.61) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1145.83 qps: 22923.81 (r/w/o: 16043.46/4588.70/2291.65) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1145.08 qps: 22890.88 (r/w/o: 16020.10/4580.61/2290.16) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1140.02 qps: 22848.24 (r/w/o: 15999.61/4568.59/2280.04) lat (ms,95%): 170.48 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1115.49 qps: 22293.12 (r/w/o: 15601.97/4460.16/2230.98) lat (ms,95%): 196.89 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1126.00 qps: 22499.60 (r/w/o: 15751.90/4495.70/2252.00) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1150.20 qps: 22987.26 (r/w/o: 16090.24/4596.61/2300.41) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1141.19 qps: 22837.64 (r/w/o: 15986.92/4568.35/2282.37) lat (ms,95%): 173.58 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1874698
        write:                           535628
        other:                           267814
        total:                           2678140
    transactions:                        133907 (1113.33 per sec.)
    queries:                             2678140 (22266.64 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2718s
    total number of events:              133907

Latency (ms):
         min:                                   28.78
         avg:                                  107.62
         max:                                 4306.28
         95th percentile:                      186.54
         sum:                             14410528.60

Threads fairness:
    events (avg/stddev):           1115.8917/12.74
    execution time (avg/stddev):   120.0877/0.03

[ 10s ] thds: 120 tps: 826.91 qps: 16647.06 (r/w/o: 11655.81/3326.73/1664.52) lat (ms,95%): 170.48 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1237.58 qps: 24782.98 (r/w/o: 17349.07/4958.74/2475.17) lat (ms,95%): 158.63 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1264.95 qps: 25269.89 (r/w/o: 17688.49/5051.50/2529.90) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1209.46 qps: 24112.29 (r/w/o: 16871.90/4822.06/2418.33) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1186.25 qps: 23780.29 (r/w/o: 16653.59/4753.10/2373.60) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1210.88 qps: 24227.30 (r/w/o: 16958.69/4847.34/2421.27) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1208.49 qps: 24272.90 (r/w/o: 16997.86/4856.76/2418.28) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1201.11 qps: 23939.45 (r/w/o: 16750.21/4788.23/2401.01) lat (ms,95%): 153.02 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1194.06 qps: 23864.48 (r/w/o: 16704.62/4772.53/2387.32) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1161.09 qps: 23147.63 (r/w/o: 16196.81/4629.55/2321.27) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1165.63 qps: 23464.26 (r/w/o: 16435.70/4696.50/2332.06) lat (ms,95%): 164.45 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1180.05 qps: 23530.18 (r/w/o: 16468.04/4700.95/2361.19) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1968498
        write:                           562428
        other:                           281214
        total:                           2812140
    transactions:                        140607 (1169.37 per sec.)
    queries:                             2812140 (23387.48 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2372s
    total number of events:              140607

Latency (ms):
         min:                                   28.96
         avg:                                  102.48
         max:                                 4316.88
         95th percentile:                      161.51
         sum:                             14408791.61

Threads fairness:
    events (avg/stddev):           1171.7250/12.37
    execution time (avg/stddev):   120.0733/0.05

[ 10s ] thds: 120 tps: 793.26 qps: 16014.47 (r/w/o: 11235.14/3180.82/1598.51) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1299.92 qps: 25956.56 (r/w/o: 18162.52/5194.19/2599.85) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1186.97 qps: 23792.09 (r/w/o: 16662.00/4756.06/2374.03) lat (ms,95%): 186.54 err/s: 0.10 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1186.00 qps: 23730.40 (r/w/o: 16609.40/4749.10/2371.90) lat (ms,95%): 164.45 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1165.04 qps: 23267.35 (r/w/o: 16281.69/4656.67/2328.99) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1218.10 qps: 24371.27 (r/w/o: 17065.25/4868.61/2437.41) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1171.00 qps: 23397.86 (r/w/o: 16372.58/4683.59/2341.70) lat (ms,95%): 179.94 err/s: 0.10 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1203.09 qps: 24111.22 (r/w/o: 16881.27/4823.36/2406.58) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1176.49 qps: 23501.15 (r/w/o: 16458.83/4689.35/2352.98) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1216.62 qps: 24327.02 (r/w/o: 17014.39/4879.58/2433.04) lat (ms,95%): 139.85 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1129.67 qps: 22568.12 (r/w/o: 15800.12/4508.47/2259.53) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1135.24 qps: 22820.03 (r/w/o: 15967.08/4582.47/2270.48) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1945188
        write:                           555764
        other:                           277882
        total:                           2778834
    transactions:                        138940 (1154.93 per sec.)
    queries:                             2778834 (23098.95 per sec.)
    ignored errors:                      2      (0.02 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2968s
    total number of events:              138940

Latency (ms):
         min:                                   28.64
         avg:                                  103.72
         max:                                 4784.91
         95th percentile:                      176.73
         sum:                             14410414.43

Threads fairness:
    events (avg/stddev):           1157.8333/13.19
    execution time (avg/stddev):   120.0868/0.03

[ 10s ] thds: 120 tps: 890.36 qps: 18034.14 (r/w/o: 12632.92/3608.51/1792.71) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1068.33 qps: 21363.83 (r/w/o: 14956.57/4270.61/2136.65) lat (ms,95%): 204.11 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1058.84 qps: 21159.88 (r/w/o: 14813.25/4228.96/2117.68) lat (ms,95%): 204.11 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1225.19 qps: 24515.64 (r/w/o: 17163.19/4902.07/2450.38) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1206.46 qps: 24135.22 (r/w/o: 16890.28/4832.02/2412.91) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1215.73 qps: 24315.99 (r/w/o: 17020.39/4864.14/2431.47) lat (ms,95%): 153.02 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1176.04 qps: 23522.60 (r/w/o: 16465.89/4704.54/2352.17) lat (ms,95%): 183.21 err/s: 0.10 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1199.00 qps: 23978.87 (r/w/o: 16785.98/4794.89/2398.00) lat (ms,95%): 150.29 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1162.37 qps: 23243.81 (r/w/o: 16273.12/4645.96/2324.73) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1167.83 qps: 23361.44 (r/w/o: 16349.64/4676.13/2335.66) lat (ms,95%): 176.73 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1129.95 qps: 22598.12 (r/w/o: 15819.24/4518.98/2259.89) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1175.94 qps: 23503.77 (r/w/o: 16458.04/4693.85/2351.88) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            1916390
        write:                           547538
        other:                           273769
        total:                           2737697
    transactions:                        136884 (1138.45 per sec.)
    queries:                             2737697 (22769.16 per sec.)
    ignored errors:                      1      (0.01 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2354s
    total number of events:              136884

Latency (ms):
         min:                                   29.56
         avg:                                  105.27
         max:                                 4442.04
         95th percentile:                      189.93
         sum:                             14410458.61

Threads fairness:
    events (avg/stddev):           1140.7000/14.40
    execution time (avg/stddev):   120.0872/0.04

[ 10s ] thds: 120 tps: 830.03 qps: 16820.01 (r/w/o: 11787.16/3360.80/1672.05) lat (ms,95%): 186.54 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1134.53 qps: 22651.85 (r/w/o: 15861.96/4520.83/2269.06) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1318.75 qps: 26267.05 (r/w/o: 18374.23/5256.31/2636.51) lat (ms,95%): 132.49 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1237.17 qps: 24896.50 (r/w/o: 17431.45/4989.70/2475.35) lat (ms,95%): 137.35 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1276.61 qps: 25491.89 (r/w/o: 17849.00/5089.66/2553.23) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1211.32 qps: 24260.13 (r/w/o: 16981.83/4855.57/2422.73) lat (ms,95%): 130.13 err/s: 0.10 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1249.42 qps: 24977.92 (r/w/o: 17486.69/4992.38/2498.84) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1242.70 qps: 24841.85 (r/w/o: 17396.84/4959.61/2485.41) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1208.82 qps: 24188.44 (r/w/o: 16924.41/4846.39/2417.64) lat (ms,95%): 134.90 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1172.07 qps: 23345.22 (r/w/o: 16340.52/4662.16/2342.53) lat (ms,95%): 189.93 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1197.75 qps: 23996.50 (r/w/o: 16803.03/4796.38/2397.09) lat (ms,95%): 179.94 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1196.81 qps: 23991.02 (r/w/o: 16783.25/4814.15/2393.62) lat (ms,95%): 173.58 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            2000390
        write:                           571538
        other:                           285769
        total:                           2857697
    transactions:                        142884 (1188.25 per sec.)
    queries:                             2857697 (23765.16 per sec.)
    ignored errors:                      1      (0.01 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2431s
    total number of events:              142884

Latency (ms):
         min:                                   29.59
         avg:                                  100.83
         max:                                 4464.45
         95th percentile:                      144.97
         sum:                             14406408.51

Threads fairness:
    events (avg/stddev):           1190.7000/14.89
    execution time (avg/stddev):   120.0534/0.04

pxc单台 5.7.21-rel20-29.26.1.Linux.x86_64.ssl101

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.110 --mysql-port=3308 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=120 --time=120 --report-interval=10 run sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 120 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 10s ] thds: 120 tps: 1212.87 qps: 24383.29 (r/w/o: 17081.80/4864.16/2437.33) lat (ms,95%): 97.55 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1351.57 qps: 27013.89 (r/w/o: 18910.57/5400.38/2702.94) lat (ms,95%): 215.44 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1398.56 qps: 27973.31 (r/w/o: 19583.35/5593.34/2796.62) lat (ms,95%): 204.11 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1307.89 qps: 26265.58 (r/w/o: 18384.64/5264.06/2616.88) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1556.18 qps: 31043.13 (r/w/o: 21732.57/6198.31/3112.25) lat (ms,95%): 147.61 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1665.67 qps: 33319.99 (r/w/o: 23322.85/6666.20/3330.95) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1587.62 qps: 31728.01 (r/w/o: 22210.29/6342.58/3175.14) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1245.78 qps: 24922.44 (r/w/o: 17443.98/4986.81/2491.65) lat (ms,95%): 121.08 err/s: 0.10 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1617.87 qps: 32403.87 (r/w/o: 22682.66/6484.98/3236.24) lat (ms,95%): 139.85 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1647.55 qps: 32924.93 (r/w/o: 23051.75/6578.19/3294.99) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1697.57 qps: 33937.30 (r/w/o: 23754.75/6787.20/3395.35) lat (ms,95%): 130.13 err/s: 0.10 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1188.75 qps: 23785.86 (r/w/o: 16651.14/4757.61/2377.11) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2448656 write: 699611 other: 349806 total: 3498073 transactions: 174902 (1454.43 per sec.) queries: 3498073 (29088.90 per sec.) ignored errors: 2 (0.02 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2504s total number of events: 174902 Latency (ms): min: 26.29 avg: 82.40 max: 4212.71 95th percentile: 147.61 sum: 14411899.54 Threads fairness: events (avg/stddev): 1457.5167/23.28 execution time (avg/stddev): 120.0992/0.07 [ 10s ] thds: 120 tps: 1193.81 qps: 24102.07 (r/w/o: 16881.32/4821.13/2399.62) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1783.22 qps: 35659.69 (r/w/o: 24965.07/7128.18/3566.44) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1747.10 qps: 34949.62 (r/w/o: 24460.74/6994.58/3494.29) lat (ms,95%): 132.49 err/s: 0.10 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1272.19 qps: 25441.96 (r/w/o: 17810.70/5086.87/2544.39) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1731.36 qps: 34627.89 (r/w/o: 24239.10/6926.06/3462.73) lat (ms,95%): 114.72 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1773.52 qps: 35470.71 (r/w/o: 24829.22/7094.46/3547.03) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1644.03 qps: 32861.53 (r/w/o: 23013.27/6560.21/3288.05) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1407.78 qps: 28097.75 (r/w/o: 19667.26/5614.93/2815.56) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1741.43 qps: 34818.54 (r/w/o: 24372.85/6963.43/3482.26) lat (ms,95%): 137.35 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1758.44 qps: 35153.29 (r/w/o: 24605.92/7030.28/3517.09) lat (ms,95%): 137.35 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1146.71 qps: 22941.26 (r/w/o: 16065.68/4581.85/2293.73) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1828.28 qps: 36582.62 (r/w/o: 25603.13/7322.92/3656.56) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2665600 write: 761598 other: 380799 total: 3807997 transactions: 190399 (1583.72 per sec.) queries: 3807997 (31674.61 per sec.) ignored errors: 1 (0.01 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2180s total number of events: 190399 Latency (ms): min: 27.24 avg: 75.67 max: 4435.08 95th percentile: 123.28 sum: 14406679.93 Threads fairness: events (avg/stddev): 1586.6583/24.19 execution time (avg/stddev): 120.0557/0.05 [ 10s ] thds: 120 tps: 1293.74 qps: 26012.63 (r/w/o: 18230.39/5183.06/2599.17) lat (ms,95%): 106.75 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 120 tps: 1834.39 qps: 36683.64 (r/w/o: 25672.72/7342.05/3668.87) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 120 tps: 1731.78 qps: 34628.43 (r/w/o: 24240.17/6925.51/3462.75) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 120 tps: 1257.51 qps: 25236.16 (r/w/o: 17668.41/5051.73/2516.02) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 120 tps: 1742.38 qps: 34853.20 (r/w/o: 24393.25/6975.20/3484.75) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 120 tps: 1677.49 qps: 33558.01 (r/w/o: 23484.80/6718.24/3354.97) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 120 tps: 1475.44 qps: 29508.74 (r/w/o: 20656.12/5901.75/2950.87) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 120 tps: 1463.28 qps: 29263.31 (r/w/o: 20487.33/5849.32/2926.66) lat (ms,95%): 130.13 err/s: 0.10 reconn/s: 0.00 [ 90s ] thds: 120 tps: 1754.86 qps: 35092.54 (r/w/o: 24568.07/7014.75/3509.72) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 120 tps: 1745.17 qps: 34912.78 (r/w/o: 24432.36/6990.08/3490.34) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 120 tps: 1182.51 qps: 23535.16 (r/w/o: 16478.01/4693.13/2364.02) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 120 tps: 1757.27 qps: 35195.68 (r/w/o: 24641.33/7039.10/3515.25) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2650060 write: 757158 other: 378579 total: 3785797 transactions: 189289 (1573.76 per sec.) queries: 3785797 (31475.36 per sec.) ignored errors: 1 (0.01 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.2740s total number of events: 189289 Latency (ms): min: 26.19 avg: 76.13 max: 3940.34 95th percentile: 121.08 sum: 14411145.53 Threads fairness: events (avg/stddev): 1577.4083/21.95 execution time (avg/stddev): 120.0929/0.08

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125

$ sysbench ./tests/include/oltp_legacy/oltp.lua --mysql-host=1.1.1.110 --mysql-port=3308 --mysql-user=root --mysql-password=admin --oltp-test-mode=complex --oltp-tables-count=10 --oltp-table-size=100000 --threads=120 --time=120 --report-interval=10 run
sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 120
Report intermediate results every 10 second(s)
Initializing random number generator from current time

Initializing worker threads...

Threads started!

[ 10s ] thds: 120 tps: 1212.87 qps: 24383.29 (r/w/o: 17081.80/4864.16/2437.33) lat (ms,95%): 97.55 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1351.57 qps: 27013.89 (r/w/o: 18910.57/5400.38/2702.94) lat (ms,95%): 215.44 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1398.56 qps: 27973.31 (r/w/o: 19583.35/5593.34/2796.62) lat (ms,95%): 204.11 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1307.89 qps: 26265.58 (r/w/o: 18384.64/5264.06/2616.88) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1556.18 qps: 31043.13 (r/w/o: 21732.57/6198.31/3112.25) lat (ms,95%): 147.61 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1665.67 qps: 33319.99 (r/w/o: 23322.85/6666.20/3330.95) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1587.62 qps: 31728.01 (r/w/o: 22210.29/6342.58/3175.14) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1245.78 qps: 24922.44 (r/w/o: 17443.98/4986.81/2491.65) lat (ms,95%): 121.08 err/s: 0.10 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1617.87 qps: 32403.87 (r/w/o: 22682.66/6484.98/3236.24) lat (ms,95%): 139.85 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1647.55 qps: 32924.93 (r/w/o: 23051.75/6578.19/3294.99) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1697.57 qps: 33937.30 (r/w/o: 23754.75/6787.20/3395.35) lat (ms,95%): 130.13 err/s: 0.10 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1188.75 qps: 23785.86 (r/w/o: 16651.14/4757.61/2377.11) lat (ms,95%): 183.21 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            2448656
        write:                           699611
        other:                           349806
        total:                           3498073
    transactions:                        174902 (1454.43 per sec.)
    queries:                             3498073 (29088.90 per sec.)
    ignored errors:                      2      (0.02 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2504s
    total number of events:              174902

Latency (ms):
         min:                                   26.29
         avg:                                   82.40
         max:                                 4212.71
         95th percentile:                      147.61
         sum:                             14411899.54

Threads fairness:
    events (avg/stddev):           1457.5167/23.28
    execution time (avg/stddev):   120.0992/0.07

[ 10s ] thds: 120 tps: 1193.81 qps: 24102.07 (r/w/o: 16881.32/4821.13/2399.62) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1783.22 qps: 35659.69 (r/w/o: 24965.07/7128.18/3566.44) lat (ms,95%): 116.80 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1747.10 qps: 34949.62 (r/w/o: 24460.74/6994.58/3494.29) lat (ms,95%): 132.49 err/s: 0.10 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1272.19 qps: 25441.96 (r/w/o: 17810.70/5086.87/2544.39) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1731.36 qps: 34627.89 (r/w/o: 24239.10/6926.06/3462.73) lat (ms,95%): 114.72 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1773.52 qps: 35470.71 (r/w/o: 24829.22/7094.46/3547.03) lat (ms,95%): 125.52 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1644.03 qps: 32861.53 (r/w/o: 23013.27/6560.21/3288.05) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1407.78 qps: 28097.75 (r/w/o: 19667.26/5614.93/2815.56) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1741.43 qps: 34818.54 (r/w/o: 24372.85/6963.43/3482.26) lat (ms,95%): 137.35 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1758.44 qps: 35153.29 (r/w/o: 24605.92/7030.28/3517.09) lat (ms,95%): 137.35 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1146.71 qps: 22941.26 (r/w/o: 16065.68/4581.85/2293.73) lat (ms,95%): 200.47 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1828.28 qps: 36582.62 (r/w/o: 25603.13/7322.92/3656.56) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            2665600
        write:                           761598
        other:                           380799
        total:                           3807997
    transactions:                        190399 (1583.72 per sec.)
    queries:                             3807997 (31674.61 per sec.)
    ignored errors:                      1      (0.01 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2180s
    total number of events:              190399

Latency (ms):
         min:                                   27.24
         avg:                                   75.67
         max:                                 4435.08
         95th percentile:                      123.28
         sum:                             14406679.93

Threads fairness:
    events (avg/stddev):           1586.6583/24.19
    execution time (avg/stddev):   120.0557/0.05

[ 10s ] thds: 120 tps: 1293.74 qps: 26012.63 (r/w/o: 18230.39/5183.06/2599.17) lat (ms,95%): 106.75 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 120 tps: 1834.39 qps: 36683.64 (r/w/o: 25672.72/7342.05/3668.87) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 120 tps: 1731.78 qps: 34628.43 (r/w/o: 24240.17/6925.51/3462.75) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 120 tps: 1257.51 qps: 25236.16 (r/w/o: 17668.41/5051.73/2516.02) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 120 tps: 1742.38 qps: 34853.20 (r/w/o: 24393.25/6975.20/3484.75) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 120 tps: 1677.49 qps: 33558.01 (r/w/o: 23484.80/6718.24/3354.97) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 120 tps: 1475.44 qps: 29508.74 (r/w/o: 20656.12/5901.75/2950.87) lat (ms,95%): 123.28 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 120 tps: 1463.28 qps: 29263.31 (r/w/o: 20487.33/5849.32/2926.66) lat (ms,95%): 130.13 err/s: 0.10 reconn/s: 0.00
[ 90s ] thds: 120 tps: 1754.86 qps: 35092.54 (r/w/o: 24568.07/7014.75/3509.72) lat (ms,95%): 118.92 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 120 tps: 1745.17 qps: 34912.78 (r/w/o: 24432.36/6990.08/3490.34) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 120 tps: 1182.51 qps: 23535.16 (r/w/o: 16478.01/4693.13/2364.02) lat (ms,95%): 193.38 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 120 tps: 1757.27 qps: 35195.68 (r/w/o: 24641.33/7039.10/3515.25) lat (ms,95%): 121.08 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            2650060
        write:                           757158
        other:                           378579
        total:                           3785797
    transactions:                        189289 (1573.76 per sec.)
    queries:                             3785797 (31475.36 per sec.)
    ignored errors:                      1      (0.01 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          120.2740s
    total number of events:              189289

Latency (ms):
         min:                                   26.19
         avg:                                   76.13
         max:                                 3940.34
         95th percentile:                      121.08
         sum:                             14411145.53

Threads fairness:
    events (avg/stddev):           1577.4083/21.95
    execution time (avg/stddev):   120.0929/0.08

SourceByrd's Weblog-https://note.t4x.org/database/benchmark-test-sysbench/

SourceByrd's Weblog-https://note.t4x.org/database/benchmark-test-sysbench/SourceByrd's Weblog-https://note.t4x.org/database/benchmark-test-sysbench/

Today in History

April

申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!

Today in History

Login