|
|
测试环境：
PolarDB-X标准版：16C64G(1台)
Rds MySQL 5.7: 16 c 64g (4台)
ECS压缩机：8C16G(1台)
Sysbench 0.5
"margin-top: 0px; margin-bottom: 18px; padding: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0); font-family: -apple-system, "SF UI Text", Arial, "PingFang SC", "Hiragino Sans GB", "Microsoft YaHei", "WenQuanYi Micro Hei", sans-serif; line-height: 28px; color: rgb(102, 102, 102); text-align: justify; white-space: normal; background-color: rgb(255, 255, 255);">通过前期的测试，PolarDB+RDS测试中 PolarDB-X+RDS x4性能最好，接下来进行两轮测试，直连RDS和 PolarDB-X+RDS x4两种环境下，分别进行线程数为200、500、1000、2000、5000的测试。
第一轮测试：直连RDS
测试一：线程数200
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 |
/usr/local/bin/sysbench
--
test
=
'/usr/local/share/sysbench/oltp_drds.lua'
--oltp_tables_count=4 --oltp-table-size=100000000 --mysql-user=sysbenchuser --mysql-password=sysbenchuser --mysql-table-engine=innodb --rand-init=on --report-interval=3 --mysql-host=hlj-prt-mdb.mysql.rds.aliyuncs.com --mysql-port=3306 --mysql-db=sysbenchtest --max-
time
=60 --max-requests=0 --oltp_skip_trx=on --oltp_auto_inc=off --oltp_secondary --oltp_range_size=5 --num-threads=200 run
sysbench 0.5: multi-threaded system evaluation benchmark
Running the
test
with following options:
Number of threads: 200
Report intermediate results every 3 second(s)
Initializing random number generator from timer.
Random number generator seed is 0 and will be ignored
Initializing worker threads...
Threads started!
[ 3s] threads: 200, tps: 0.00, reads: 51489.83, writes: 14579.06, response
time
: 76.00ms (95%), errors: 0.00, reconnects: 0.00
[ 6s] threads: 200, tps: 0.00, reads: 52579.37, writes: 15032.01, response
time
: 74.49ms (95%), errors: 0.00, reconnects: 0.00
[ 9s] threads: 200, tps: 0.00, reads: 54902.03, writes: 15667.01, response
time
: 71.86ms (95%), errors: 0.00, reconnects: 0.00
[ 12s] threads: 200, tps: 0.00, reads: 56939.61, writes: 16278.32, response
time
: 70.25ms (95%), errors: 0.00, reconnects: 0.00
[ 15s] threads: 200, tps: 0.00, reads: 58722.04, writes: 16773.68, response
time
: 67.46ms (95%), errors: 0.00, reconnects: 0.00
[ 18s] threads: 200, tps: 0.00, reads: 60160.36, writes: 17196.01, response
time
: 65.24ms (95%), errors: 0.00, reconnects: 0.00
[ 21s] threads: 200, tps: 0.00, reads: 61805.67, writes: 17653.00, response
time
: 64.08ms (95%), errors: 0.00, reconnects: 0.00
[ 24s] threads: 200, tps: 0.00, reads: 63027.71, writes: 18000.68, response
time
: 62.06ms (95%), errors: 0.00, reconnects: 0.00
[ 27s] threads: 200, tps: 0.00, reads: 64217.62, writes: 18356.99, response
time
: 60.08ms (95%), errors: 0.00, reconnects: 0.00
[ 30s] threads: 200, tps: 0.00, reads: 64923.97, writes: 18548.66, response
time
: 59.87ms (95%), errors: 0.00, reconnects: 0.00
[ 33s] threads: 200, tps: 0.00, reads: 67396.09, writes: 19272.03, response
time
: 57.14ms (95%), errors: 0.00, reconnects: 0.00
[ 36s] threads: 200, tps: 0.00, reads: 70185.72, writes: 20042.35, response
time
: 54.24ms (95%), errors: 0.00, reconnects: 0.00
[ 39s] threads: 200, tps: 0.00, reads: 72913.66, writes: 20823.00, response
time
: 50.49ms (95%), errors: 0.00, reconnects: 0.00
[ 42s] threads: 200, tps: 0.00, reads: 76311.59, writes: 21807.31, response
time
: 46.35ms (95%), errors: 0.00, reconnects: 0.00
[ 45s] threads: 200, tps: 0.00, reads: 78385.41, writes: 22406.69, response
time
: 44.62ms (95%), errors: 0.00, reconnects: 0.00
[ 48s] threads: 200, tps: 0.00, reads: 79635.22, writes: 22740.97, response
time
: 42.80ms (95%), errors: 0.00, reconnects: 0.00
[ 51s] threads: 200, tps: 0.00, reads: 78399.06, writes: 22399.35, response
time
: 42.39ms (95%), errors: 0.00, reconnects: 0.00
[ 54s] threads: 200, tps: 0.00, reads: 83106.65, writes: 23743.00, response
time
: 38.36ms (95%), errors: 0.00, reconnects: 0.00
[ 57s] threads: 200, tps: 0.00, reads: 82669.25, writes: 23616.98, response
time
: 38.29ms (95%), errors: 0.00, reconnects: 0.00
[ 60s] threads: 200, tps: 0.00, reads: 83678.24, writes: 23921.74, response
time
: 37.68ms (95%), errors: 0.00, reconnects: 0.00
OLTP
test
statistics:
queries performed:
read
: 4085494
write: 1167284
other: 0
total: 5252778
transactions: 0 (0.00 per sec.)
read
/write
requests: 5252778 (87499.65 per sec.)
other operations: 0 (0.00 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total
time
: 60.0320s
total number of events: 291821
total
time
taken by event execution: 12002.9269s
response
time
:
min: 28.38ms
avg: 41.13ms
max: 99.60ms
approx. 95 percentile: 68.85ms
Threads fairness:
events (avg
/stddev
): 1459.1050
/67
.61
execution
time
(avg
/stddev
): 60.0146
/0
.01 |
平均QPS为87499，平均响应时间为41ms。
测试二： 线程数500
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 |
/usr/local/bin/sysbench
--
test
=
'/usr/local/share/sysbench/oltp_drds.lua'
--oltp_tables_count=4 --oltp-table-size=100000000 --mysql-user=sysbenchuser --mysql-password=sysbenchuser --mysql-table-engine=innodb --rand-init=on --report-interval=3 --mysql-host=hlj-prt-mdb.mysql.rds.aliyuncs.com --mysql-port=3306 --mysql-db=sysbenchtest --max-
time
=60 --max-requests=0 --oltp_skip_trx=on --oltp_auto_inc=off --oltp_secondary --oltp_range_size=5 --num-threads=500 run
sysbench 0.5: multi-threaded system evaluation benchmark
Running the
test
with following options:
Number of threads: 500
Report intermediate results every 3 second(s)
Initializing random number generator from timer.
Random number generator seed is 0 and will be ignored
Initializing worker threads...
Threads started!
[ 3s] threads: 500, tps: 0.00, reads: 61496.55, writes: 17274.78, response
time
: 144.78ms (95%), errors: 0.00, reconnects: 0.00
[ 6s] threads: 500, tps: 0.00, reads: 57612.03, writes: 16474.77, response
time
: 149.04ms (95%), errors: 0.00, reconnects: 0.00
[ 9s] threads: 500, tps: 0.00, reads: 56378.03, writes: 16057.67, response
time
: 151.06ms (95%), errors: 0.00, reconnects: 0.00
[ 12s] threads: 500, tps: 0.00, reads: 60114.00, writes: 17209.00, response
time
: 145.82ms (95%), errors: 0.00, reconnects: 0.00
[ 15s] threads: 500, tps: 0.00, reads: 61656.62, writes: 17542.32, response
time
: 145.26ms (95%), errors: 0.00, reconnects: 0.00
[ 18s] threads: 500, tps: 0.00, reads: 61470.01, writes: 17639.67, response
time
: 145.17ms (95%), errors: 0.00, reconnects: 0.00
[ 21s] threads: 500, tps: 0.00, reads: 59921.03, writes: 17057.01, response
time
: 146.65ms (95%), errors: 0.00, reconnects: 0.00
[ 24s] threads: 500, tps: 0.00, reads: 60200.23, writes: 17239.97, response
time
: 146.70ms (95%), errors: 0.00, reconnects: 0.00
[ 27s] threads: 500, tps: 0.00, reads: 60733.65, writes: 17345.00, response
time
: 146.61ms (95%), errors: 0.00, reconnects: 0.00
[ 30s] threads: 500, tps: 0.00, reads: 62156.70, writes: 17785.34, response
time
: 145.08ms (95%), errors: 0.00, reconnects: 0.00
[ 33s] threads: 500, tps: 0.00, reads: 62855.70, writes: 17886.01, response
time
: 144.73ms (95%), errors: 0.00, reconnects: 0.00
[ 36s] threads: 500, tps: 0.00, reads: 62668.33, writes: 17853.00, response
time
: 142.16ms (95%), errors: 0.00, reconnects: 0.00
[ 39s] threads: 500, tps: 0.00, reads: 60348.24, writes: 17261.64, response
time
: 145.69ms (95%), errors: 0.00, reconnects: 0.00
[ 42s] threads: 500, tps: 0.00, reads: 60141.03, writes: 17323.68, response
time
: 146.96ms (95%), errors: 0.00, reconnects: 0.00
[ 45s] threads: 500, tps: 0.00, reads: 61451.35, writes: 17479.67, response
time
: 145.47ms (95%), errors: 0.00, reconnects: 0.00
[ 48s] threads: 500, tps: 0.00, reads: 62364.42, writes: 17840.69, response
time
: 142.93ms (95%), errors: 0.00, reconnects: 0.00
[ 51s] threads: 500, tps: 0.00, reads: 61993.60, writes: 17759.65, response
time
: 144.30ms (95%), errors: 0.00, reconnects: 0.00
[ 54s] threads: 500, tps: 0.00, reads: 60878.74, writes: 17427.35, response
time
: 144.82ms (95%), errors: 0.00, reconnects: 0.00
[ 57s] threads: 500, tps: 0.00, reads: 61582.28, writes: 17433.98, response
time
: 144.56ms (95%), errors: 0.00, reconnects: 0.00
[ 60s] threads: 500, tps: 0.00, reads: 62170.72, writes: 17850.68, response
time
: 142.93ms (95%), errors: 0.00, reconnects: 0.00
OLTP
test
statistics:
queries performed:
read
: 3657458
write: 1044988
other: 0
total: 4702446
transactions: 0 (0.00 per sec.)
read
/write
requests: 4702446 (78294.25 per sec.)
other operations: 0 (0.00 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total
time
: 60.0612s
total number of events: 261247
total
time
taken by event execution: 30019.1330s
response
time
:
min: 39.21ms
avg: 114.91ms
max: 214.03ms
approx. 95 percentile: 145.91ms
Threads fairness:
events (avg
/stddev
): 522.4940
/19
.50
execution
time
(avg
/stddev
): 60.0383
/0
.01 |
平均QPS为78294，平均响应时间为114ms。
测试三：线程数1000
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 |
/usr/local/bin/sysbench
--
test
=
'/usr/local/share/sysbench/oltp_drds.lua'
--oltp_tables_count=4 --oltp-table-size=100000000 --mysql-user=sysbenchuser --mysql-password=sysbenchuser --mysql-table-engine=innodb --rand-init=on --report-interval=3 --mysql-host=hlj-prt-mdb.mysql.rds.aliyuncs.com --mysql-port=3306 --mysql-db=sysbenchtest --max-
time
=60 --max-requests=0 --oltp_skip_trx=on --oltp_auto_inc=off --oltp_secondary --oltp_range_size=5 --num-threads=1000 run
sysbench 0.5: multi-threaded system evaluation benchmark
Running the
test
with following options:
Number of threads: 1000
Report intermediate results every 3 second(s)
Initializing random number generator from timer.
Random number generator seed is 0 and will be ignored
Initializing worker threads...
Threads started!
[ 3s] threads: 1000, tps: 0.00, reads: 65576.17, writes: 17990.19, response
time
: 490.44ms (95%), errors: 0.00, reconnects: 0.00
[ 6s] threads: 1000, tps: 0.00, reads: 73092.93, writes: 20889.17, response
time
: 602.78ms (95%), errors: 0.00, reconnects: 0.00
[ 9s] threads: 1000, tps: 0.00, reads: 65738.77, writes: 18760.70, response
time
: 493.53ms (95%), errors: 0.00, reconnects: 0.00
[ 12s] threads: 1000, tps: 0.00, reads: 65297.52, writes: 18654.05, response
time
: 510.67ms (95%), errors: 0.00, reconnects: 0.00
[ 15s] threads: 1000, tps: 0.00, reads: 67278.88, writes: 19234.11, response
time
: 497.54ms (95%), errors: 0.00, reconnects: 0.00
[ 18s] threads: 1000, tps: 0.00, reads: 69235.85, writes: 19799.58, response
time
: 504.89ms (95%), errors: 0.00, reconnects: 0.00
[ 21s] threads: 1000, tps: 0.00, reads: 65454.24, writes: 18819.97, response
time
: 492.06ms (95%), errors: 0.00, reconnects: 0.00
[ 24s] threads: 1000, tps: 0.00, reads: 67564.33, writes: 19226.67, response
time
: 446.98ms (95%), errors: 0.00, reconnects: 0.00
[ 27s] threads: 1000, tps: 0.00, reads: 67007.72, writes: 19108.25, response
time
: 484.02ms (95%), errors: 0.00, reconnects: 0.00
[ 30s] threads: 1000, tps: 0.00, reads: 66787.81, writes: 19121.37, response
time
: 453.99ms (95%), errors: 0.00, reconnects: 0.00
[ 33s] threads: 1000, tps: 0.00, reads: 67735.42, writes: 19385.36, response
time
: 481.86ms (95%), errors: 0.00, reconnects: 0.00
[ 36s] threads: 1000, tps: 0.00, reads: 66848.22, writes: 19053.73, response
time
: 496.20ms (95%), errors: 0.00, reconnects: 0.00
[ 39s] threads: 1000, tps: 0.00, reads: 66971.86, writes: 19120.20, response
time
: 488.68ms (95%), errors: 0.00, reconnects: 0.00
[ 42s] threads: 1000, tps: 0.00, reads: 66567.88, writes: 19061.06, response
time
: 457.54ms (95%), errors: 0.00, reconnects: 0.00
[ 45s] threads: 1000, tps: 0.00, reads: 68073.00, writes: 19449.33, response
time
: 455.76ms (95%), errors: 0.00, reconnects: 0.00
[ 48s] threads: 1000, tps: 0.00, reads: 65128.44, writes: 18596.94, response
time
: 467.23ms (95%), errors: 0.00, reconnects: 0.00
[ 51s] threads: 1000, tps: 0.00, reads: 66999.20, writes: 19188.06, response
time
: 456.85ms (95%), errors: 0.00, reconnects: 0.00
[ 54s] threads: 1000, tps: 0.00, reads: 68210.18, writes: 19401.29, response
time
: 497.24ms (95%), errors: 0.00, reconnects: 0.00
[ 57s] threads: 1000, tps: 0.00, reads: 67944.46, writes: 19395.04, response
time
: 445.64ms (95%), errors: 0.00, reconnects: 0.00
[ 60s] threads: 1000, tps: 0.00, reads: 67274.60, writes: 19139.41, response
time
: 533.16ms (95%), errors: 0.00, reconnects: 0.00
OLTP
test
statistics:
queries performed:
read
: 4038874
write: 1153964
other: 0
total: 5192838
transactions: 0 (0.00 per sec.)
read
/write
requests: 5192838 (86327.06 per sec.)
other operations: 0 (0.00 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total
time
: 60.1531s
total number of events: 288491
total
time
taken by event execution: 60060.5957s
response
time
:
min: 28.49ms
avg: 208.19ms
max: 2097.82ms
approx. 95 percentile: 491.91ms
Threads fairness:
events (avg
/stddev
): 288.4910
/23
.89
execution
time
(avg
/stddev
): 60.0606
/0
.03 |
平均QPS为86327，平均响应时间为208ms。
测试四：线程数2000
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 |
/usr/local/bin/sysbench
--
test
=
'/usr/local/share/sysbench/oltp_drds.lua'
--oltp_tables_count=4 --oltp-table-size=100000000 --mysql-user=sysbenchuser --mysql-password=sysbenchuser --mysql-table-engine=innodb --rand-init=on --report-interval=3 --mysql-host=hlj-prt-mdb.mysql.rds.aliyuncs.com --mysql-port=3306 --mysql-db=sysbenchtest --max-
time
=60 --max-requests=0 --oltp_skip_trx=on --oltp_auto_inc=off --oltp_secondary --oltp_range_size=5 --num-threads=2000 run
sysbench 0.5: multi-threaded system evaluation benchmark
Running the
test
with following options:
Number of threads: 2000
Report intermediate results every 3 second(s)
Initializing random number generator from timer.
Random number generator seed is 0 and will be ignored
Initializing worker threads...
Threads started!
[ 3s] threads: 2000, tps: 0.00, reads: 54957.77, writes: 14308.59, response
time
: 1402.46ms (95%), errors: 0.00, reconnects: 0.00
[ 6s] threads: 2000, tps: 0.00, reads: 62956.50, writes: 18030.28, response
time
: 1093.93ms (95%), errors: 0.00, reconnects: 0.00
[ 9s] threads: 2000, tps: 0.00, reads: 67289.33, writes: 19187.19, response
time
: 1261.45ms (95%), errors: 0.00, reconnects: 0.00
[ 12s] threads: 2000, tps: 0.00, reads: 58556.04, writes: 16718.01, response
time
: 1447.68ms (95%), errors: 0.00, reconnects: 0.00
[ 15s] threads: 2000, tps: 0.00, reads: 64870.56, writes: 18549.30, response
time
: 1101.82ms (95%), errors: 0.00, reconnects: 0.00
[ 18s] threads: 2000, tps: 0.00, reads: 60134.97, writes: 17228.66, response
time
: 1001.47ms (95%), errors: 0.00, reconnects: 0.00
[ 21s] threads: 2000, tps: 0.00, reads: 62239.50, writes: 17739.62, response
time
: 1109.43ms (95%), errors: 0.00, reconnects: 0.00
[ 24s] threads: 2000, tps: 0.00, reads: 60677.65, writes: 17374.42, response
time
: 1141.09ms (95%), errors: 0.00, reconnects: 0.00
[ 27s] threads: 2000, tps: 0.00, reads: 62871.28, writes: 17875.99, response
time
: 1026.05ms (95%), errors: 0.00, reconnects: 0.00
[ 30s] threads: 2000, tps: 0.00, reads: 61926.47, writes: 17682.09, response
time
: 1100.50ms (95%), errors: 0.00, reconnects: 0.00
[ 33s] threads: 2000, tps: 0.00, reads: 57988.53, writes: 16603.25, response
time
: 1132.58ms (95%), errors: 0.00, reconnects: 0.00
[ 36s] threads: 2000, tps: 0.00, reads: 44483.63, writes: 12734.32, response
time
: 1856.53ms (95%), errors: 0.00, reconnects: 0.00
[ 39s] threads: 2000, tps: 0.00, reads: 54336.87, writes: 15544.63, response
time
: 1723.19ms (95%), errors: 0.00, reconnects: 0.00
[ 42s] threads: 2000, tps: 0.00, reads: 50221.96, writes: 14302.89, response
time
: 1908.94ms (95%), errors: 0.00, reconnects: 0.00
[ 45s] threads: 2000, tps: 0.00, reads: 48629.29, writes: 13843.18, response
time
: 1759.15ms (95%), errors: 0.00, reconnects: 0.00
[ 48s] threads: 2000, tps: 0.00, reads: 59440.51, writes: 17114.33, response
time
: 1693.02ms (95%), errors: 0.00, reconnects: 0.00
[ 51s] threads: 2000, tps: 0.00, reads: 57233.22, writes: 16259.25, response
time
: 1434.73ms (95%), errors: 0.00, reconnects: 0.00
[ 54s] threads: 2000, tps: 0.00, reads: 62598.71, writes: 17965.68, response
time
: 1603.73ms (95%), errors: 0.00, reconnects: 0.00
[ 57s] threads: 2000, tps: 0.00, reads: 54746.67, writes: 15587.33, response
time
: 1598.94ms (95%), errors: 0.00, reconnects: 0.00
[ 60s] threads: 2000, tps: 0.00, reads: 65303.72, writes: 18647.35, response
time
: 1733.53ms (95%), errors: 0.00, reconnects: 0.00
OLTP
test
statistics:
queries performed:
read
: 3523716
write: 1006776
other: 0
total: 4530492
transactions: 0 (0.00 per sec.)
read
/write
requests: 4530492 (74905.80 per sec.)
other operations: 0 (0.00 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total
time
: 60.4825s
total number of events: 251694
total
time
taken by event execution: 120315.0244s
response
time
:
min: 28.64ms
avg: 478.02ms
max: 6659.42ms
approx. 95 percentile: 1401.62ms
Threads fairness:
events (avg
/stddev
): 125.8470
/13
.04
execution
time
(avg
/stddev
): 60.1575
/0
.11 |
平均QPS为74905，平均响应时间为478ms。
测试五： 线程数5000
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 |
/usr/local/bin/sysbench
--
test
=
'/usr/local/share/sysbench/oltp_drds.lua'
--oltp_tables_count=4 --oltp-table-size=100000000 --mysql-user=sysbenchuser --mysql-password=sysbenchuser --mysql-table-engine=innodb --rand-init=on --report-interval=3 --mysql-host=hlj-prt-mdb.mysql.rds.aliyuncs.com --mysql-port=3306 --mysql-db=sysbenchtest --max-
time
=60 --max-requests=0 --oltp_skip_trx=on --oltp_auto_inc=off --oltp_secondary --oltp_range_size=5 --num-threads=5000 run
sysbench 0.5: multi-threaded system evaluation benchmark
Running the
test
with following options:
Number of threads: 5000
Report intermediate results every 3 second(s)
Initializing random number generator from timer.
Random number generator seed is 0 and will be ignored
Initializing worker threads...
Threads started!
[ 3s] threads: 5000, tps: 0.00, reads: 30818.53, writes: 5682.11, response
time
: 2916.59ms (95%), errors: 0.00, reconnects: 0.00
[ 6s] threads: 5000, tps: 0.00, reads: 31884.55, writes: 8920.60, response
time
: 3677.02ms (95%), errors: 0.00, reconnects: 0.00
[ 9s] threads: 5000, tps: 0.00, reads: 29956.66, writes: 8451.80, response
time
: 3454.02ms (95%), errors: 0.00, reconnects: 0.00
[ 12s] threads: 5000, tps: 0.00, reads: 28265.92, writes: 8166.98, response
time
: 3605.09ms (95%), errors: 0.00, reconnects: 0.00
[ 15s] threads: 5000, tps: 0.00, reads: 28969.01, writes: 8236.10, response
time
: 3650.70ms (95%), errors: 0.00, reconnects: 0.00
[ 18s] threads: 5000, tps: 0.00, reads: 29847.66, writes: 8510.57, response
time
: 3688.04ms (95%), errors: 0.00, reconnects: 0.00
[ 21s] threads: 5000, tps: 0.00, reads: 28626.80, writes: 8186.04, response
time
: 3652.88ms (95%), errors: 0.00, reconnects: 0.00
[ 24s] threads: 5000, tps: 0.00, reads: 29953.03, writes: 8499.91, response
time
: 3739.17ms (95%), errors: 0.00, reconnects: 0.00
[ 27s] threads: 5000, tps: 0.00, reads: 31223.86, writes: 8829.39, response
time
: 3444.73ms (95%), errors: 0.00, reconnects: 0.00
[ 30s] threads: 5000, tps: 0.00, reads: 29768.33, writes: 8739.14, response
time
: 3446.79ms (95%), errors: 0.00, reconnects: 0.00
[ 33s] threads: 5000, tps: 0.00, reads: 29579.31, writes: 8357.09, response
time
: 3605.09ms (95%), errors: 0.00, reconnects: 0.00
[ 36s] threads: 5000, tps: 0.00, reads: 31822.27, writes: 9174.51, response
time
: 3402.71ms (95%), errors: 0.00, reconnects: 0.00
[ 39s] threads: 5000, tps: 0.00, reads: 32966.93, writes: 9309.46, response
time
: 3203.06ms (95%), errors: 0.00, reconnects: 0.00
[ 42s] threads: 5000, tps: 0.00, reads: 30918.22, writes: 8935.40, response
time
: 3311.27ms (95%), errors: 0.00, reconnects: 0.00
[ 45s] threads: 5000, tps: 0.00, reads: 31692.66, writes: 9073.00, response
time
: 3352.16ms (95%), errors: 0.00, reconnects: 0.00
[ 48s] threads: 5000, tps: 0.00, reads: 30903.10, writes: 8786.17, response
time
: 3456.09ms (95%), errors: 0.00, reconnects: 0.00
[ 51s] threads: 5000, tps: 0.00, reads: 32564.06, writes: 9309.78, response
time
: 3310.28ms (95%), errors: 0.00, reconnects: 0.00
[ 54s] threads: 5000, tps: 0.00, reads: 32285.47, writes: 9262.13, response
time
: 3251.36ms (95%), errors: 0.00, reconnects: 0.00
[ 57s] threads: 5000, tps: 0.00, reads: 30733.78, writes: 8827.94, response
time
: 3310.28ms (95%), errors: 0.00, reconnects: 0.00
[ 60s] threads: 5000, tps: 0.00, reads: 28827.56, writes: 8218.21, response
time
: 3508.21ms (95%), errors: 0.00, reconnects: 0.00
OLTP
test
statistics:
queries performed:
read
: 1863050
write: 532300
other: 0
total: 2395350
transactions: 0 (0.00 per sec.)
read
/write
requests: 2395350 (39155.25 per sec.)
other operations: 0 (0.00 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total
time
: 61.1757s
total number of events: 133075
total
time
taken by event execution: 303636.6212s
response
time
:
min: 144.65ms
avg: 2281.70ms
max: 6013.87ms
approx. 95 percentile: 3489.36ms
Threads fairness:
events (avg
/stddev
): 26.6150
/2
.25
execution
time
(avg
/stddev
): 60.7273
/0
.33 |
平均QPS为39155，平均响应时间为2281ms。 |
|
发表于 2021-2-23 14:40:57
