请选择 进入手机版 | 继续访问电脑版
点击联系客服
客服QQ:509006671 客服微信:mengfeiseo
查看: 155|回复: 50

Headline: PolarDB-X 1.0与RDS性能比较吞吐量(3)

[复制链接]

1

主题

1

帖子

-7

积分

限制会员

积分
-7
发表于 2021-2-23 14:40:57 | 显示全部楼层 |阅读模式
测试环境:

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。
回复

使用道具 举报

1

主题

199

帖子

-1

积分

限制会员

积分
-1
发表于 2021-2-23 14:41:13 | 显示全部楼层
我抢、我抢、我抢沙发~
回复

使用道具 举报

1

主题

203

帖子

22

积分

新手上路

Rank: 1

积分
22
发表于 2021-2-23 15:01:24 | 显示全部楼层
不错,支持下楼主
回复

使用道具 举报

1

主题

193

帖子

32

积分

新手上路

Rank: 1

积分
32
发表于 2021-2-23 15:22:16 | 显示全部楼层
不错不错,很好哦
回复

使用道具 举报

1

主题

194

帖子

-8

积分

限制会员

积分
-8
发表于 2021-2-23 15:46:31 | 显示全部楼层
我是来刷分的,嘿嘿
回复

使用道具 举报

1

主题

180

帖子

42

积分

新手上路

Rank: 1

积分
42
发表于 2021-2-23 16:23:09 | 显示全部楼层
我是个凑数的。。。
回复

使用道具 举报

1

主题

187

帖子

65

积分

注册会员

Rank: 2

积分
65
发表于 2021-2-23 16:43:23 | 显示全部楼层
难得一见的好帖
回复

使用道具 举报

1

主题

190

帖子

68

积分

注册会员

Rank: 2

积分
68
发表于 2021-2-23 17:06:54 | 显示全部楼层
前排支持下分享
回复

使用道具 举报

0

主题

180

帖子

-1

积分

限制会员

积分
-1
发表于 2021-2-23 17:34:30 | 显示全部楼层
路过,学习下
回复

使用道具 举报

1

主题

182

帖子

37

积分

新手上路

Rank: 1

积分
37
发表于 2021-2-23 17:57:03 | 显示全部楼层
好帖,来顶下
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|无图版|手机版|小黑屋|汕头@IT精英团

Powered by Discuz! X3.4 © 2021 Comsenz Inc.

GMT+8, 2021-4-21 00:16 , Processed in 0.182441 second(s), 19 queries .

快速回复 返回顶部 返回列表