Fedora 31 上 sysbench 1.0.17 测试mysql读写性能

绝地灬酷狼 2022-11-22 05:19 94阅读 0赞

[yeqiang@harbor sysbench]$ sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123132 --tables=1  --table_size=1000000 --threads=400 --time=120 --report-interval=1 prepare
    sysbench 1.0.17 (using system LuaJIT 2.1.0-beta3)
    
    Initializing worker threads...
    
    Creating table 'sbtest1'...
    Inserting 1000000 records into 'sbtest1'
    Creating a secondary index on 'sbtest1'...

[yeqiang@harbor sysbench]$ sysbench /usr/share/sysbench/oltp_read_write.lua --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123123 --tables=1  --table_size=1000000 --threads=400 --time=120 --report-interval=1 run
    sysbench 1.0.17 (using system LuaJIT 2.1.0-beta3)
    
    Running the test with following options:
    Number of threads: 400
    Report intermediate results every 1 second(s)
    Initializing random number generator from current time
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 400 tps: 1322.42 qps: 32546.17 (r/w/o: 23390.09/6111.71/3044.37) lat (ms,95%): 411.96 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 400 tps: 1687.08 qps: 34684.55 (r/w/o: 24107.08/7203.32/3374.15) lat (ms,95%): 442.73 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 400 tps: 2040.14 qps: 39112.73 (r/w/o: 27769.94/7262.51/4080.28) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 400 tps: 1901.98 qps: 39169.64 (r/w/o: 26888.76/8479.92/3800.97) lat (ms,95%): 442.73 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 400 tps: 2553.99 qps: 50235.89 (r/w/o: 35494.92/9629.98/5110.99) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 400 tps: 2448.00 qps: 50045.91 (r/w/o: 35084.94/10065.98/4894.99) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 400 tps: 2633.00 qps: 52280.10 (r/w/o: 36484.07/10529.02/5267.01) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 400 tps: 2625.01 qps: 50309.20 (r/w/o: 35267.14/9793.04/5249.02) lat (ms,95%): 314.45 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 400 tps: 2387.87 qps: 49983.22 (r/w/o: 34744.07/10467.42/4771.73) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 400 tps: 2430.11 qps: 49190.23 (r/w/o: 34610.57/9716.44/4863.22) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 400 tps: 2680.69 qps: 52818.85 (r/w/o: 36784.72/10670.76/5363.38) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 400 tps: 2442.22 qps: 47489.20 (r/w/o: 33488.96/9121.81/4878.43) lat (ms,95%): 337.94 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 400 tps: 2634.81 qps: 52164.26 (r/w/o: 36668.37/10220.27/5275.62) lat (ms,95%): 292.60 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 400 tps: 2413.27 qps: 49523.46 (r/w/o: 34281.78/10416.15/4825.53) lat (ms,95%): 350.33 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 400 tps: 2633.94 qps: 51428.88 (r/w/o: 36398.20/9763.79/5266.88) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 400 tps: 2487.74 qps: 49810.74 (r/w/o: 34629.34/10207.92/4973.47) lat (ms,95%): 356.70 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 400 tps: 2162.25 qps: 45255.29 (r/w/o: 31487.68/9441.10/4326.51) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 400 tps: 2767.01 qps: 53559.16 (r/w/o: 37889.11/10134.03/5536.02) lat (ms,95%): 292.60 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 400 tps: 2210.01 qps: 46444.22 (r/w/o: 32095.15/9933.05/4416.02) lat (ms,95%): 356.70 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 400 tps: 2733.82 qps: 53604.51 (r/w/o: 37606.55/10527.31/5470.64) lat (ms,95%): 240.02 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 400 tps: 2632.17 qps: 51130.21 (r/w/o: 35971.26/9894.62/5264.33) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 400 tps: 2421.89 qps: 51672.71 (r/w/o: 35943.41/10884.52/4844.79) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 400 tps: 2395.11 qps: 47633.18 (r/w/o: 33381.53/9463.43/4788.22) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 400 tps: 2398.97 qps: 45966.35 (r/w/o: 32455.54/8710.88/4799.93) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 400 tps: 2466.03 qps: 49060.53 (r/w/o: 34502.37/9626.10/4932.05) lat (ms,95%): 337.94 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 400 tps: 2054.01 qps: 40793.20 (r/w/o: 28408.14/8280.04/4105.02) lat (ms,95%): 350.33 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 400 tps: 2565.99 qps: 53775.82 (r/w/o: 37384.87/11258.96/5131.98) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 400 tps: 2326.03 qps: 41017.46 (r/w/o: 28316.32/8046.09/4655.05) lat (ms,95%): 390.30 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 400 tps: 2202.94 qps: 48652.64 (r/w/o: 34591.03/9656.73/4404.88) lat (ms,95%): 282.25 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 400 tps: 2682.06 qps: 51035.15 (r/w/o: 35585.80/10085.23/5364.12) lat (ms,95%): 376.49 err/s: 0.00 reconn/s: 0.00
    [ 31s ] thds: 400 tps: 1729.59 qps: 37258.16 (r/w/o: 26127.80/7672.18/3458.18) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
    [ 32s ] thds: 400 tps: 1931.46 qps: 39461.40 (r/w/o: 27523.56/8074.92/3862.92) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00
    [ 33s ] thds: 400 tps: 2513.00 qps: 50677.02 (r/w/o: 35435.02/10214.00/5028.00) lat (ms,95%): 350.33 err/s: 0.00 reconn/s: 0.00
    [ 34s ] thds: 400 tps: 2690.01 qps: 52240.14 (r/w/o: 36872.10/9988.03/5380.01) lat (ms,95%): 262.64 err/s: 0.00 reconn/s: 0.00
    [ 35s ] thds: 400 tps: 2408.85 qps: 49361.02 (r/w/o: 34417.92/10125.39/4817.71) lat (ms,95%): 314.45 err/s: 0.00 reconn/s: 0.00
    [ 36s ] thds: 400 tps: 2452.12 qps: 46351.19 (r/w/o: 32359.53/9087.43/4904.23) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 37s ] thds: 400 tps: 2026.98 qps: 42656.61 (r/w/o: 29809.73/8797.92/4048.96) lat (ms,95%): 376.49 err/s: 0.00 reconn/s: 0.00
    [ 38s ] thds: 400 tps: 2362.01 qps: 43977.21 (r/w/o: 30587.15/8661.04/4729.02) lat (ms,95%): 397.39 err/s: 0.00 reconn/s: 0.00
    [ 39s ] thds: 400 tps: 1876.76 qps: 41681.63 (r/w/o: 29366.22/8561.90/3753.52) lat (ms,95%): 502.20 err/s: 0.00 reconn/s: 0.00
    [ 40s ] thds: 400 tps: 2124.29 qps: 39696.50 (r/w/o: 27981.88/7466.03/4248.59) lat (ms,95%): 493.24 err/s: 0.00 reconn/s: 0.00
    [ 41s ] thds: 400 tps: 773.13 qps: 17072.59 (r/w/o: 11661.66/3909.44/1501.49) lat (ms,95%): 590.56 err/s: 0.00 reconn/s: 0.00
    [ 42s ] thds: 400 tps: 1520.60 qps: 29613.04 (r/w/o: 21127.62/5398.99/3086.43) lat (ms,95%): 759.88 err/s: 0.00 reconn/s: 0.00
    [ 43s ] thds: 400 tps: 2374.78 qps: 49364.75 (r/w/o: 34311.88/10303.32/4749.56) lat (ms,95%): 314.45 err/s: 0.00 reconn/s: 0.00
    [ 44s ] thds: 400 tps: 2359.16 qps: 46523.13 (r/w/o: 32644.46/9160.34/4718.32) lat (ms,95%): 282.25 err/s: 0.00 reconn/s: 0.00
    [ 45s ] thds: 400 tps: 2692.81 qps: 52280.37 (r/w/o: 36755.44/10141.30/5383.63) lat (ms,95%): 244.38 err/s: 0.00 reconn/s: 0.00
    [ 46s ] thds: 400 tps: 2438.09 qps: 48796.82 (r/w/o: 33977.27/9944.37/4875.18) lat (ms,95%): 337.94 err/s: 0.00 reconn/s: 0.00
    [ 47s ] thds: 400 tps: 1898.97 qps: 39679.41 (r/w/o: 27700.92/8181.55/3796.93) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
    [ 48s ] thds: 400 tps: 2461.42 qps: 46611.98 (r/w/o: 32755.96/8930.17/4925.85) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 49s ] thds: 400 tps: 2117.94 qps: 43345.77 (r/w/o: 30383.14/8725.75/4236.88) lat (ms,95%): 397.39 err/s: 0.00 reconn/s: 0.00
    [ 50s ] thds: 400 tps: 2247.06 qps: 44731.16 (r/w/o: 31499.81/8737.23/4494.12) lat (ms,95%): 331.91 err/s: 0.00 reconn/s: 0.00
    [ 51s ] thds: 400 tps: 2232.54 qps: 44698.54 (r/w/o: 30726.01/9507.45/4465.08) lat (ms,95%): 331.91 err/s: 0.00 reconn/s: 0.00
    [ 52s ] thds: 400 tps: 1555.21 qps: 32804.99 (r/w/o: 23134.18/6561.40/3109.41) lat (ms,95%): 559.50 err/s: 0.00 reconn/s: 0.00
    [ 53s ] thds: 400 tps: 2753.15 qps: 52870.95 (r/w/o: 37455.09/9908.55/5507.31) lat (ms,95%): 240.02 err/s: 0.00 reconn/s: 0.00
    [ 54s ] thds: 400 tps: 2282.86 qps: 48020.11 (r/w/o: 33261.99/10192.39/4565.72) lat (ms,95%): 397.39 err/s: 0.00 reconn/s: 0.00
    [ 55s ] thds: 400 tps: 2303.12 qps: 46064.39 (r/w/o: 32113.67/9345.49/4605.24) lat (ms,95%): 434.83 err/s: 0.00 reconn/s: 0.00
    [ 56s ] thds: 400 tps: 2111.00 qps: 42219.03 (r/w/o: 29648.02/8350.01/4221.00) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
    [ 57s ] thds: 400 tps: 2463.02 qps: 45943.13 (r/w/o: 31929.38/9090.70/4923.05) lat (ms,95%): 277.21 err/s: 0.00 reconn/s: 0.00
    [ 58s ] thds: 400 tps: 2330.87 qps: 49135.43 (r/w/o: 34797.93/9672.76/4664.74) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 59s ] thds: 400 tps: 2061.96 qps: 42631.13 (r/w/o: 29573.39/8931.82/4125.92) lat (ms,95%): 344.08 err/s: 0.00 reconn/s: 0.00
    [ 60s ] thds: 400 tps: 2603.29 qps: 52095.74 (r/w/o: 36454.08/10435.07/5206.59) lat (ms,95%): 282.25 err/s: 0.00 reconn/s: 0.00
    [ 61s ] thds: 400 tps: 2013.59 qps: 35279.06 (r/w/o: 24474.59/6777.29/4027.18) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
    [ 62s ] thds: 400 tps: 2331.30 qps: 51079.63 (r/w/o: 36216.70/10200.32/4662.61) lat (ms,95%): 277.21 err/s: 0.00 reconn/s: 0.00
    [ 63s ] thds: 400 tps: 1797.00 qps: 35903.10 (r/w/o: 25051.07/7257.02/3595.01) lat (ms,95%): 467.30 err/s: 1.00 reconn/s: 0.00
    [ 64s ] thds: 400 tps: 2694.02 qps: 51969.39 (r/w/o: 36720.28/9861.07/5388.04) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00
    [ 65s ] thds: 400 tps: 1752.01 qps: 35880.16 (r/w/o: 25012.11/7364.03/3504.02) lat (ms,95%): 493.24 err/s: 0.00 reconn/s: 0.00
    [ 66s ] thds: 400 tps: 2516.92 qps: 51731.44 (r/w/o: 35939.91/10757.67/5033.85) lat (ms,95%): 292.60 err/s: 0.00 reconn/s: 0.00
    [ 67s ] thds: 400 tps: 2102.03 qps: 41729.68 (r/w/o: 29215.47/8313.13/4201.07) lat (ms,95%): 356.70 err/s: 0.00 reconn/s: 0.00
    [ 68s ] thds: 400 tps: 2451.90 qps: 47597.15 (r/w/o: 33313.71/9376.64/4906.81) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 69s ] thds: 400 tps: 1916.56 qps: 38784.05 (r/w/o: 27138.74/7819.20/3826.12) lat (ms,95%): 376.49 err/s: 0.00 reconn/s: 0.00
    [ 70s ] thds: 400 tps: 2490.70 qps: 50792.36 (r/w/o: 35690.09/10114.86/4987.41) lat (ms,95%): 303.33 err/s: 0.00 reconn/s: 0.00
    [ 71s ] thds: 400 tps: 2576.76 qps: 50628.34 (r/w/o: 35586.72/9887.09/5154.53) lat (ms,95%): 257.95 err/s: 0.00 reconn/s: 0.00
    [ 72s ] thds: 400 tps: 2425.18 qps: 49049.55 (r/w/o: 34186.47/10012.72/4850.35) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 73s ] thds: 400 tps: 2225.02 qps: 44754.41 (r/w/o: 31233.29/9071.08/4450.04) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 74s ] thds: 400 tps: 2290.76 qps: 42601.22 (r/w/o: 29488.47/8531.22/4581.53) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 75s ] thds: 400 tps: 2346.36 qps: 48442.08 (r/w/o: 34530.21/9219.14/4692.73) lat (ms,95%): 511.33 err/s: 0.00 reconn/s: 0.00
    [ 76s ] thds: 400 tps: 2811.79 qps: 55404.93 (r/w/o: 38711.16/11070.19/5623.59) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00
    [ 77s ] thds: 400 tps: 2018.15 qps: 42167.05 (r/w/o: 29578.14/8552.62/4036.29) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
    [ 78s ] thds: 400 tps: 2808.01 qps: 56377.15 (r/w/o: 39229.11/11532.03/5616.02) lat (ms,95%): 262.64 err/s: 0.00 reconn/s: 0.00
    [ 79s ] thds: 400 tps: 998.93 qps: 19886.70 (r/w/o: 14120.08/3769.75/1996.87) lat (ms,95%): 539.71 err/s: 0.00 reconn/s: 0.00
    [ 80s ] thds: 400 tps: 2502.15 qps: 48473.99 (r/w/o: 33384.06/10084.62/5005.31) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
    [ 81s ] thds: 400 tps: 2365.90 qps: 49760.85 (r/w/o: 35077.49/9951.57/4731.80) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 82s ] thds: 400 tps: 2204.07 qps: 43998.30 (r/w/o: 30811.91/8780.26/4406.13) lat (ms,95%): 356.70 err/s: 0.00 reconn/s: 0.00
    [ 83s ] thds: 400 tps: 2622.01 qps: 50423.16 (r/w/o: 35327.11/9850.03/5246.02) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00
    [ 84s ] thds: 400 tps: 2194.02 qps: 46299.46 (r/w/o: 32330.32/9581.10/4388.04) lat (ms,95%): 314.45 err/s: 0.00 reconn/s: 0.00
    [ 85s ] thds: 400 tps: 2728.01 qps: 53866.23 (r/w/o: 38070.16/10340.04/5456.02) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00
    [ 86s ] thds: 400 tps: 2422.00 qps: 47579.05 (r/w/o: 32811.03/9927.01/4841.01) lat (ms,95%): 292.60 err/s: 0.00 reconn/s: 0.00
    [ 87s ] thds: 400 tps: 2627.97 qps: 53515.37 (r/w/o: 37753.56/10502.88/5258.94) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00
    [ 88s ] thds: 400 tps: 1730.84 qps: 35186.83 (r/w/o: 24480.79/7244.35/3461.69) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00
    [ 89s ] thds: 400 tps: 2033.79 qps: 40696.70 (r/w/o: 28490.99/8138.14/4067.57) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 90s ] thds: 400 tps: 2266.46 qps: 44003.95 (r/w/o: 30864.28/8606.75/4532.92) lat (ms,95%): 411.96 err/s: 0.00 reconn/s: 0.00
    [ 91s ] thds: 400 tps: 2826.97 qps: 55829.37 (r/w/o: 39053.56/11123.87/5651.94) lat (ms,95%): 240.02 err/s: 0.00 reconn/s: 0.00
    [ 92s ] thds: 400 tps: 2398.03 qps: 48021.59 (r/w/o: 33834.41/9389.12/4798.06) lat (ms,95%): 272.27 err/s: 0.00 reconn/s: 0.00
    [ 93s ] thds: 400 tps: 2690.99 qps: 54755.82 (r/w/o: 38177.87/11195.96/5381.98) lat (ms,95%): 257.95 err/s: 0.00 reconn/s: 0.00
    [ 94s ] thds: 400 tps: 1942.01 qps: 39068.12 (r/w/o: 27383.09/7802.02/3883.01) lat (ms,95%): 344.08 err/s: 0.00 reconn/s: 0.00
    [ 95s ] thds: 400 tps: 2645.99 qps: 51195.88 (r/w/o: 35815.92/10090.98/5288.99) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 96s ] thds: 400 tps: 2238.98 qps: 46358.50 (r/w/o: 32533.65/9345.90/4478.95) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 97s ] thds: 400 tps: 2430.03 qps: 48337.66 (r/w/o: 33520.46/9955.14/4862.07) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
    [ 98s ] thds: 400 tps: 2111.98 qps: 42061.64 (r/w/o: 29561.75/8276.93/4222.96) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 99s ] thds: 400 tps: 1637.94 qps: 34095.71 (r/w/o: 23849.10/6968.74/3277.88) lat (ms,95%): 520.62 err/s: 0.00 reconn/s: 0.00
    [ 100s ] thds: 400 tps: 2405.19 qps: 48161.73 (r/w/o: 33711.61/9639.75/4810.37) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 101s ] thds: 400 tps: 2809.91 qps: 54799.20 (r/w/o: 38558.73/10620.65/5619.82) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00
    [ 102s ] thds: 400 tps: 1867.00 qps: 36326.03 (r/w/o: 25621.02/6972.01/3733.00) lat (ms,95%): 390.30 err/s: 0.00 reconn/s: 0.00
    [ 103s ] thds: 400 tps: 2483.98 qps: 51367.62 (r/w/o: 35698.73/10699.92/4968.96) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 104s ] thds: 400 tps: 2228.01 qps: 45228.29 (r/w/o: 31544.20/9228.06/4456.03) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 105s ] thds: 400 tps: 2724.00 qps: 53513.09 (r/w/o: 37706.07/10359.02/5448.01) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
    [ 106s ] thds: 400 tps: 2394.00 qps: 48616.92 (r/w/o: 33828.95/9999.98/4787.99) lat (ms,95%): 277.21 err/s: 0.00 reconn/s: 0.00
    [ 107s ] thds: 400 tps: 2622.99 qps: 49728.85 (r/w/o: 34964.53/9518.33/5245.98) lat (ms,95%): 297.92 err/s: 0.00 reconn/s: 0.00
    [ 108s ] thds: 400 tps: 2189.84 qps: 46078.69 (r/w/o: 32053.30/9649.70/4375.68) lat (ms,95%): 320.17 err/s: 0.00 reconn/s: 0.00
    [ 109s ] thds: 400 tps: 2130.81 qps: 40152.66 (r/w/o: 28409.19/7477.84/4265.63) lat (ms,95%): 356.70 err/s: 0.00 reconn/s: 0.00
    [ 110s ] thds: 400 tps: 1527.21 qps: 32030.49 (r/w/o: 22043.64/6933.43/3053.43) lat (ms,95%): 580.02 err/s: 0.00 reconn/s: 0.00
    [ 111s ] thds: 400 tps: 2372.55 qps: 49223.93 (r/w/o: 34497.10/9980.73/4746.10) lat (ms,95%): 530.08 err/s: 0.00 reconn/s: 0.00
    [ 112s ] thds: 400 tps: 2156.00 qps: 42610.00 (r/w/o: 29765.00/8535.00/4310.00) lat (ms,95%): 397.39 err/s: 0.00 reconn/s: 0.00
    [ 113s ] thds: 400 tps: 2623.98 qps: 52604.53 (r/w/o: 37018.67/10335.91/5249.95) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00
    [ 114s ] thds: 400 tps: 2423.01 qps: 47813.25 (r/w/o: 33414.17/9554.05/4845.03) lat (ms,95%): 303.33 err/s: 0.00 reconn/s: 0.00
    [ 115s ] thds: 400 tps: 2872.00 qps: 54312.01 (r/w/o: 38011.00/10556.00/5745.00) lat (ms,95%): 253.35 err/s: 0.00 reconn/s: 0.00
    [ 116s ] thds: 400 tps: 2138.97 qps: 43920.48 (r/w/o: 30901.64/8740.90/4277.95) lat (ms,95%): 325.98 err/s: 0.00 reconn/s: 0.00
    [ 117s ] thds: 400 tps: 2465.99 qps: 51601.89 (r/w/o: 36002.92/10667.98/4930.99) lat (ms,95%): 253.35 err/s: 0.00 reconn/s: 0.00
    [ 118s ] thds: 400 tps: 2492.02 qps: 46150.40 (r/w/o: 32151.28/9014.08/4985.04) lat (ms,95%): 287.38 err/s: 0.00 reconn/s: 0.00
    [ 119s ] thds: 400 tps: 2617.01 qps: 55708.26 (r/w/o: 39189.18/11288.05/5231.02) lat (ms,95%): 253.35 err/s: 0.00 reconn/s: 0.00
    [ 120s ] thds: 400 tps: 2072.95 qps: 41513.95 (r/w/o: 29077.26/8288.79/4147.89) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            3867430
            write:                           1104977
            other:                           552489
            total:                           5524896
        transactions:                        276244 (2300.32 per sec.)
        queries:                             5524896 (46006.59 per sec.)
        ignored errors:                      1      (0.01 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          120.0883s
        total number of events:              276244
    
    Latency (ms):
             min:                                    4.15
             avg:                                  173.82
             max:                                 1391.59
             95th percentile:                      350.33
             sum:                             48016291.52
    
    Threads fairness:
        events (avg/stddev):           690.6100/10.89
        execution time (avg/stddev):   120.0407/0.02
    
    [yeqiang@harbor sysbench]$