TeslaCN commented on issue #10656:
URL:
https://github.com/apache/shardingsphere/issues/10656#issuecomment-855253410
# Refactored
```
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Initializing worker threads...
Creating table 'sbtest8'...
Creating table 'sbtest10'...
Creating table 'sbtest2'...
Creating table 'sbtest6'...
Creating table 'sbtest1'...
Creating table 'sbtest9'...
Creating table 'sbtest5'...
Creating table 'sbtest7'...
Creating table 'sbtest3'...
Creating table 'sbtest4'...
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest6'
Inserting 100000 records into 'sbtest9'
Inserting 100000 records into 'sbtest5'
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest2'
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest9'...
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest5'...
Creating a secondary index on 'sbtest8'...
Creating a secondary index on 'sbtest6'...
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 1867.28 qps: 22424.58 (r/w/o: 18687.61/0.00/3736.96)
lat (ms,99%): 20.74 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 2208.17 qps: 26489.38 (r/w/o: 22073.05/0.00/4416.33)
lat (ms,99%): 11.45 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 2008.63 qps: 24106.98 (r/w/o: 20089.72/0.00/4017.26)
lat (ms,99%): 13.46 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 326290
write: 0
other: 65258
total: 391548
transactions: 32629 (2038.37 per sec.)
queries: 391548 (24460.42 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2038.3681
time elapsed: 16.0074s
total number of events: 32629
Latency (ms):
min: 3.75
avg: 5.88
max: 155.63
99th percentile: 14.73
sum: 191978.40
Threads fairness:
events (avg/stddev): 2719.0833/13.93
execution time (avg/stddev): 15.9982/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 2048.57 qps: 24595.83 (r/w/o: 20496.49/0.00/4099.34)
lat (ms,99%): 12.75 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1985.72 qps: 23830.19 (r/w/o: 19858.56/0.00/3971.63)
lat (ms,99%): 12.08 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 2053.84 qps: 24644.23 (r/w/o: 20536.56/0.00/4107.67)
lat (ms,99%): 13.46 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 322940
write: 0
other: 64588
total: 387528
transactions: 32294 (2017.37 per sec.)
queries: 387528 (24208.44 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 2017.3698
time elapsed: 16.0080s
total number of events: 32294
Latency (ms):
min: 3.67
avg: 5.94
max: 144.93
99th percentile: 12.75
sum: 191982.54
Threads fairness:
events (avg/stddev): 2691.1667/12.77
execution time (avg/stddev): 15.9985/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 27257.42 qps: 27257.42 (r/w/o: 27257.42/0.00/0.00) lat
(ms,99%): 0.90 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 26149.14 qps: 26149.14 (r/w/o: 26149.14/0.00/0.00) lat
(ms,99%): 1.14 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 25211.49 qps: 25211.49 (r/w/o: 25211.49/0.00/0.00) lat
(ms,99%): 1.21 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 422765
write: 0
other: 0
total: 422765
transactions: 422765 (26420.51 per sec.)
queries: 422765 (26420.51 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 26420.5073
time elapsed: 16.0014s
total number of events: 422765
Latency (ms):
min: 0.28
avg: 0.45
max: 115.42
99th percentile: 1.04
sum: 191697.24
Threads fairness:
events (avg/stddev): 35230.4167/142.86
execution time (avg/stddev): 15.9748/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 1277.66 qps: 20459.83 (r/w/o: 12790.24/5111.86/2557.73)
lat (ms,99%): 28.67 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1314.34 qps: 21034.64 (r/w/o:
13147.20/5258.76/2628.68) lat (ms,99%): 18.95 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1340.36 qps: 21449.03 (r/w/o:
13406.44/5362.06/2680.53) lat (ms,99%): 21.89 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 211640
write: 84656
other: 42328
total: 338624
transactions: 21164 (1321.99 per sec.)
queries: 338624 (21151.91 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1321.9942
time elapsed: 16.0091s
total number of events: 21164
Latency (ms):
min: 6.43
avg: 9.07
max: 132.58
99th percentile: 21.89
sum: 192004.80
Threads fairness:
events (avg/stddev): 1763.6667/9.70
execution time (avg/stddev): 16.0004/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 3860.03 qps: 23168.59 (r/w/o: 0.00/15446.13/7722.46)
lat (ms,99%): 5.99 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 3835.67 qps: 23012.84 (r/w/o: 0.00/15341.49/7671.35)
lat (ms,99%): 5.77 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 3648.59 qps: 21891.96 (r/w/o: 0.00/14594.97/7296.99)
lat (ms,99%): 7.17 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 241624
other: 120812
total: 362436
transactions: 60406 (3774.06 per sec.)
queries: 362436 (22644.34 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 3774.0569
time elapsed: 16.0056s
total number of events: 60406
Latency (ms):
min: 1.86
avg: 3.18
max: 131.36
99th percentile: 6.43
sum: 191892.37
Threads fairness:
events (avg/stddev): 5033.8333/14.00
execution time (avg/stddev): 15.9910/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 14686.42 qps: 14686.42 (r/w/o: 0.00/14686.42/0.00) lat
(ms,99%): 1.86 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 14918.18 qps: 14918.18 (r/w/o: 0.00/14918.18/0.00) lat
(ms,99%): 1.61 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15222.45 qps: 15222.45 (r/w/o: 0.00/15222.45/0.00) lat
(ms,99%): 1.70 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 240254
other: 0
total: 240254
transactions: 240254 (15013.93 per sec.)
queries: 240254 (15013.93 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 15013.9335
time elapsed: 16.0021s
total number of events: 240254
Latency (ms):
min: 0.30
avg: 0.80
max: 138.81
99th percentile: 1.67
sum: 191801.43
Threads fairness:
events (avg/stddev): 20021.1667/67.89
execution time (avg/stddev): 15.9835/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 16120.65 qps: 16120.65 (r/w/o: 0.00/16120.65/0.00) lat
(ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 14966.04 qps: 14966.04 (r/w/o: 0.00/14966.04/0.00) lat
(ms,99%): 1.64 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15760.83 qps: 15760.83 (r/w/o: 0.00/15760.83/0.00) lat
(ms,99%): 1.42 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 249979
other: 0
total: 249979
transactions: 249979 (15621.88 per sec.)
queries: 249979 (15621.88 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 15621.8832
time elapsed: 16.0018s
total number of events: 249979
Latency (ms):
min: 0.36
avg: 0.77
max: 126.66
99th percentile: 1.47
sum: 191789.91
Threads fairness:
events (avg/stddev): 20831.5833/37.37
execution time (avg/stddev): 15.9825/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 12
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 12 tps: 16243.86 qps: 16243.86 (r/w/o: 0.00/15603.71/640.15)
lat (ms,99%): 1.61 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 17837.18 qps: 17837.18 (r/w/o: 0.00/15706.42/2130.76)
lat (ms,99%): 1.25 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 17461.29 qps: 17461.29 (r/w/o: 0.00/14076.52/3384.76)
lat (ms,99%): 1.37 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 241276
other: 35284
total: 276560
transactions: 276560 (17283.62 per sec.)
queries: 276560 (17283.62 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 17283.6195
time elapsed: 16.0013s
total number of events: 276560
Latency (ms):
min: 0.25
avg: 0.69
max: 118.96
99th percentile: 1.37
sum: 191765.58
Threads fairness:
events (avg/stddev): 23046.6667/62.63
execution time (avg/stddev): 15.9805/0.00
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
