TeslaCN commented on issue #10656:
URL:
https://github.com/apache/shardingsphere/issues/10656#issuecomment-855254139
# Before Refactor
```
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 'sbtest2'...
Creating table 'sbtest8'...
Creating table 'sbtest7'...
Creating table 'sbtest10'...
Creating table 'sbtest6'...
Creating table 'sbtest3'...
Creating table 'sbtest4'...
Creating table 'sbtest9'...
Creating table 'sbtest5'...
Creating table 'sbtest1'...
Inserting 100000 records into 'sbtest5'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest6'
Inserting 100000 records into 'sbtest9'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest2'
Creating a secondary index on 'sbtest10'...
Creating a secondary index on 'sbtest8'...
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest9'...
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest6'...
Creating a secondary index on 'sbtest5'...
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: 1089.73 qps: 13089.81 (r/w/o: 10907.94/0.00/2181.87)
lat (ms,99%): 36.24 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1397.17 qps: 16765.89 (r/w/o: 13971.54/0.00/2794.35)
lat (ms,99%): 16.12 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1878.88 qps: 22544.61 (r/w/o: 18787.04/0.00/3757.57)
lat (ms,99%): 15.83 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 236790
write: 0
other: 47358
total: 284148
transactions: 23679 (1479.09 per sec.)
queries: 284148 (17749.10 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1479.0914
time elapsed: 16.0092s
total number of events: 23679
Latency (ms):
min: 3.65
avg: 8.11
max: 176.79
99th percentile: 21.89
sum: 191978.28
Threads fairness:
events (avg/stddev): 1973.2500/8.38
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: 1455.25 qps: 17477.41 (r/w/o: 14564.71/0.00/2912.70)
lat (ms,99%): 27.17 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 1284.11 qps: 15411.57 (r/w/o: 12843.14/0.00/2568.43)
lat (ms,99%): 46.63 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1597.11 qps: 19162.09 (r/w/o: 15967.88/0.00/3194.22)
lat (ms,99%): 21.11 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 238760
write: 0
other: 47752
total: 286512
transactions: 23876 (1491.68 per sec.)
queries: 286512 (17900.13 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1491.6774
time elapsed: 16.0061s
total number of events: 23876
Latency (ms):
min: 3.42
avg: 8.04
max: 298.49
99th percentile: 27.17
sum: 191949.74
Threads fairness:
events (avg/stddev): 1989.6667/10.39
execution time (avg/stddev): 15.9958/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: 26704.57 qps: 26704.57 (r/w/o: 26704.57/0.00/0.00) lat
(ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 26752.39 qps: 26752.39 (r/w/o: 26752.39/0.00/0.00) lat
(ms,99%): 1.01 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 25730.53 qps: 25730.53 (r/w/o: 25730.53/0.00/0.00) lat
(ms,99%): 1.16 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 424317
write: 0
other: 0
total: 424317
transactions: 424317 (26517.32 per sec.)
queries: 424317 (26517.32 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 26517.3182
time elapsed: 16.0015s
total number of events: 424317
Latency (ms):
min: 0.24
avg: 0.45
max: 120.81
99th percentile: 1.10
sum: 191716.41
Threads fairness:
events (avg/stddev): 35359.7500/117.77
execution time (avg/stddev): 15.9764/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: 647.84 qps: 10387.93 (r/w/o: 6496.32/2593.54/1298.07)
lat (ms,99%): 95.81 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 593.64 qps: 9501.30 (r/w/o: 5938.24/2375.78/1187.29)
lat (ms,99%): 94.10 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 1087.97 qps: 17397.40 (r/w/o:
10872.55/4348.90/2175.95) lat (ms,99%): 28.67 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 130880
write: 52352
other: 26176
total: 209408
transactions: 13088 (817.52 per sec.)
queries: 209408 (13080.34 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 817.5210
time elapsed: 16.0094s
total number of events: 13088
Latency (ms):
min: 5.89
avg: 14.67
max: 590.32
99th percentile: 71.83
sum: 192001.94
Threads fairness:
events (avg/stddev): 1090.6667/3.90
execution time (avg/stddev): 16.0002/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: 3021.36 qps: 18135.57 (r/w/o: 0.00/12090.64/6044.92)
lat (ms,99%): 11.45 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 2690.41 qps: 16140.29 (r/w/o: 0.00/10759.46/5380.83)
lat (ms,99%): 13.70 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 3624.36 qps: 21748.97 (r/w/o: 0.00/14499.64/7249.32)
lat (ms,99%): 6.67 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 200470
other: 100238
total: 300708
transactions: 50118 (3131.38 per sec.)
queries: 300708 (18788.29 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 3131.3812
time elapsed: 16.0051s
total number of events: 50118
Latency (ms):
min: 1.59
avg: 3.83
max: 171.53
99th percentile: 10.09
sum: 191899.17
Threads fairness:
events (avg/stddev): 4176.5000/14.86
execution time (avg/stddev): 15.9916/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: 14750.75 qps: 14750.75 (r/w/o: 0.00/14750.75/0.00) lat
(ms,99%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 14705.09 qps: 14705.09 (r/w/o: 0.00/14705.09/0.00) lat
(ms,99%): 1.73 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15132.74 qps: 15132.74 (r/w/o: 0.00/15132.74/0.00) lat
(ms,99%): 1.47 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 238012
other: 0
total: 238012
transactions: 238012 (14874.09 per sec.)
queries: 238012 (14874.09 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 14874.0934
time elapsed: 16.0018s
total number of events: 238012
Latency (ms):
min: 0.27
avg: 0.81
max: 98.57
99th percentile: 1.64
sum: 191804.57
Threads fairness:
events (avg/stddev): 19834.3333/51.36
execution time (avg/stddev): 15.9837/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: 14860.12 qps: 14860.12 (r/w/o: 0.00/14860.12/0.00) lat
(ms,99%): 1.67 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 15319.64 qps: 15319.64 (r/w/o: 0.00/15319.64/0.00) lat
(ms,99%): 1.58 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 15704.99 qps: 15704.99 (r/w/o: 0.00/15704.99/0.00) lat
(ms,99%): 1.44 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 243112
other: 0
total: 243112
transactions: 243112 (15192.65 per sec.)
queries: 243112 (15192.65 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 15192.6484
time elapsed: 16.0020s
total number of events: 243112
Latency (ms):
min: 0.34
avg: 0.79
max: 103.51
99th percentile: 1.61
sum: 191805.60
Threads fairness:
events (avg/stddev): 20259.3333/55.38
execution time (avg/stddev): 15.9838/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: 16984.27 qps: 16984.27 (r/w/o: 0.00/16275.56/708.71)
lat (ms,99%): 1.32 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 12 tps: 17731.31 qps: 17731.31 (r/w/o: 0.00/15577.57/2153.74)
lat (ms,99%): 1.23 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 12 tps: 17737.07 qps: 17737.07 (r/w/o: 0.00/14272.27/3464.80)
lat (ms,99%): 1.34 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 0
write: 245262
other: 36204
total: 281466
transactions: 281466 (17589.46 per sec.)
queries: 281466 (17589.46 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 17589.4593
time elapsed: 16.0020s
total number of events: 281466
Latency (ms):
min: 0.23
avg: 0.68
max: 105.12
99th percentile: 1.30
sum: 191765.73
Threads fairness:
events (avg/stddev): 23455.5000/58.59
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]
