sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 100 Report intermediate results every 100 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 100s ] thds: 100 tps: 209.37 qps: 209.37 (r/w/o: 0.00/133.50/75.87) lat (ms,95%): 1170.65 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 100 tps: 164.96 qps: 164.96 (r/w/o: 0.00/105.02/59.94) lat (ms,95%): 1280.93 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 100 tps: 164.36 qps: 164.36 (r/w/o: 0.00/104.10/60.26) lat (ms,95%): 1280.93 err/s: 0.00 reconn/s: 0.00 [ 400s ] thds: 100 tps: 151.34 qps: 151.34 (r/w/o: 0.00/97.01/54.33) lat (ms,95%): 1352.03 err/s: 0.00 reconn/s: 0.00 [ 500s ] thds: 100 tps: 147.38 qps: 147.38 (r/w/o: 0.00/93.80/53.58) lat (ms,95%): 1376.60 err/s: 0.00 reconn/s: 0.00 [ 600s ] thds: 100 tps: 144.89 qps: 144.89 (r/w/o: 0.00/91.76/53.13) lat (ms,95%): 1401.61 err/s: 0.00 reconn/s: 0.00 [ 700s ] thds: 100 tps: 138.71 qps: 138.71 (r/w/o: 0.00/88.53/50.18) lat (ms,95%): 1427.08 err/s: 0.00 reconn/s: 0.00 [ 800s ] thds: 100 tps: 132.92 qps: 132.92 (r/w/o: 0.00/85.50/47.42) lat (ms,95%): 1453.01 err/s: 0.00 reconn/s: 0.00 [ 900s ] thds: 100 tps: 134.24 qps: 134.24 (r/w/o: 0.00/86.18/48.06) lat (ms,95%): 1479.41 err/s: 0.00 reconn/s: 0.00 [ 1000s ] thds: 100 tps: 132.20 qps: 132.20 (r/w/o: 0.00/82.85/49.35) lat (ms,95%): 1506.29 err/s: 0.00 reconn/s: 0.00 [ 1100s ] thds: 100 tps: 125.73 qps: 125.73 (r/w/o: 0.00/79.88/45.85) lat (ms,95%): 1533.66 err/s: 0.00 reconn/s: 0.00 [ 1200s ] thds: 100 tps: 121.79 qps: 121.79 (r/w/o: 0.00/77.10/44.69) lat (ms,95%): 1561.52 err/s: 0.00 reconn/s: 0.00 [ 1300s ] thds: 100 tps: 118.65 qps: 118.65 (r/w/o: 0.00/74.87/43.78) lat (ms,95%): 1589.90 err/s: 0.00 reconn/s: 0.00 [ 1400s ] thds: 100 tps: 115.51 qps: 115.51 (r/w/o: 0.00/74.59/40.92) lat (ms,95%): 1618.78 err/s: 0.00 reconn/s: 0.00 [ 1500s ] thds: 100 tps: 113.47 qps: 113.47 (r/w/o: 0.00/73.15/40.32) lat (ms,95%): 1648.20 err/s: 0.00 reconn/s: 0.00 [ 1600s ] thds: 100 tps: 114.71 qps: 114.71 (r/w/o: 0.00/72.97/41.74) lat (ms,95%): 1648.20 err/s: 0.00 reconn/s: 0.00 [ 1700s ] thds: 100 tps: 113.23 qps: 113.23 (r/w/o: 0.00/72.42/40.81) lat (ms,95%): 1648.20 err/s: 0.00 reconn/s: 0.00 [ 1800s ] thds: 100 tps: 106.66 qps: 106.66 (r/w/o: 0.00/67.73/38.93) lat (ms,95%): 1708.63 err/s: 0.00 reconn/s: 0.00 [ 1900s ] thds: 100 tps: 108.47 qps: 108.47 (r/w/o: 0.00/69.31/39.16) lat (ms,95%): 1678.14 err/s: 0.00 reconn/s: 0.00 [ 2000s ] thds: 100 tps: 105.95 qps: 105.95 (r/w/o: 0.00/67.41/38.54) lat (ms,95%): 1708.63 err/s: 0.00 reconn/s: 0.00 [ 2100s ] thds: 100 tps: 103.65 qps: 103.65 (r/w/o: 0.00/65.73/37.92) lat (ms,95%): 1739.68 err/s: 0.00 reconn/s: 0.00 [ 2200s ] thds: 100 tps: 101.69 qps: 101.69 (r/w/o: 0.00/64.99/36.70) lat (ms,95%): 1771.29 err/s: 0.00 reconn/s: 0.00 [ 2300s ] thds: 100 tps: 99.40 qps: 99.40 (r/w/o: 0.00/62.93/36.47) lat (ms,95%): 1771.29 err/s: 0.00 reconn/s: 0.00 [ 2400s ] thds: 100 tps: 99.94 qps: 99.94 (r/w/o: 0.00/64.78/35.16) lat (ms,95%): 1771.29 err/s: 0.00 reconn/s: 0.00 [ 2500s ] thds: 100 tps: 97.89 qps: 97.89 (r/w/o: 0.00/61.98/35.91) lat (ms,95%): 1836.24 err/s: 0.00 reconn/s: 0.00 [ 2600s ] thds: 100 tps: 96.73 qps: 96.73 (r/w/o: 0.00/61.99/34.74) lat (ms,95%): 1836.24 err/s: 0.00 reconn/s: 0.00 [ 2700s ] thds: 100 tps: 97.98 qps: 97.98 (r/w/o: 0.00/62.86/35.12) lat (ms,95%): 1803.47 err/s: 0.00 reconn/s: 0.00 [ 2800s ] thds: 100 tps: 95.77 qps: 95.77 (r/w/o: 0.00/61.33/34.44) lat (ms,95%): 1836.24 err/s: 0.00 reconn/s: 0.00 [ 2900s ] thds: 100 tps: 93.83 qps: 93.83 (r/w/o: 0.00/59.08/34.75) lat (ms,95%): 1869.60 err/s: 0.00 reconn/s: 0.00 [ 3000s ] thds: 100 tps: 97.71 qps: 97.71 (r/w/o: 0.00/61.78/35.93) lat (ms,95%): 1869.60 err/s: 0.00 reconn/s: 0.00 [ 3100s ] thds: 100 tps: 94.88 qps: 94.88 (r/w/o: 0.00/61.19/33.69) lat (ms,95%): 1869.60 err/s: 0.00 reconn/s: 0.00 [ 3200s ] thds: 100 tps: 92.95 qps: 92.95 (r/w/o: 0.00/59.45/33.50) lat (ms,95%): 1869.60 err/s: 0.00 reconn/s: 0.00 [ 3300s ] thds: 100 tps: 93.76 qps: 93.76 (r/w/o: 0.00/59.74/34.02) lat (ms,95%): 1869.60 err/s: 0.00 reconn/s: 0.00 [ 3400s ] thds: 100 tps: 93.26 qps: 93.26 (r/w/o: 0.00/59.35/33.91) lat (ms,95%): 1869.60 err/s: 0.00 reconn/s: 0.00 [ 3500s ] thds: 100 tps: 90.56 qps: 90.56 (r/w/o: 0.00/57.88/32.68) lat (ms,95%): 1938.16 err/s: 0.00 reconn/s: 0.00 [ 3600s ] thds: 100 tps: 92.97 qps: 92.97 (r/w/o: 0.00/58.26/34.71) lat (ms,95%): 1938.16 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 0 write: 268173 other: 152679 total: 420852 transactions: 420852 (116.85 per sec.) queries: 420852 (116.85 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3601.6853s total number of events: 420852 Latency (ms): min: 0.17 avg: 855.58 max: 3845.94 95th percentile: 1678.14 sum: 360073485.92 Threads fairness: events (avg/stddev): 4208.5200/27.68 execution time (avg/stddev): 3600.7349/0.48