sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 1 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 1 tps: 0.60 qps: 0.60 (r/w/o: 0.60/0.00/0.00) lat (ms,95%): 3982.86 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 1 tps: 0.60 qps: 0.60 (r/w/o: 0.60/0.00/0.00) lat (ms,95%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 1 tps: 1.20 qps: 1.20 (r/w/o: 1.20/0.00/0.00) lat (ms,95%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 1 tps: 0.60 qps: 0.60 (r/w/o: 0.60/0.00/0.00) lat (ms,95%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 1 tps: 0.90 qps: 0.90 (r/w/o: 0.90/0.00/0.00) lat (ms,95%): 3982.86 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 1 tps: 0.90 qps: 0.90 (r/w/o: 0.90/0.00/0.00) lat (ms,95%): 3982.86 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 1 tps: 0.90 qps: 0.90 (r/w/o: 0.90/0.00/0.00) lat (ms,95%): 3982.86 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 1 tps: 0.90 qps: 0.90 (r/w/o: 0.90/0.00/0.00) lat (ms,95%): 3911.79 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 1 tps: 0.60 qps: 0.60 (r/w/o: 0.60/0.00/0.00) lat (ms,95%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 1 tps: 0.90 qps: 0.90 (r/w/o: 0.90/0.00/0.00) lat (ms,95%): 3773.42 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 82 write: 0 other: 0 total: 82 transactions: 82 (0.80 per sec.) queries: 82 (0.80 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.3507s total number of events: 82 Latency (ms): min: 143.53 avg: 1248.17 max: 4205.33 95th percentile: 3982.86 sum: 102349.84 Threads fairness: events (avg/stddev): 82.0000/0.00 execution time (avg/stddev): 102.3498/0.00 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 2 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 2 tps: 6.60 qps: 6.60 (r/w/o: 6.60/0.00/0.00) lat (ms,95%): 707.07 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 2 tps: 6.80 qps: 6.80 (r/w/o: 6.80/0.00/0.00) lat (ms,95%): 2045.74 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 2 tps: 5.70 qps: 5.70 (r/w/o: 5.70/0.00/0.00) lat (ms,95%): 1235.62 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 2 tps: 5.70 qps: 5.70 (r/w/o: 5.70/0.00/0.00) lat (ms,95%): 2279.14 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 2 tps: 5.90 qps: 5.90 (r/w/o: 5.90/0.00/0.00) lat (ms,95%): 2320.55 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 2 tps: 6.60 qps: 6.60 (r/w/o: 6.60/0.00/0.00) lat (ms,95%): 1213.57 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 2 tps: 6.10 qps: 6.10 (r/w/o: 6.10/0.00/0.00) lat (ms,95%): 1213.57 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 2 tps: 6.00 qps: 6.00 (r/w/o: 6.00/0.00/0.00) lat (ms,95%): 2320.55 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 2 tps: 5.90 qps: 5.90 (r/w/o: 5.90/0.00/0.00) lat (ms,95%): 2362.72 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 2 tps: 5.80 qps: 5.80 (r/w/o: 5.80/0.00/0.00) lat (ms,95%): 1213.57 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 613 write: 0 other: 0 total: 613 transactions: 613 (5.94 per sec.) queries: 613 (5.94 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 103.2155s total number of events: 613 Latency (ms): min: 140.70 avg: 332.24 max: 4050.06 95th percentile: 2320.55 sum: 203661.34 Threads fairness: events (avg/stddev): 306.5000/26.50 execution time (avg/stddev): 101.8307/1.38 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 4 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 4 tps: 21.10 qps: 21.10 (r/w/o: 21.10/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 4 tps: 20.60 qps: 20.60 (r/w/o: 20.60/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 4 tps: 20.70 qps: 20.70 (r/w/o: 20.70/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 4 tps: 20.90 qps: 20.90 (r/w/o: 20.90/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 4 tps: 19.60 qps: 19.60 (r/w/o: 19.60/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 4 tps: 20.50 qps: 20.50 (r/w/o: 20.50/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 4 tps: 19.90 qps: 19.90 (r/w/o: 19.90/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 4 tps: 20.00 qps: 20.00 (r/w/o: 20.00/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 4 tps: 20.70 qps: 20.70 (r/w/o: 20.70/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 4 tps: 20.80 qps: 20.80 (r/w/o: 20.80/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 2052 write: 0 other: 0 total: 2052 transactions: 2052 (20.28 per sec.) queries: 2052 (20.28 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 101.1640s total number of events: 2052 Latency (ms): min: 137.99 avg: 195.59 max: 4096.44 95th percentile: 142.39 sum: 401357.00 Threads fairness: events (avg/stddev): 513.0000/29.32 execution time (avg/stddev): 100.3393/0.48 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 8 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 8 tps: 46.49 qps: 46.49 (r/w/o: 46.49/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 8 tps: 49.30 qps: 49.30 (r/w/o: 49.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 8 tps: 49.50 qps: 49.50 (r/w/o: 49.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 8 tps: 49.60 qps: 49.60 (r/w/o: 49.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 8 tps: 48.60 qps: 48.60 (r/w/o: 48.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 8 tps: 46.30 qps: 46.30 (r/w/o: 46.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 8 tps: 48.80 qps: 48.80 (r/w/o: 48.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 8 tps: 48.60 qps: 48.60 (r/w/o: 48.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 8 tps: 46.90 qps: 46.90 (r/w/o: 46.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 8 tps: 48.00 qps: 48.00 (r/w/o: 48.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 4829 write: 0 other: 0 total: 4829 transactions: 4829 (47.32 per sec.) queries: 4829 (47.32 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.0416s total number of events: 4829 Latency (ms): min: 138.37 avg: 166.22 max: 4946.29 95th percentile: 144.97 sum: 802687.04 Threads fairness: events (avg/stddev): 603.6250/33.98 execution time (avg/stddev): 100.3359/0.65 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 16 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 16 tps: 99.98 qps: 99.98 (r/w/o: 99.98/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 16 tps: 106.21 qps: 106.21 (r/w/o: 106.21/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 16 tps: 103.90 qps: 103.90 (r/w/o: 103.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 16 tps: 106.40 qps: 106.40 (r/w/o: 106.40/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 16 tps: 102.40 qps: 102.40 (r/w/o: 102.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 16 tps: 105.60 qps: 105.60 (r/w/o: 105.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 16 tps: 104.10 qps: 104.10 (r/w/o: 104.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 16 tps: 105.40 qps: 105.40 (r/w/o: 105.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 16 tps: 106.39 qps: 106.39 (r/w/o: 106.39/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 16 tps: 105.60 qps: 105.60 (r/w/o: 105.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 10476 write: 0 other: 0 total: 10476 transactions: 10476 (102.72 per sec.) queries: 10476 (102.72 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 101.9825s total number of events: 10476 Latency (ms): min: 138.85 avg: 153.02 max: 4943.94 95th percentile: 144.97 sum: 1603053.66 Threads fairness: events (avg/stddev): 654.7500/33.13 execution time (avg/stddev): 100.1909/0.46 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 32 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 32 tps: 210.07 qps: 210.07 (r/w/o: 210.07/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 32 tps: 217.40 qps: 217.40 (r/w/o: 217.40/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 32 tps: 214.01 qps: 214.01 (r/w/o: 214.01/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 32 tps: 217.40 qps: 217.40 (r/w/o: 217.40/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 32 tps: 217.20 qps: 217.20 (r/w/o: 217.20/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 32 tps: 214.80 qps: 214.80 (r/w/o: 214.80/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 32 tps: 215.00 qps: 215.00 (r/w/o: 215.00/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 32 tps: 215.10 qps: 215.10 (r/w/o: 215.10/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 32 tps: 215.60 qps: 215.60 (r/w/o: 215.60/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 32 tps: 214.30 qps: 214.30 (r/w/o: 214.30/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 21540 write: 0 other: 0 total: 21540 transactions: 21540 (207.19 per sec.) queries: 21540 (207.19 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 103.9642s total number of events: 21540 Latency (ms): min: 137.53 avg: 148.84 max: 6051.57 95th percentile: 142.39 sum: 3206068.95 Threads fairness: events (avg/stddev): 673.1250/21.87 execution time (avg/stddev): 100.1897/0.68 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 64 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 64 tps: 425.75 qps: 425.75 (r/w/o: 425.75/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 64 tps: 438.81 qps: 438.81 (r/w/o: 438.81/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 64 tps: 438.70 qps: 438.70 (r/w/o: 438.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 64 tps: 438.40 qps: 438.40 (r/w/o: 438.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 64 tps: 439.50 qps: 439.50 (r/w/o: 439.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 64 tps: 438.00 qps: 438.00 (r/w/o: 438.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 64 tps: 438.08 qps: 438.08 (r/w/o: 438.08/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 64 tps: 437.99 qps: 437.99 (r/w/o: 437.99/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 64 tps: 438.62 qps: 438.62 (r/w/o: 438.62/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 64 tps: 438.40 qps: 438.40 (r/w/o: 438.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 43787 write: 0 other: 0 total: 43787 transactions: 43787 (418.62 per sec.) queries: 43787 (418.62 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 104.5977s total number of events: 43787 Latency (ms): min: 136.79 avg: 146.40 max: 7111.76 95th percentile: 144.97 sum: 6410249.65 Threads fairness: events (avg/stddev): 684.1719/21.93 execution time (avg/stddev): 100.1602/0.58 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 128 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 128 tps: 828.10 qps: 828.10 (r/w/o: 828.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 128 tps: 888.02 qps: 888.02 (r/w/o: 888.02/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 128 tps: 891.20 qps: 891.20 (r/w/o: 891.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 128 tps: 888.26 qps: 888.26 (r/w/o: 888.26/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 128 tps: 888.74 qps: 888.74 (r/w/o: 888.74/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 128 tps: 887.80 qps: 887.80 (r/w/o: 887.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 128 tps: 890.00 qps: 890.00 (r/w/o: 890.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 128 tps: 889.16 qps: 889.16 (r/w/o: 889.16/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 128 tps: 891.45 qps: 891.45 (r/w/o: 891.45/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 128 tps: 887.59 qps: 887.59 (r/w/o: 887.59/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 88432 write: 0 other: 0 total: 88432 transactions: 88432 (878.61 per sec.) queries: 88432 (878.61 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 100.6491s total number of events: 88432 Latency (ms): min: 137.01 avg: 144.85 max: 10509.34 95th percentile: 144.97 sum: 12809532.55 Threads fairness: events (avg/stddev): 690.8750/24.87 execution time (avg/stddev): 100.0745/0.08 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 151 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 151 tps: 995.38 qps: 995.38 (r/w/o: 995.38/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 151 tps: 1049.83 qps: 1049.83 (r/w/o: 1049.83/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 151 tps: 1047.30 qps: 1047.30 (r/w/o: 1047.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 151 tps: 1048.80 qps: 1048.80 (r/w/o: 1048.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 151 tps: 1047.90 qps: 1047.90 (r/w/o: 1047.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 151 tps: 1049.90 qps: 1049.90 (r/w/o: 1049.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 151 tps: 1049.49 qps: 1049.49 (r/w/o: 1049.49/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 151 tps: 1048.40 qps: 1048.40 (r/w/o: 1048.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 151 tps: 1049.40 qps: 1049.40 (r/w/o: 1049.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 151 tps: 1052.10 qps: 1052.10 (r/w/o: 1052.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 104536 write: 0 other: 0 total: 104536 transactions: 104536 (1021.16 per sec.) queries: 104536 (1021.16 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.3693s total number of events: 104536 Latency (ms): min: 136.73 avg: 144.58 max: 8710.94 95th percentile: 144.97 sum: 15113457.73 Threads fairness: events (avg/stddev): 692.2914/21.91 execution time (avg/stddev): 100.0891/0.21 sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3) perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Running the test with following options: Number of threads: 152 Report intermediate results every 3 second(s) Initializing random number generator from current time Initializing worker threads... perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sqlperftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! FATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT SUM(l_extendedprice * l_discount) AS revenue FROM LINEITEM WHERE l_shipdate >= DATE '1994-01-01' AND l_shipdate < DATE '1994-01-01' + INTERVAL '1' YEAR AND l_discount BETWEEN .06 - 0.01 AND .06 + 0.01 AND l_quantity < 24;' FATAL: `thread_run' function failed: perftest.lua:87: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query [ 3s ] thds: 148 tps: 83.96 qps: 83.96 (r/w/o: 83.96/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.33 reconn/s: 0.00 [ 6s ] thds: 148 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 148 tps: 0.00 qps: 0.00 (r/w/o: 0.00/0.00/0.00) lat (ms,95%): 0.00 err/s: 0.00 reconn/s: 0.00