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: 59.71 qps: 1208.95 (r/w/o: 847.59/240.94/120.42) lat (ms,95%): 3386.99 err/s: 0.00 reconn/s: 0.00 [ 200s ] thds: 100 tps: 58.24 qps: 1167.63 (r/w/o: 817.37/233.78/116.48) lat (ms,95%): 3095.38 err/s: 0.00 reconn/s: 0.00 [ 300s ] thds: 100 tps: 58.89 qps: 1173.65 (r/w/o: 821.52/234.35/117.78) lat (ms,95%): 3448.53 err/s: 0.00 reconn/s: 0.00 [ 400s ] thds: 100 tps: 56.01 qps: 1122.29 (r/w/o: 785.94/224.33/112.02) lat (ms,95%): 4203.93 err/s: 0.00 reconn/s: 0.00 [ 500s ] thds: 100 tps: 53.17 qps: 1065.88 (r/w/o: 745.67/213.87/106.34) lat (ms,95%): 4280.32 err/s: 0.00 reconn/s: 0.00 [ 600s ] thds: 100 tps: 61.54 qps: 1224.20 (r/w/o: 856.50/244.62/123.08) lat (ms,95%): 3911.79 err/s: 0.00 reconn/s: 0.00 [ 700s ] thds: 100 tps: 67.55 qps: 1357.39 (r/w/o: 950.72/271.57/135.10) lat (ms,95%): 3386.99 err/s: 0.00 reconn/s: 0.00 [ 800s ] thds: 100 tps: 56.51 qps: 1128.34 (r/w/o: 790.37/224.95/113.02) lat (ms,95%): 4203.93 err/s: 0.00 reconn/s: 0.00 [ 900s ] thds: 100 tps: 62.11 qps: 1238.33 (r/w/o: 866.94/247.17/124.22) lat (ms,95%): 3208.88 err/s: 0.00 reconn/s: 0.00 [ 1000s ] thds: 100 tps: 78.83 qps: 1576.55 (r/w/o: 1102.71/316.19/157.66) lat (ms,95%): 2159.29 err/s: 0.00 reconn/s: 0.00 [ 1100s ] thds: 100 tps: 84.98 qps: 1700.17 (r/w/o: 1190.51/339.69/169.96) lat (ms,95%): 2585.31 err/s: 0.00 reconn/s: 0.00 [ 1200s ] thds: 100 tps: 79.48 qps: 1589.99 (r/w/o: 1113.33/317.70/158.96) lat (ms,95%): 2778.39 err/s: 0.00 reconn/s: 0.00 [ 1300s ] thds: 100 tps: 82.62 qps: 1649.09 (r/w/o: 1154.02/329.83/165.24) lat (ms,95%): 2632.28 err/s: 0.00 reconn/s: 0.00 [ 1400s ] thds: 100 tps: 78.76 qps: 1579.63 (r/w/o: 1106.42/315.70/157.52) lat (ms,95%): 2778.39 err/s: 0.00 reconn/s: 0.00 [ 1500s ] thds: 100 tps: 67.06 qps: 1340.01 (r/w/o: 937.81/268.08/134.12) lat (ms,95%): 3511.19 err/s: 0.00 reconn/s: 0.00 [ 1600s ] thds: 100 tps: 73.18 qps: 1463.67 (r/w/o: 1024.85/292.47/146.36) lat (ms,95%): 2985.89 err/s: 0.00 reconn/s: 0.00 [ 1700s ] thds: 100 tps: 73.52 qps: 1468.98 (r/w/o: 1027.71/294.22/147.04) lat (ms,95%): 2932.60 err/s: 0.00 reconn/s: 0.00 [ 1800s ] thds: 100 tps: 78.59 qps: 1573.20 (r/w/o: 1101.67/314.35/157.18) lat (ms,95%): 2828.87 err/s: 0.00 reconn/s: 0.00 [ 1900s ] thds: 100 tps: 77.32 qps: 1546.99 (r/w/o: 1082.97/309.38/154.64) lat (ms,95%): 2828.87 err/s: 0.00 reconn/s: 0.00 [ 2000s ] thds: 100 tps: 70.91 qps: 1418.55 (r/w/o: 993.03/283.69/141.83) lat (ms,95%): 2985.89 err/s: 0.00 reconn/s: 0.00 [ 2100s ] thds: 100 tps: 73.78 qps: 1473.85 (r/w/o: 1031.30/294.99/147.55) lat (ms,95%): 3040.14 err/s: 0.00 reconn/s: 0.00 [ 2200s ] thds: 100 tps: 80.82 qps: 1617.83 (r/w/o: 1132.42/323.77/161.64) lat (ms,95%): 2632.28 err/s: 0.00 reconn/s: 0.00 [ 2300s ] thds: 100 tps: 74.06 qps: 1480.58 (r/w/o: 1036.78/295.68/148.12) lat (ms,95%): 2932.60 err/s: 0.00 reconn/s: 0.00 [ 2400s ] thds: 100 tps: 70.34 qps: 1407.35 (r/w/o: 985.03/281.64/140.68) lat (ms,95%): 3326.55 err/s: 0.00 reconn/s: 0.00 [ 2500s ] thds: 100 tps: 76.55 qps: 1531.52 (r/w/o: 1071.82/306.60/153.10) lat (ms,95%): 3095.38 err/s: 0.00 reconn/s: 0.00 [ 2600s ] thds: 100 tps: 77.48 qps: 1548.42 (r/w/o: 1084.20/309.26/154.96) lat (ms,95%): 2828.87 err/s: 0.00 reconn/s: 0.00 [ 2700s ] thds: 100 tps: 77.68 qps: 1551.72 (r/w/o: 1085.85/310.51/155.36) lat (ms,95%): 2932.60 err/s: 0.00 reconn/s: 0.00 [ 2800s ] thds: 100 tps: 80.47 qps: 1614.42 (r/w/o: 1130.15/323.33/160.94) lat (ms,95%): 2728.81 err/s: 0.00 reconn/s: 0.00 [ 2900s ] thds: 100 tps: 77.42 qps: 1546.34 (r/w/o: 1083.11/308.40/154.84) lat (ms,95%): 2728.81 err/s: 0.00 reconn/s: 0.00 [ 3000s ] thds: 100 tps: 81.10 qps: 1619.90 (r/w/o: 1133.45/324.24/162.20) lat (ms,95%): 2728.81 err/s: 0.00 reconn/s: 0.00 [ 3100s ] thds: 100 tps: 84.13 qps: 1685.48 (r/w/o: 1180.46/336.76/168.26) lat (ms,95%): 2632.28 err/s: 0.00 reconn/s: 0.00 [ 3200s ] thds: 100 tps: 82.62 qps: 1647.24 (r/w/o: 1152.02/329.98/165.24) lat (ms,95%): 2728.81 err/s: 0.00 reconn/s: 0.00 [ 3300s ] thds: 100 tps: 91.17 qps: 1828.65 (r/w/o: 1280.42/365.89/182.34) lat (ms,95%): 2449.36 err/s: 0.00 reconn/s: 0.00 [ 3400s ] thds: 100 tps: 91.34 qps: 1826.74 (r/w/o: 1277.61/366.45/182.68) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 3500s ] thds: 100 tps: 92.46 qps: 1847.27 (r/w/o: 1294.15/368.21/184.92) lat (ms,95%): 2449.36 err/s: 0.00 reconn/s: 0.00 [ 3600s ] thds: 100 tps: 94.11 qps: 1879.88 (r/w/o: 1315.62/376.04/188.22) lat (ms,95%): 2585.31 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 3759714 write: 1074204 other: 537102 total: 5371020 transactions: 268551 (74.54 per sec.) queries: 5371020 (1490.77 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 3602.8388s total number of events: 268551 Latency (ms): min: 4.34 avg: 1340.87 max: 9432.73 95th percentile: 2985.89 sum: 360091912.45 Threads fairness: events (avg/stddev): 2685.5100/27.42 execution time (avg/stddev): 3600.9191/0.41