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%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 1 tps: 0.80 qps: 0.80 (r/w/o: 0.80/0.00/0.00) lat (ms,95%): 3773.42 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 1 tps: 1.00 qps: 1.00 (r/w/o: 1.00/0.00/0.00) lat (ms,95%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 1 tps: 0.70 qps: 0.70 (r/w/o: 0.70/0.00/0.00) lat (ms,95%): 3773.42 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%): 3841.98 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 1 tps: 0.80 qps: 0.80 (r/w/o: 0.80/0.00/0.00) lat (ms,95%): 3639.94 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 1 tps: 0.80 qps: 0.80 (r/w/o: 0.80/0.00/0.00) lat (ms,95%): 3706.08 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 1 tps: 1.00 qps: 1.00 (r/w/o: 1.00/0.00/0.00) lat (ms,95%): 3706.08 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%): 3773.42 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 1 tps: 0.80 qps: 0.80 (r/w/o: 0.80/0.00/0.00) lat (ms,95%): 3911.79 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 81 write: 0 other: 0 total: 81 transactions: 81 (0.81 per sec.) queries: 81 (0.81 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 100.4416s total number of events: 81 Latency (ms): min: 138.41 avg: 1240.01 max: 3911.51 95th percentile: 3773.42 sum: 100440.82 Threads fairness: events (avg/stddev): 81.0000/0.00 execution time (avg/stddev): 100.4408/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.90 qps: 6.90 (r/w/o: 6.90/0.00/0.00) lat (ms,95%): 601.29 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: 6.60 qps: 6.60 (r/w/o: 6.60/0.00/0.00) lat (ms,95%): 1191.92 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 2 tps: 6.10 qps: 6.10 (r/w/o: 6.10/0.00/0.00) lat (ms,95%): 1149.76 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 2 tps: 6.40 qps: 6.40 (r/w/o: 6.40/0.00/0.00) lat (ms,95%): 1213.57 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%): 2045.74 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%): 2320.55 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 2 tps: 4.80 qps: 4.80 (r/w/o: 4.80/0.00/0.00) lat (ms,95%): 2362.72 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%): 1235.62 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 2 tps: 6.60 qps: 6.60 (r/w/o: 6.60/0.00/0.00) lat (ms,95%): 1109.09 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 623 write: 0 other: 0 total: 623 transactions: 623 (6.22 per sec.) queries: 623 (6.22 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 100.1532s total number of events: 623 Latency (ms): min: 142.93 avg: 321.42 max: 4077.61 95th percentile: 2279.14 sum: 200244.91 Threads fairness: events (avg/stddev): 311.5000/31.50 execution time (avg/stddev): 100.1225/0.03 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: 18.00 qps: 18.00 (r/w/o: 18.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 4 tps: 16.10 qps: 16.10 (r/w/o: 16.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 4 tps: 17.50 qps: 17.50 (r/w/o: 17.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 4 tps: 17.90 qps: 17.90 (r/w/o: 17.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 4 tps: 18.20 qps: 18.20 (r/w/o: 18.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 4 tps: 17.30 qps: 17.30 (r/w/o: 17.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 4 tps: 20.00 qps: 20.00 (r/w/o: 20.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 4 tps: 19.30 qps: 19.30 (r/w/o: 19.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 4 tps: 20.80 qps: 20.80 (r/w/o: 20.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 4 tps: 19.80 qps: 19.80 (r/w/o: 19.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 1853 write: 0 other: 0 total: 1853 transactions: 1853 (17.93 per sec.) queries: 1853 (17.93 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 103.3382s total number of events: 1853 Latency (ms): min: 142.02 avg: 217.82 max: 4489.27 95th percentile: 144.97 sum: 403612.68 Threads fairness: events (avg/stddev): 463.2500/25.22 execution time (avg/stddev): 100.9032/1.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: 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: 41.49 qps: 41.49 (r/w/o: 41.49/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 8 tps: 44.80 qps: 44.80 (r/w/o: 44.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 8 tps: 45.40 qps: 45.40 (r/w/o: 45.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 8 tps: 43.70 qps: 43.70 (r/w/o: 43.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 8 tps: 45.70 qps: 45.70 (r/w/o: 45.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 8 tps: 43.80 qps: 43.80 (r/w/o: 43.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 8 tps: 44.00 qps: 44.00 (r/w/o: 44.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 8 tps: 47.40 qps: 47.40 (r/w/o: 47.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 8 tps: 45.90 qps: 45.90 (r/w/o: 45.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 8 tps: 44.60 qps: 44.60 (r/w/o: 44.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 4476 write: 0 other: 0 total: 4476 transactions: 4476 (43.47 per sec.) queries: 4476 (43.47 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.9562s total number of events: 4476 Latency (ms): min: 137.93 avg: 179.49 max: 7138.69 95th percentile: 144.97 sum: 803384.54 Threads fairness: events (avg/stddev): 559.5000/34.82 execution time (avg/stddev): 100.4231/0.96 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.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.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 Threads started! [ 10s ] thds: 16 tps: 85.39 qps: 85.39 (r/w/o: 85.39/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 16 tps: 99.70 qps: 99.70 (r/w/o: 99.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 16 tps: 97.90 qps: 97.90 (r/w/o: 97.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 16 tps: 98.50 qps: 98.50 (r/w/o: 98.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 16 tps: 98.90 qps: 98.90 (r/w/o: 98.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 16 tps: 98.70 qps: 98.70 (r/w/o: 98.70/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 16 tps: 98.80 qps: 98.80 (r/w/o: 98.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 16 tps: 98.90 qps: 98.90 (r/w/o: 98.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 16 tps: 97.60 qps: 97.60 (r/w/o: 97.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 16 tps: 99.30 qps: 99.30 (r/w/o: 99.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 9753 write: 0 other: 0 total: 9753 transactions: 9753 (93.83 per sec.) queries: 9753 (93.83 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 103.9373s total number of events: 9753 Latency (ms): min: 138.85 avg: 164.74 max: 7986.04 95th percentile: 144.97 sum: 1606688.60 Threads fairness: events (avg/stddev): 609.5625/34.78 execution time (avg/stddev): 100.4180/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: 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql Threads started! [ 10s ] thds: 32 tps: 196.77 qps: 196.77 (r/w/o: 196.77/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 32 tps: 207.51 qps: 207.51 (r/w/o: 207.51/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 32 tps: 206.10 qps: 206.10 (r/w/o: 206.10/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 32 tps: 209.60 qps: 209.60 (r/w/o: 209.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 32 tps: 207.40 qps: 207.40 (r/w/o: 207.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 32 tps: 206.79 qps: 206.79 (r/w/o: 206.79/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 32 tps: 210.00 qps: 210.00 (r/w/o: 210.00/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 32 tps: 207.40 qps: 207.40 (r/w/o: 207.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 32 tps: 208.90 qps: 208.90 (r/w/o: 208.90/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 32 tps: 207.80 qps: 207.80 (r/w/o: 207.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 20715 write: 0 other: 0 total: 20715 transactions: 20715 (201.28 per sec.) queries: 20715 (201.28 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.9175s total number of events: 20715 Latency (ms): min: 137.45 avg: 154.84 max: 8808.70 95th percentile: 144.97 sum: 3207411.73 Threads fairness: events (avg/stddev): 647.3438/30.63 execution time (avg/stddev): 100.2316/0.63 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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 Threads started! [ 10s ] thds: 64 tps: 413.45 qps: 413.45 (r/w/o: 413.45/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 64 tps: 431.11 qps: 431.11 (r/w/o: 431.11/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 64 tps: 430.60 qps: 430.60 (r/w/o: 430.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 64 tps: 430.30 qps: 430.30 (r/w/o: 430.30/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 64 tps: 428.60 qps: 428.60 (r/w/o: 428.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 64 tps: 431.50 qps: 431.50 (r/w/o: 431.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 64 tps: 432.20 qps: 432.20 (r/w/o: 432.20/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 64 tps: 429.50 qps: 429.50 (r/w/o: 429.50/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 64 tps: 430.80 qps: 430.80 (r/w/o: 430.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 64 tps: 431.60 qps: 431.60 (r/w/o: 431.60/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 42961 write: 0 other: 0 total: 42961 transactions: 42961 (419.26 per sec.) queries: 42961 (419.26 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 102.4670s total number of events: 42961 Latency (ms): min: 137.55 avg: 149.20 max: 8527.32 95th percentile: 144.97 sum: 6409828.81 Threads fairness: events (avg/stddev): 671.2656/31.52 execution time (avg/stddev): 100.1536/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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(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: 811.20 qps: 811.20 (r/w/o: 811.20/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 128 tps: 875.62 qps: 875.62 (r/w/o: 875.62/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 128 tps: 875.50 qps: 875.50 (r/w/o: 875.50/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 128 tps: 877.50 qps: 877.50 (r/w/o: 877.50/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 128 tps: 880.10 qps: 880.10 (r/w/o: 880.10/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 128 tps: 875.00 qps: 875.00 (r/w/o: 875.00/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 128 tps: 878.30 qps: 878.30 (r/w/o: 878.30/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 128 tps: 877.40 qps: 877.40 (r/w/o: 877.40/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 128 tps: 881.19 qps: 881.19 (r/w/o: 881.19/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 128 tps: 876.70 qps: 876.70 (r/w/o: 876.70/0.00/0.00) lat (ms,95%): 142.39 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 87214 write: 0 other: 0 total: 87214 transactions: 87214 (829.91 per sec.) queries: 87214 (829.91 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 105.0880s total number of events: 87214 Latency (ms): min: 136.74 avg: 147.03 max: 18218.10 95th percentile: 142.39 sum: 12822703.15 Threads fairness: events (avg/stddev): 681.3594/33.76 execution time (avg/stddev): 100.1774/0.67 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.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.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.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.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 perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.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 Threads started! [ 10s ] thds: 151 tps: 911.09 qps: 911.09 (r/w/o: 911.09/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 151 tps: 1021.53 qps: 1021.53 (r/w/o: 1021.53/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 151 tps: 1036.80 qps: 1036.80 (r/w/o: 1036.80/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 40s ] thds: 151 tps: 1037.29 qps: 1037.29 (r/w/o: 1037.29/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 50s ] thds: 151 tps: 1033.51 qps: 1033.51 (r/w/o: 1033.51/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 60s ] thds: 151 tps: 1033.75 qps: 1033.75 (r/w/o: 1033.75/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 70s ] thds: 151 tps: 1037.25 qps: 1037.25 (r/w/o: 1037.25/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 80s ] thds: 151 tps: 1037.67 qps: 1037.67 (r/w/o: 1037.67/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 90s ] thds: 151 tps: 1032.92 qps: 1032.92 (r/w/o: 1032.92/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 [ 100s ] thds: 151 tps: 1035.40 qps: 1035.40 (r/w/o: 1035.40/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 102324 write: 0 other: 0 total: 102324 transactions: 102324 (934.78 per sec.) queries: 102324 (934.78 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 109.4619s total number of events: 102324 Latency (ms): min: 136.73 avg: 147.87 max: 16901.10 95th percentile: 144.97 sum: 15130665.07 Threads fairness: events (avg/stddev): 677.6424/38.36 execution time (avg/stddev): 100.2031/0.92 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.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.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.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 file(s): q6.sql,q11.sql,q16.sql perftest.lua: loaded 3 SQL statement(s) from 3 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.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.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.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.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! 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: 151 tps: 356.86 qps: 356.86 (r/w/o: 356.86/0.00/0.00) lat (ms,95%): 144.97 err/s: 0.33 reconn/s: 0.00 [ 6s ] thds: 151 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: 151 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 [ 12s ] thds: 144 tps: 5.33 qps: 5.33 (r/w/o: 5.33/0.00/0.00) lat (ms,95%): 9799.46 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 144 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