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: 292.28 qps: 4685.03 (r/w/o: 4099.48/0.00/585.55) lat (ms,95%): 773.68 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 100 tps: 418.13 qps: 6689.72 (r/w/o: 5853.45/0.00/836.26) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 100 tps: 421.48 qps: 6743.40 (r/w/o: 5900.47/0.00/842.93) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 400s ] thds: 100 tps: 419.71 qps: 6714.96 (r/w/o: 5875.54/0.00/839.42) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 500s ] thds: 100 tps: 421.97 qps: 6752.53 (r/w/o: 5908.56/0.00/843.97) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 600s ] thds: 100 tps: 416.45 qps: 6661.84 (r/w/o: 5829.01/0.00/832.83) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 700s ] thds: 100 tps: 419.40 qps: 6710.42 (r/w/o: 5871.59/0.00/838.83) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 800s ] thds: 100 tps: 414.00 qps: 6624.60 (r/w/o: 5796.55/0.00/828.05) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00 [ 900s ] thds: 100 tps: 421.83 qps: 6749.55 (r/w/o: 5905.91/0.00/843.64) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 1000s ] thds: 100 tps: 419.44 qps: 6711.49 (r/w/o: 5872.60/0.00/838.89) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00 [ 1100s ] thds: 100 tps: 388.76 qps: 6219.71 (r/w/o: 5442.21/0.00/777.50) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00 [ 1200s ] thds: 100 tps: 387.65 qps: 6202.55 (r/w/o: 5427.27/0.00/775.28) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 1300s ] thds: 100 tps: 386.11 qps: 6178.05 (r/w/o: 5405.80/0.00/772.25) lat (ms,95%): 458.96 err/s: 0.00 reconn/s: 0.00 [ 1400s ] thds: 100 tps: 388.73 qps: 6219.20 (r/w/o: 5441.74/0.00/777.46) lat (ms,95%): 458.96 err/s: 0.00 reconn/s: 0.00 [ 1500s ] thds: 100 tps: 362.76 qps: 5804.31 (r/w/o: 5078.76/0.00/725.55) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 1600s ] thds: 100 tps: 419.93 qps: 6718.30 (r/w/o: 5878.47/0.00/839.83) lat (ms,95%): 458.96 err/s: 0.00 reconn/s: 0.00 [ 1700s ] thds: 100 tps: 425.14 qps: 6802.82 (r/w/o: 5952.53/0.00/850.29) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 1800s ] thds: 100 tps: 393.36 qps: 6293.23 (r/w/o: 5506.55/0.00/786.68) lat (ms,95%): 502.20 err/s: 0.00 reconn/s: 0.00 [ 1900s ] thds: 100 tps: 363.75 qps: 5819.72 (r/w/o: 5092.20/0.00/727.52) lat (ms,95%): 484.44 err/s: 0.00 reconn/s: 0.00 [ 2000s ] thds: 100 tps: 408.20 qps: 6531.88 (r/w/o: 5715.46/0.00/816.42) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 2100s ] thds: 100 tps: 393.35 qps: 6293.36 (r/w/o: 5506.68/0.00/786.68) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 2200s ] thds: 100 tps: 355.39 qps: 5685.51 (r/w/o: 4974.74/0.00/710.77) lat (ms,95%): 520.62 err/s: 0.00 reconn/s: 0.00 [ 2300s ] thds: 100 tps: 416.77 qps: 6669.32 (r/w/o: 5835.76/0.00/833.56) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 2400s ] thds: 100 tps: 256.11 qps: 4097.92 (r/w/o: 3585.68/0.00/512.24) lat (ms,95%): 719.92 err/s: 0.00 reconn/s: 0.00 [ 2500s ] thds: 100 tps: 288.50 qps: 4615.70 (r/w/o: 4038.72/0.00/576.98) lat (ms,95%): 539.71 err/s: 0.00 reconn/s: 0.00 [ 2600s ] thds: 100 tps: 364.78 qps: 5836.38 (r/w/o: 5106.82/0.00/729.56) lat (ms,95%): 484.44 err/s: 0.00 reconn/s: 0.00 [ 2700s ] thds: 100 tps: 408.37 qps: 6534.20 (r/w/o: 5717.46/0.00/816.74) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 2800s ] thds: 100 tps: 421.61 qps: 6745.91 (r/w/o: 5902.66/0.00/843.25) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 2900s ] thds: 100 tps: 415.78 qps: 6652.86 (r/w/o: 5821.33/0.00/831.53) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 3000s ] thds: 100 tps: 417.38 qps: 6677.11 (r/w/o: 5842.36/0.00/834.75) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 3100s ] thds: 100 tps: 412.60 qps: 6602.11 (r/w/o: 5776.88/0.00/825.23) lat (ms,95%): 467.30 err/s: 0.00 reconn/s: 0.00 [ 3200s ] thds: 100 tps: 375.03 qps: 6000.64 (r/w/o: 5250.60/0.00/750.04) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00 [ 3300s ] thds: 100 tps: 355.12 qps: 5681.94 (r/w/o: 4971.70/0.00/710.24) lat (ms,95%): 493.24 err/s: 0.00 reconn/s: 0.00 [ 3400s ] thds: 100 tps: 374.33 qps: 5988.25 (r/w/o: 5239.60/0.00/748.65) lat (ms,95%): 511.33 err/s: 0.00 reconn/s: 0.00 [ 3500s ] thds: 100 tps: 412.78 qps: 6605.56 (r/w/o: 5779.98/0.00/825.58) lat (ms,95%): 458.96 err/s: 0.00 reconn/s: 0.00 [ 3600s ] thds: 100 tps: 390.10 qps: 6241.18 (r/w/o: 5461.00/0.00/780.18) lat (ms,95%): 484.44 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 19667326 write: 0 other: 2809618 total: 22476944 transactions: 1404809 (390.07 per sec.) queries: 22476944 (6241.10 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3601.4390s total number of events: 1404809 Latency (ms): min: 64.72 avg: 256.31 max: 6516.21 95th percentile: 493.24 sum: 360060603.30 Threads fairness: events (avg/stddev): 14048.0900/77.02 execution time (avg/stddev): 3600.6060/0.39