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: 1.20 qps: 1.20 (r/w/o: 1.20/0.00/0.00) lat (ms,95%): 2449.36 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 1 tps: 1.20 qps: 1.20 (r/w/o: 1.20/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 1 tps: 2.00 qps: 2.00 (r/w/o: 2.00/0.00/0.00) lat (ms,95%): 3773.42 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 1 tps: 1.20 qps: 1.20 (r/w/o: 1.20/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 1 tps: 1.60 qps: 1.60 (r/w/o: 1.60/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 1 tps: 1.20 qps: 1.20 (r/w/o: 1.20/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 1 tps: 1.60 qps: 1.60 (r/w/o: 1.60/0.00/0.00) lat (ms,95%): 3773.42 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 1 tps: 1.60 qps: 1.60 (r/w/o: 1.60/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 1 tps: 1.60 qps: 1.60 (r/w/o: 1.60/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 1 tps: 1.20 qps: 1.20 (r/w/o: 1.20/0.00/0.00) lat (ms,95%): 2405.65 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 145 write: 0 other: 0 total: 145 transactions: 145 (1.42 per sec.) queries: 145 (1.42 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 101.9775s total number of events: 145 Latency (ms): min: 143.44 avg: 703.29 max: 3795.64 95th percentile: 3773.42 sum: 101976.63 Threads fairness: events (avg/stddev): 145.0000/0.00 execution time (avg/stddev): 101.9766/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: 7.10 qps: 7.10 (r/w/o: 7.10/0.00/0.00) lat (ms,95%): 142.39 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%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 30s ] 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 [ 40s ] thds: 2 tps: 6.40 qps: 6.40 (r/w/o: 6.40/0.00/0.00) lat (ms,95%): 2159.29 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 2 tps: 5.70 qps: 5.70 (r/w/o: 5.70/0.00/0.00) lat (ms,95%): 1170.65 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 2 tps: 5.90 qps: 5.90 (r/w/o: 5.90/0.00/0.00) lat (ms,95%): 2120.76 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 2 tps: 6.50 qps: 6.50 (r/w/o: 6.50/0.00/0.00) lat (ms,95%): 2159.29 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 2 tps: 6.70 qps: 6.70 (r/w/o: 6.70/0.00/0.00) lat (ms,95%): 1191.92 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 2 tps: 6.60 qps: 6.60 (r/w/o: 6.60/0.00/0.00) lat (ms,95%): 1235.62 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 2 tps: 6.00 qps: 6.00 (r/w/o: 6.00/0.00/0.00) lat (ms,95%): 2120.76 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 639 write: 0 other: 0 total: 639 transactions: 639 (6.33 per sec.) queries: 639 (6.33 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 100.9333s total number of events: 639 Latency (ms): min: 140.47 avg: 314.63 max: 4174.86 95th percentile: 2159.29 sum: 201048.45 Threads fairness: events (avg/stddev): 319.5000/18.50 execution time (avg/stddev): 100.5242/0.41 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: 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 [ 20s ] 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 [ 30s ] 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 [ 40s ] 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 [ 50s ] 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 [ 60s ] thds: 4 tps: 19.80 qps: 19.80 (r/w/o: 19.80/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 70s ] 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 [ 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: 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 [ 100s ] 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 SQL statistics: queries performed: read: 2052 write: 0 other: 0 total: 2052 transactions: 2052 (20.04 per sec.) queries: 2052 (20.04 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.3924s total number of events: 2052 Latency (ms): min: 142.30 avg: 196.22 max: 4202.89 95th percentile: 142.39 sum: 402634.65 Threads fairness: events (avg/stddev): 513.0000/47.95 execution time (avg/stddev): 100.6587/1.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: 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.29 qps: 46.29 (r/w/o: 46.29/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] 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 [ 30s ] 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 [ 40s ] thds: 8 tps: 48.40 qps: 48.40 (r/w/o: 48.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 8 tps: 48.30 qps: 48.30 (r/w/o: 48.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 8 tps: 47.80 qps: 47.80 (r/w/o: 47.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 8 tps: 47.90 qps: 47.90 (r/w/o: 47.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 8 tps: 48.40 qps: 48.40 (r/w/o: 48.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 8 tps: 46.70 qps: 46.70 (r/w/o: 46.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 8 tps: 48.20 qps: 48.20 (r/w/o: 48.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 4804 write: 0 other: 0 total: 4804 transactions: 4804 (47.85 per sec.) queries: 4804 (47.85 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 100.3952s total number of events: 4804 Latency (ms): min: 139.29 avg: 166.70 max: 4227.52 95th percentile: 144.97 sum: 800849.91 Threads fairness: events (avg/stddev): 600.5000/36.88 execution time (avg/stddev): 100.1062/0.12 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.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 Threads started! [ 10s ] thds: 16 tps: 103.58 qps: 103.58 (r/w/o: 103.58/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 16 tps: 105.91 qps: 105.91 (r/w/o: 105.91/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 30s ] 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 [ 40s ] thds: 16 tps: 105.00 qps: 105.00 (r/w/o: 105.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 16 tps: 106.20 qps: 106.20 (r/w/o: 106.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 16 tps: 105.00 qps: 105.00 (r/w/o: 105.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 16 tps: 105.49 qps: 105.49 (r/w/o: 105.49/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 16 tps: 105.30 qps: 105.30 (r/w/o: 105.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 16 tps: 105.20 qps: 105.20 (r/w/o: 105.20/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: 10545 write: 0 other: 0 total: 10545 transactions: 10545 (104.18 per sec.) queries: 10545 (104.18 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 101.2167s total number of events: 10545 Latency (ms): min: 137.92 avg: 151.95 max: 4207.39 95th percentile: 144.97 sum: 1602364.17 Threads fairness: events (avg/stddev): 659.0625/29.71 execution time (avg/stddev): 100.1478/0.28 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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(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: 206.38 qps: 206.38 (r/w/o: 206.38/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 32 tps: 218.21 qps: 218.21 (r/w/o: 218.21/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 32 tps: 218.50 qps: 218.50 (r/w/o: 218.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 32 tps: 218.80 qps: 218.80 (r/w/o: 218.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 32 tps: 218.80 qps: 218.80 (r/w/o: 218.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 32 tps: 218.99 qps: 218.99 (r/w/o: 218.99/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 32 tps: 218.81 qps: 218.81 (r/w/o: 218.81/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 32 tps: 218.80 qps: 218.80 (r/w/o: 218.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 32 tps: 219.20 qps: 219.20 (r/w/o: 219.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 32 tps: 218.10 qps: 218.10 (r/w/o: 218.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 21778 write: 0 other: 0 total: 21778 transactions: 21778 (215.57 per sec.) queries: 21778 (215.57 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 101.0253s total number of events: 21778 Latency (ms): min: 138.51 avg: 147.07 max: 4655.94 95th percentile: 144.97 sum: 3202993.46 Threads fairness: events (avg/stddev): 680.5625/19.43 execution time (avg/stddev): 100.0935/0.17 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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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 perftest.lua: loaded 3 SQL statement(s) from 3 file(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: 434.75 qps: 434.75 (r/w/o: 434.75/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 64 tps: 441.41 qps: 441.41 (r/w/o: 441.41/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 64 tps: 440.00 qps: 440.00 (r/w/o: 440.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 64 tps: 439.00 qps: 439.00 (r/w/o: 439.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 64 tps: 441.70 qps: 441.70 (r/w/o: 441.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 64 tps: 443.70 qps: 443.70 (r/w/o: 443.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 64 tps: 441.70 qps: 441.70 (r/w/o: 441.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 64 tps: 443.50 qps: 443.50 (r/w/o: 443.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 64 tps: 441.00 qps: 441.00 (r/w/o: 441.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 64 tps: 442.10 qps: 442.10 (r/w/o: 442.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 44153 write: 0 other: 0 total: 44153 transactions: 44153 (428.23 per sec.) queries: 44153 (428.23 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 103.1044s total number of events: 44153 Latency (ms): min: 137.88 avg: 145.16 max: 6062.74 95th percentile: 144.97 sum: 6409133.87 Threads fairness: events (avg/stddev): 689.8906/17.92 execution time (avg/stddev): 100.1427/0.41 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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 Threads started! [ 10s ] thds: 128 tps: 878.19 qps: 878.19 (r/w/o: 878.19/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 128 tps: 892.52 qps: 892.52 (r/w/o: 892.52/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 128 tps: 891.60 qps: 891.60 (r/w/o: 891.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 128 tps: 892.06 qps: 892.06 (r/w/o: 892.06/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 128 tps: 893.05 qps: 893.05 (r/w/o: 893.05/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 128 tps: 890.60 qps: 890.60 (r/w/o: 890.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 128 tps: 892.80 qps: 892.80 (r/w/o: 892.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 128 tps: 892.68 qps: 892.68 (r/w/o: 892.68/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 128 tps: 891.13 qps: 891.13 (r/w/o: 891.13/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 128 tps: 892.78 qps: 892.78 (r/w/o: 892.78/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 89203 write: 0 other: 0 total: 89203 transactions: 89203 (878.52 per sec.) queries: 89203 (878.52 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 101.5366s total number of events: 89203 Latency (ms): min: 137.13 avg: 143.63 max: 8833.45 95th percentile: 144.97 sum: 12811997.94 Threads fairness: events (avg/stddev): 696.8984/18.56 execution time (avg/stddev): 100.0937/0.19 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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 Threads started! [ 10s ] thds: 151 tps: 1038.97 qps: 1038.97 (r/w/o: 1038.97/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 151 tps: 1056.23 qps: 1056.23 (r/w/o: 1056.23/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 151 tps: 1055.60 qps: 1055.60 (r/w/o: 1055.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 151 tps: 1056.70 qps: 1056.70 (r/w/o: 1056.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 151 tps: 1056.20 qps: 1056.20 (r/w/o: 1056.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 151 tps: 1056.00 qps: 1056.00 (r/w/o: 1056.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 151 tps: 1056.30 qps: 1056.30 (r/w/o: 1056.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 151 tps: 1056.40 qps: 1056.40 (r/w/o: 1056.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 151 tps: 1054.86 qps: 1054.86 (r/w/o: 1054.86/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 151 tps: 1057.34 qps: 1057.34 (r/w/o: 1057.34/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 105598 write: 0 other: 0 total: 105598 transactions: 105598 (1033.09 per sec.) queries: 105598 (1033.09 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.2152s total number of events: 105598 Latency (ms): min: 136.98 avg: 143.12 max: 7563.49 95th percentile: 144.97 sum: 15113160.24 Threads fairness: events (avg/stddev): 699.3245/18.04 execution time (avg/stddev): 100.0872/0.18 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.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.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.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.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: 93 tps: 74.64 qps: 74.64 (r/w/o: 74.64/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.33 reconn/s: 0.00