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: 152.98 qps: 2456.74 (r/w/o: 2149.78/0.00/306.96) lat (ms,95%): 1533.66 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 100 tps: 231.12 qps: 3697.39 (r/w/o: 3235.15/0.00/462.24) lat (ms,95%): 893.56 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 100 tps: 235.03 qps: 3760.22 (r/w/o: 3290.16/0.00/470.06) lat (ms,95%): 893.56 err/s: 0.00 reconn/s: 0.00 [ 400s ] thds: 100 tps: 242.37 qps: 3877.76 (r/w/o: 3393.02/0.00/484.74) lat (ms,95%): 877.61 err/s: 0.00 reconn/s: 0.00 [ 500s ] thds: 100 tps: 252.38 qps: 4038.99 (r/w/o: 3534.23/0.00/504.76) lat (ms,95%): 831.46 err/s: 0.00 reconn/s: 0.00 [ 600s ] thds: 100 tps: 248.09 qps: 3968.91 (r/w/o: 3472.73/0.00/496.18) lat (ms,95%): 846.57 err/s: 0.00 reconn/s: 0.00 [ 700s ] thds: 100 tps: 255.85 qps: 4094.04 (r/w/o: 3582.34/0.00/511.70) lat (ms,95%): 831.46 err/s: 0.00 reconn/s: 0.00 [ 800s ] thds: 100 tps: 273.88 qps: 4382.65 (r/w/o: 3834.89/0.00/547.76) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 900s ] thds: 100 tps: 274.56 qps: 4391.92 (r/w/o: 3842.80/0.00/549.13) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 1000s ] thds: 100 tps: 269.63 qps: 4314.51 (r/w/o: 3775.26/0.00/539.25) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 1100s ] thds: 100 tps: 262.96 qps: 4207.48 (r/w/o: 3681.56/0.00/525.92) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 1200s ] thds: 100 tps: 267.91 qps: 4286.11 (r/w/o: 3750.30/0.00/535.81) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 1300s ] thds: 100 tps: 266.78 qps: 4267.55 (r/w/o: 3733.98/0.00/533.57) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 1400s ] thds: 100 tps: 262.83 qps: 4206.75 (r/w/o: 3681.09/0.00/525.66) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 1500s ] thds: 100 tps: 270.61 qps: 4328.92 (r/w/o: 3787.72/0.00/541.20) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 1600s ] thds: 100 tps: 269.66 qps: 4315.32 (r/w/o: 3775.98/0.00/539.34) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 1700s ] thds: 100 tps: 260.75 qps: 4172.28 (r/w/o: 3650.78/0.00/521.50) lat (ms,95%): 831.46 err/s: 0.00 reconn/s: 0.00 [ 1800s ] thds: 100 tps: 261.50 qps: 4183.69 (r/w/o: 3660.69/0.00/523.00) lat (ms,95%): 831.46 err/s: 0.00 reconn/s: 0.00 [ 1900s ] thds: 100 tps: 264.77 qps: 4236.63 (r/w/o: 3707.09/0.00/529.54) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2000s ] thds: 100 tps: 259.55 qps: 4152.46 (r/w/o: 3633.36/0.00/519.10) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2100s ] thds: 100 tps: 259.41 qps: 4150.79 (r/w/o: 3631.97/0.00/518.82) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2200s ] thds: 100 tps: 255.58 qps: 4088.97 (r/w/o: 3577.81/0.00/511.16) lat (ms,95%): 846.57 err/s: 0.00 reconn/s: 0.00 [ 2300s ] thds: 100 tps: 262.39 qps: 4198.65 (r/w/o: 3673.87/0.00/524.78) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 2400s ] thds: 100 tps: 260.12 qps: 4161.36 (r/w/o: 3641.12/0.00/520.24) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2500s ] thds: 100 tps: 266.56 qps: 4264.99 (r/w/o: 3731.87/0.00/533.12) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 2600s ] thds: 100 tps: 259.43 qps: 4150.70 (r/w/o: 3631.84/0.00/518.86) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2700s ] thds: 100 tps: 260.75 qps: 4172.43 (r/w/o: 3650.93/0.00/521.50) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2800s ] thds: 100 tps: 262.18 qps: 4195.20 (r/w/o: 3670.84/0.00/524.36) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00 [ 2900s ] thds: 100 tps: 259.89 qps: 4157.02 (r/w/o: 3637.24/0.00/519.78) lat (ms,95%): 831.46 err/s: 0.00 reconn/s: 0.00 [ 3000s ] thds: 100 tps: 265.51 qps: 4248.92 (r/w/o: 3717.90/0.00/531.02) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 3100s ] thds: 100 tps: 273.57 qps: 4376.84 (r/w/o: 3829.70/0.00/547.14) lat (ms,95%): 787.74 err/s: 0.00 reconn/s: 0.00 [ 3200s ] thds: 100 tps: 274.01 qps: 4384.56 (r/w/o: 3836.54/0.00/548.02) lat (ms,95%): 787.74 err/s: 0.00 reconn/s: 0.00 [ 3300s ] thds: 100 tps: 268.49 qps: 4296.28 (r/w/o: 3759.30/0.00/536.98) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 3400s ] thds: 100 tps: 266.25 qps: 4259.20 (r/w/o: 3726.70/0.00/532.50) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 3500s ] thds: 100 tps: 262.51 qps: 4200.48 (r/w/o: 3675.46/0.00/525.02) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 [ 3600s ] thds: 100 tps: 261.62 qps: 4185.62 (r/w/o: 3662.40/0.00/523.22) lat (ms,95%): 802.05 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 13023458 write: 0 other: 1860494 total: 14883952 transactions: 930247 (258.36 per sec.) queries: 14883952 (4133.81 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3600.5393s total number of events: 930247 Latency (ms): min: 2.17 avg: 387.01 max: 3238.68 95th percentile: 831.46 sum: 360012999.29 Threads fairness: events (avg/stddev): 9302.4700/63.33 execution time (avg/stddev): 3600.1300/0.11