MySQL基准测试之sysbench

  • A+
所属分类：Database

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
[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

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
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

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
$ 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
####清理数据####        

参数说明：

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

生产测试：

3307 mysql-5.7.18

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

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

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

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

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