TeslaCN commented on issue #13688: URL: https://github.com/apache/shardingsphere/issues/13688#issuecomment-973774425
I tried delaying the flush and no error occurred.  ``` >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Transaction on <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 256 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 10s ] thds: 256 tps: 6135.93 qps: 98373.74 (r/w/o: 61514.86/24561.72/12297.15) lat (ms,99%): 167.44 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 256 tps: 12272.42 qps: 196369.16 (r/w/o: 122734.06/49088.46/24546.63) lat (ms,99%): 55.82 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 256 tps: 14143.62 qps: 226290.65 (r/w/o: 141427.12/56575.09/28288.44) lat (ms,99%): 41.10 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 256 tps: 14046.37 qps: 224741.09 (r/w/o: 140464.65/56182.90/28093.55) lat (ms,99%): 35.59 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 256 tps: 14140.53 qps: 226256.35 (r/w/o: 141411.35/56562.54/28282.47) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 256 tps: 14152.39 qps: 226417.04 (r/w/o: 141508.70/56601.66/28306.68) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 256 tps: 14142.52 qps: 226297.50 (r/w/o: 141440.19/56570.57/28286.74) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 256 tps: 14183.69 qps: 226925.48 (r/w/o: 141822.82/56733.77/28368.88) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 256 tps: 14113.63 qps: 225834.43 (r/w/o: 141150.43/56455.43/28228.57) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 256 tps: 13998.32 qps: 223964.80 (r/w/o: 139977.68/55989.97/27997.14) lat (ms,99%): 35.59 err/s: 0.00 reconn/s: 0.00 [ 110s ] thds: 256 tps: 14173.11 qps: 226777.49 (r/w/o: 141734.72/56695.85/28346.92) lat (ms,99%): 30.81 err/s: 0.00 reconn/s: 0.00 [ 120s ] thds: 256 tps: 14165.34 qps: 226646.75 (r/w/o: 141654.40/56660.36/28331.98) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 130s ] thds: 256 tps: 14146.07 qps: 226325.78 (r/w/o: 141452.98/56579.07/28293.74) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 140s ] thds: 256 tps: 14158.62 qps: 226551.59 (r/w/o: 141595.58/56637.67/28318.34) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 150s ] thds: 256 tps: 14159.95 qps: 226548.74 (r/w/o: 141591.66/56635.89/28321.19) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 160s ] thds: 256 tps: 11876.68 qps: 190155.41 (r/w/o: 118866.61/47534.43/23754.36) lat (ms,99%): 61.08 err/s: 0.00 reconn/s: 0.00 [ 170s ] thds: 256 tps: 2309.97 qps: 36824.35 (r/w/o: 22995.95/9208.86/4619.53) lat (ms,99%): 1129.24 err/s: 0.00 reconn/s: 0.00 [ 180s ] thds: 256 tps: 14041.40 qps: 224689.29 (r/w/o: 140432.99/56172.50/28083.80) lat (ms,99%): 33.72 err/s: 0.00 reconn/s: 0.00 [ 190s ] thds: 256 tps: 14165.19 qps: 226622.21 (r/w/o: 141639.54/56651.28/28331.39) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 256 tps: 14186.21 qps: 226971.25 (r/w/o: 141854.69/56743.14/28373.42) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 210s ] thds: 256 tps: 14156.43 qps: 226510.90 (r/w/o: 141570.61/56626.42/28313.86) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 220s ] thds: 256 tps: 14098.56 qps: 225588.28 (r/w/o: 140994.11/56395.94/28198.22) lat (ms,99%): 34.33 err/s: 0.00 reconn/s: 0.00 [ 230s ] thds: 256 tps: 14183.21 qps: 226920.96 (r/w/o: 141823.60/56730.64/28366.72) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 240s ] thds: 256 tps: 14203.29 qps: 227255.92 (r/w/o: 142037.35/56811.28/28407.29) lat (ms,99%): 30.81 err/s: 0.00 reconn/s: 0.00 [ 250s ] thds: 256 tps: 14158.11 qps: 226531.08 (r/w/o: 141581.01/56632.15/28317.92) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 260s ] thds: 256 tps: 14192.78 qps: 227068.80 (r/w/o: 141914.41/56767.73/28386.66) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 270s ] thds: 256 tps: 14134.52 qps: 226168.46 (r/w/o: 141358.86/56539.66/28269.93) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 280s ] thds: 256 tps: 14022.47 qps: 224345.62 (r/w/o: 140212.60/56087.38/28045.64) lat (ms,99%): 35.59 err/s: 0.00 reconn/s: 0.00 [ 290s ] thds: 256 tps: 14143.23 qps: 226303.13 (r/w/o: 141441.13/56575.13/28286.87) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 256 tps: 14158.79 qps: 226529.39 (r/w/o: 141577.07/56633.45/28318.87) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 310s ] thds: 256 tps: 14163.50 qps: 226630.50 (r/w/o: 141646.80/56655.60/28328.10) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 320s ] thds: 256 tps: 14127.09 qps: 226037.61 (r/w/o: 141277.14/56505.68/28254.79) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 330s ] thds: 256 tps: 6305.71 qps: 101007.39 (r/w/o: 63146.92/25248.05/12612.43) lat (ms,99%): 530.08 err/s: 0.00 reconn/s: 0.00 [ 340s ] thds: 256 tps: 11191.54 qps: 178942.68 (r/w/o: 111818.65/44741.55/22382.48) lat (ms,99%): 173.58 err/s: 0.00 reconn/s: 0.00 [ 350s ] thds: 256 tps: 14135.08 qps: 226159.92 (r/w/o: 141349.36/56539.31/28271.25) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 360s ] thds: 256 tps: 14116.03 qps: 225869.65 (r/w/o: 141169.74/56466.84/28233.07) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 370s ] thds: 256 tps: 14140.21 qps: 226226.92 (r/w/o: 141393.97/56551.03/28281.91) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 380s ] thds: 256 tps: 14158.61 qps: 226515.39 (r/w/o: 141567.36/56629.42/28318.61) lat (ms,99%): 31.37 err/s: 0.00 reconn/s: 0.00 [ 390s ] thds: 256 tps: 14062.38 qps: 225035.37 (r/w/o: 140651.89/56257.12/28126.36) lat (ms,99%): 33.72 err/s: 0.00 reconn/s: 0.00 [ 400s ] thds: 256 tps: 14052.35 qps: 224828.62 (r/w/o: 140517.15/56205.68/28105.79) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 [ 410s ] thds: 256 tps: 14122.26 qps: 225961.88 (r/w/o: 141226.91/56489.34/28245.62) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 420s ] thds: 256 tps: 14103.88 qps: 225653.55 (r/w/o: 141030.38/56414.11/28209.06) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 430s ] thds: 256 tps: 14107.83 qps: 225711.10 (r/w/o: 141067.45/56428.10/28215.55) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 440s ] thds: 256 tps: 14114.54 qps: 225837.18 (r/w/o: 141149.52/56457.37/28230.28) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 450s ] thds: 256 tps: 14089.17 qps: 225430.17 (r/w/o: 140896.27/56353.47/28180.43) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 [ 460s ] thds: 256 tps: 14048.49 qps: 224787.80 (r/w/o: 140491.97/56198.75/28097.07) lat (ms,99%): 34.33 err/s: 0.00 reconn/s: 0.00 [ 470s ] thds: 256 tps: 14114.53 qps: 225834.33 (r/w/o: 141146.47/56458.81/28229.05) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 [ 480s ] thds: 256 tps: 14124.36 qps: 225970.27 (r/w/o: 141229.71/56490.74/28249.82) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 490s ] thds: 256 tps: 14109.36 qps: 225760.00 (r/w/o: 141100.76/56441.22/28218.01) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 500s ] thds: 256 tps: 6565.01 qps: 105033.40 (r/w/o: 65645.96/26255.93/13131.51) lat (ms,99%): 390.30 err/s: 0.00 reconn/s: 0.00 [ 510s ] thds: 256 tps: 14091.14 qps: 225466.55 (r/w/o: 140916.01/56367.76/28182.78) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 [ 520s ] thds: 256 tps: 14008.68 qps: 224135.30 (r/w/o: 140084.71/56032.13/28018.46) lat (ms,99%): 34.95 err/s: 0.00 reconn/s: 0.00 [ 530s ] thds: 256 tps: 14157.43 qps: 226526.86 (r/w/o: 141581.75/56629.24/28315.87) lat (ms,99%): 31.94 err/s: 0.00 reconn/s: 0.00 [ 540s ] thds: 256 tps: 14085.90 qps: 225372.86 (r/w/o: 140857.68/56342.99/28172.20) lat (ms,99%): 33.72 err/s: 0.00 reconn/s: 0.00 [ 550s ] thds: 256 tps: 14076.27 qps: 225211.24 (r/w/o: 140756.15/56301.76/28153.33) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 560s ] thds: 256 tps: 14116.43 qps: 225877.63 (r/w/o: 141174.67/56469.91/28233.05) lat (ms,99%): 32.53 err/s: 0.00 reconn/s: 0.00 [ 570s ] thds: 256 tps: 14089.17 qps: 225426.78 (r/w/o: 140892.84/56355.19/28178.75) lat (ms,99%): 33.72 err/s: 0.00 reconn/s: 0.00 [ 580s ] thds: 256 tps: 13981.03 qps: 223680.72 (r/w/o: 139800.23/55917.13/27963.37) lat (ms,99%): 35.59 err/s: 0.00 reconn/s: 0.00 [ 590s ] thds: 256 tps: 14097.12 qps: 225551.75 (r/w/o: 140966.62/56391.39/28193.74) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 [ 600s ] thds: 256 tps: 14071.17 qps: 225142.61 (r/w/o: 140714.40/56284.68/28143.54) lat (ms,99%): 33.12 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 80633110 write: 32252690 other: 16127176 total: 129012976 transactions: 8063311 (13414.53 per sec.) queries: 129012976 (214632.47 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 601.0863s total number of events: 8063311 Latency (ms): min: 3.80 avg: 19.08 max: 2611.95 99th percentile: 39.65 sum: 153858244.84 Threads fairness: events (avg/stddev): 31497.3086/3582.35 execution time (avg/stddev): 601.0088/0.03 ``` -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
