sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 4 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 4, tps: 6989.38, reads: 69898.79, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 4, tps: 7372.08, reads: 73723.43, writes: 0.00, response time: 0.64ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 4, tps: 7412.90, reads: 74128.99, writes: 0.00, response time: 0.67ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 4, tps: 6807.33, reads: 68071.26, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 4, tps: 6861.09, reads: 68612.21, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 4, tps: 6711.60, reads: 67115.97, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 4, tps: 7148.68, reads: 71483.76, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 4, tps: 7182.07, reads: 71826.05, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 4, tps: 7208.93, reads: 72086.61, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 4, tps: 7250.07, reads: 72499.07, writes: 0.00, response time: 0.67ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 4, tps: 7616.01, reads: 76162.10, writes: 0.00, response time: 0.64ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 4, tps: 7657.25, reads: 76570.18, writes: 0.00, response time: 0.63ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 4, tps: 7567.68, reads: 75677.83, writes: 0.00, response time: 0.65ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 4, tps: 7440.31, reads: 74402.40, writes: 0.00, response time: 0.69ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 4, tps: 7717.09, reads: 77173.88, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 4, tps: 7721.33, reads: 77211.32, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 4, tps: 7584.26, reads: 75840.61, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 4, tps: 7771.67, reads: 77717.73, writes: 0.00, response time: 0.60ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 4, tps: 7493.99, reads: 74944.88, writes: 0.00, response time: 0.64ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 4, tps: 7431.33, reads: 74305.97, writes: 0.00, response time: 0.69ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 4, tps: 7080.75, reads: 70816.12, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 4, tps: 7246.32, reads: 72458.87, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 4, tps: 7586.02, reads: 75858.56, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 4, tps: 6799.00, reads: 67986.32, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 4, tps: 7133.01, reads: 71335.06, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 4, tps: 7385.25, reads: 73849.85, writes: 0.00, response time: 0.69ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 4, tps: 7627.66, reads: 76279.62, writes: 0.00, response time: 0.67ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 4, tps: 7467.07, reads: 74669.74, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 4, tps: 7430.69, reads: 74305.91, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 4, tps: 7636.90, reads: 76371.62, writes: 0.00, response time: 0.63ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 4, tps: 8024.00, reads: 80240.67, writes: 0.00, response time: 0.55ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 4, tps: 7969.00, reads: 79688.34, writes: 0.00, response time: 0.56ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 4, tps: 8070.35, reads: 80701.82, writes: 0.00, response time: 0.53ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 4, tps: 7232.99, reads: 72330.88, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 4, tps: 7543.73, reads: 75433.26, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 4, tps: 7325.27, reads: 73256.00, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 4, tps: 7417.01, reads: 74167.46, writes: 0.00, response time: 0.65ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 4, tps: 7502.07, reads: 75025.74, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 4, tps: 7230.67, reads: 72305.39, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 4, tps: 7354.99, reads: 73552.24, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 8880240 write: 0 other: 1776048 total: 10656288 transactions: 888024 (7400.17 per sec.) read/write requests: 8880240 (74001.69 per sec.) other operations: 1776048 (14800.34 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0005s total number of events: 888024 total time taken by event execution: 479.2925s response time: min: 0.40ms avg: 0.54ms max: 3.90ms approx. 95 percentile: 0.69ms Threads fairness: events (avg/stddev): 222006.0000/4986.61 execution time (avg/stddev): 119.8231/0.01 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 8, tps: 13199.71, reads: 132012.12, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 8, tps: 14084.35, reads: 140845.12, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 8, tps: 13936.98, reads: 139365.14, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 8, tps: 13642.00, reads: 136415.05, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 8, tps: 13695.02, reads: 136958.18, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 8, tps: 13690.98, reads: 136904.83, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 8, tps: 13685.02, reads: 136849.23, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 8, tps: 13147.00, reads: 131472.00, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 8, tps: 12895.98, reads: 128959.85, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 8, tps: 13208.35, reads: 132082.18, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 8, tps: 13746.33, reads: 137464.63, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 8, tps: 12960.67, reads: 129608.69, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 8, tps: 13336.99, reads: 133370.92, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 8, tps: 13736.68, reads: 137362.49, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 8, tps: 12988.99, reads: 129892.28, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 8, tps: 13332.67, reads: 133321.72, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 8, tps: 13563.33, reads: 135635.66, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 8, tps: 14073.33, reads: 140735.67, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 8, tps: 13730.67, reads: 137308.68, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 8, tps: 13294.99, reads: 132947.57, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 8, tps: 13109.30, reads: 131095.00, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 8, tps: 13269.70, reads: 132690.70, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 8, tps: 12983.66, reads: 129847.24, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 8, tps: 13129.67, reads: 131290.75, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 8, tps: 13056.66, reads: 130566.27, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 8, tps: 13403.34, reads: 134036.03, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 8, tps: 13558.67, reads: 135585.39, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 8, tps: 13732.99, reads: 137335.58, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 8, tps: 13922.66, reads: 139215.62, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 8, tps: 13957.00, reads: 139571.37, writes: 0.00, response time: 0.69ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 8, tps: 13531.01, reads: 135320.77, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 8, tps: 13562.99, reads: 135625.94, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 8, tps: 13239.66, reads: 132392.94, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 8, tps: 13403.34, reads: 134030.42, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 8, tps: 13004.31, reads: 130039.79, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 8, tps: 13289.36, reads: 132896.89, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 8, tps: 13784.00, reads: 137839.63, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 8, tps: 13691.34, reads: 136915.75, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 8, tps: 13424.99, reads: 134254.23, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 8, tps: 13401.67, reads: 134013.06, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 16152230 write: 0 other: 3230446 total: 19382676 transactions: 1615223 (13460.10 per sec.) read/write requests: 16152230 (134601.04 per sec.) other operations: 3230446 (26920.21 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0008s total number of events: 1615223 total time taken by event execution: 958.6448s response time: min: 0.46ms avg: 0.59ms max: 3.77ms approx. 95 percentile: 0.77ms Threads fairness: events (avg/stddev): 201902.8750/6533.86 execution time (avg/stddev): 119.8306/0.01 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 16 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 16, tps: 22584.94, reads: 225878.44, writes: 0.00, response time: 0.82ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 16, tps: 23204.64, reads: 232037.73, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 16, tps: 23127.04, reads: 231267.76, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 16, tps: 23381.96, reads: 233823.65, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 16, tps: 23518.37, reads: 235185.00, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 16, tps: 23220.30, reads: 232200.00, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 16, tps: 23227.03, reads: 232270.68, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 16, tps: 23172.99, reads: 231729.91, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 16, tps: 23200.68, reads: 232015.15, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 16, tps: 23093.28, reads: 230934.79, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 16, tps: 23029.06, reads: 230284.24, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 16, tps: 23090.33, reads: 230904.31, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 16, tps: 22896.68, reads: 228964.79, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 16, tps: 23072.66, reads: 230727.22, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 16, tps: 22989.30, reads: 229896.35, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 16, tps: 23062.38, reads: 230624.79, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 16, tps: 23026.98, reads: 230263.85, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 16, tps: 23009.01, reads: 230091.73, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 16, tps: 23068.01, reads: 230670.40, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 16, tps: 23175.67, reads: 231766.06, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 16, tps: 22690.66, reads: 226907.31, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 16, tps: 22558.66, reads: 225592.23, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 16, tps: 22578.64, reads: 225776.71, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 16, tps: 22833.38, reads: 228339.83, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 16, tps: 23018.98, reads: 230184.46, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 16, tps: 23250.69, reads: 232514.24, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 16, tps: 23305.66, reads: 233054.64, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 16, tps: 23055.65, reads: 230548.84, writes: 0.00, response time: 0.81ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 16, tps: 23257.00, reads: 232574.70, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 16, tps: 23288.00, reads: 232876.98, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 16, tps: 23365.31, reads: 233664.44, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 16, tps: 23204.00, reads: 232032.35, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 16, tps: 23018.67, reads: 230190.68, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 16, tps: 23349.99, reads: 233501.57, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 16, tps: 23255.69, reads: 232556.55, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 16, tps: 23417.65, reads: 234167.53, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 16, tps: 23375.63, reads: 233760.32, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 16, tps: 23447.38, reads: 234468.45, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 16, tps: 23160.00, reads: 231603.34, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 16, tps: 23124.01, reads: 231238.73, writes: 0.00, response time: 0.80ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 27741310 write: 0 other: 5548262 total: 33289572 transactions: 2774131 (23117.64 per sec.) read/write requests: 27741310 (231176.36 per sec.) other operations: 5548262 (46235.27 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0006s total number of events: 2774131 total time taken by event execution: 1917.8394s response time: min: 0.48ms avg: 0.69ms max: 13.83ms approx. 95 percentile: 0.80ms Threads fairness: events (avg/stddev): 173383.1875/3545.65 execution time (avg/stddev): 119.8650/0.00 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 32 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 32, tps: 30590.87, reads: 305954.03, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 32, tps: 30897.80, reads: 308990.38, writes: 0.00, response time: 1.23ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 32, tps: 31071.22, reads: 310702.18, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 32, tps: 31182.08, reads: 311827.76, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 32, tps: 31238.38, reads: 312378.18, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 32, tps: 31278.74, reads: 312791.06, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 32, tps: 31340.27, reads: 313395.38, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 32, tps: 31306.04, reads: 313052.78, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 32, tps: 31382.68, reads: 313837.79, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 32, tps: 31461.17, reads: 314607.70, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 32, tps: 31503.15, reads: 315033.49, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 32, tps: 31405.60, reads: 314049.64, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 32, tps: 31287.34, reads: 312889.43, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 32, tps: 31147.30, reads: 311462.36, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 32, tps: 31109.40, reads: 311080.03, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 32, tps: 31194.58, reads: 311972.16, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 32, tps: 31239.48, reads: 312374.48, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 32, tps: 31213.63, reads: 312153.93, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 32, tps: 31420.34, reads: 314197.76, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 32, tps: 31451.56, reads: 314511.58, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 32, tps: 31343.39, reads: 313433.57, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 32, tps: 31480.39, reads: 314802.87, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 32, tps: 31358.96, reads: 313584.26, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 32, tps: 31430.04, reads: 314306.42, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 32, tps: 31408.64, reads: 314101.36, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 32, tps: 31549.02, reads: 315487.85, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 32, tps: 31489.59, reads: 314892.21, writes: 0.00, response time: 1.21ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 32, tps: 31532.42, reads: 315321.84, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 32, tps: 31604.98, reads: 316048.49, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 32, tps: 31519.38, reads: 315198.44, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 32, tps: 31551.95, reads: 315511.19, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 32, tps: 31699.69, reads: 316991.87, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 32, tps: 31647.32, reads: 316475.57, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 32, tps: 31646.65, reads: 316466.13, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 32, tps: 31679.37, reads: 316800.03, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 32, tps: 31503.65, reads: 315032.52, writes: 0.00, response time: 1.19ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 32, tps: 31498.99, reads: 314995.25, writes: 0.00, response time: 1.20ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 32, tps: 31525.94, reads: 315249.09, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 32, tps: 31605.75, reads: 316066.78, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 32, tps: 31621.63, reads: 316203.33, writes: 0.00, response time: 1.18ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 37662900 write: 0 other: 7532580 total: 45195480 transactions: 3766290 (31385.45 per sec.) read/write requests: 37662900 (313854.52 per sec.) other operations: 7532580 (62770.90 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0011s total number of events: 3766290 total time taken by event execution: 3835.4740s response time: min: 0.61ms avg: 1.02ms max: 18.80ms approx. 95 percentile: 1.20ms Threads fairness: events (avg/stddev): 117696.5625/9524.05 execution time (avg/stddev): 119.8586/0.01 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 64 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 64, tps: 36950.04, reads: 369588.76, writes: 0.00, response time: 2.40ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 64, tps: 37528.80, reads: 375293.64, writes: 0.00, response time: 2.30ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 64, tps: 37764.90, reads: 377639.96, writes: 0.00, response time: 2.30ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 64, tps: 37254.78, reads: 372567.11, writes: 0.00, response time: 2.36ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 64, tps: 37734.00, reads: 377333.68, writes: 0.00, response time: 2.29ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 64, tps: 37478.90, reads: 374780.66, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 64, tps: 37712.44, reads: 377134.41, writes: 0.00, response time: 2.30ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 64, tps: 37475.65, reads: 374760.83, writes: 0.00, response time: 2.23ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 64, tps: 37542.29, reads: 375421.89, writes: 0.00, response time: 2.30ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 64, tps: 37652.02, reads: 376510.49, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 64, tps: 37928.33, reads: 379291.94, writes: 0.00, response time: 2.27ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 64, tps: 37997.03, reads: 379958.66, writes: 0.00, response time: 2.22ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 64, tps: 37561.63, reads: 375600.34, writes: 0.00, response time: 2.28ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 64, tps: 37047.35, reads: 370487.54, writes: 0.00, response time: 2.39ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 64, tps: 37721.62, reads: 377226.85, writes: 0.00, response time: 2.27ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 64, tps: 37434.01, reads: 374336.44, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 64, tps: 37511.72, reads: 375114.20, writes: 0.00, response time: 2.35ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 64, tps: 37332.93, reads: 373326.01, writes: 0.00, response time: 2.38ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 64, tps: 37523.04, reads: 375230.11, writes: 0.00, response time: 2.33ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 64, tps: 37757.92, reads: 377592.49, writes: 0.00, response time: 2.29ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 64, tps: 37607.75, reads: 376076.79, writes: 0.00, response time: 2.29ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 64, tps: 37403.68, reads: 374012.80, writes: 0.00, response time: 2.28ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 64, tps: 37249.60, reads: 372505.32, writes: 0.00, response time: 2.33ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 64, tps: 37355.05, reads: 373558.79, writes: 0.00, response time: 2.36ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 64, tps: 37341.97, reads: 373434.99, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 64, tps: 37556.07, reads: 375550.41, writes: 0.00, response time: 2.31ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 64, tps: 37519.02, reads: 375179.57, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 64, tps: 37508.61, reads: 375092.77, writes: 0.00, response time: 2.28ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 64, tps: 37347.34, reads: 373474.09, writes: 0.00, response time: 2.37ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 64, tps: 37575.99, reads: 375769.61, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 64, tps: 37580.66, reads: 375801.65, writes: 0.00, response time: 2.34ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 64, tps: 37456.03, reads: 374565.95, writes: 0.00, response time: 2.33ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 64, tps: 37515.25, reads: 375131.80, writes: 0.00, response time: 2.36ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 64, tps: 37701.42, reads: 377024.49, writes: 0.00, response time: 2.28ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 64, tps: 37239.37, reads: 372393.68, writes: 0.00, response time: 2.37ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 64, tps: 36935.95, reads: 369356.45, writes: 0.00, response time: 2.40ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 64, tps: 37214.98, reads: 372151.13, writes: 0.00, response time: 2.29ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 64, tps: 37571.00, reads: 375716.37, writes: 0.00, response time: 2.25ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 64, tps: 37111.71, reads: 371111.40, writes: 0.00, response time: 2.36ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 64, tps: 37301.94, reads: 373025.75, writes: 0.00, response time: 2.38ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 44970720 write: 0 other: 8994144 total: 53964864 transactions: 4497072 (37475.18 per sec.) read/write requests: 44970720 (374751.80 per sec.) other operations: 8994144 (74950.36 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0013s total number of events: 4497072 total time taken by event execution: 7673.4430s response time: min: 0.63ms avg: 1.71ms max: 37.67ms approx. 95 percentile: 2.32ms Threads fairness: events (avg/stddev): 70266.7500/2182.12 execution time (avg/stddev): 119.8975/0.01 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 128 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 128, tps: 38186.73, reads: 382063.34, writes: 0.00, response time: 4.66ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 128, tps: 41098.72, reads: 410975.55, writes: 0.00, response time: 3.59ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 128, tps: 40716.97, reads: 407169.40, writes: 0.00, response time: 3.63ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 128, tps: 41128.02, reads: 411289.52, writes: 0.00, response time: 3.60ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 128, tps: 41146.31, reads: 411462.42, writes: 0.00, response time: 3.59ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 128, tps: 41218.26, reads: 412173.62, writes: 0.00, response time: 3.61ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 128, tps: 41097.66, reads: 410995.92, writes: 0.00, response time: 3.64ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 128, tps: 40757.29, reads: 407578.24, writes: 0.00, response time: 4.08ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 128, tps: 41156.39, reads: 411572.53, writes: 0.00, response time: 3.76ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 128, tps: 40665.75, reads: 406643.12, writes: 0.00, response time: 3.66ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 128, tps: 40016.54, reads: 400177.75, writes: 0.00, response time: 4.02ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 128, tps: 40532.79, reads: 405301.53, writes: 0.00, response time: 4.11ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 128, tps: 40815.69, reads: 408159.58, writes: 0.00, response time: 4.10ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 128, tps: 40310.61, reads: 403102.44, writes: 0.00, response time: 4.13ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 128, tps: 41064.69, reads: 410663.56, writes: 0.00, response time: 4.01ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 128, tps: 40393.02, reads: 403913.57, writes: 0.00, response time: 4.05ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 128, tps: 39960.27, reads: 399618.01, writes: 0.00, response time: 4.02ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 128, tps: 39943.74, reads: 399429.75, writes: 0.00, response time: 4.10ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 128, tps: 40022.93, reads: 400240.29, writes: 0.00, response time: 4.01ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 128, tps: 39951.06, reads: 399495.92, writes: 0.00, response time: 4.07ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 128, tps: 40008.55, reads: 400077.19, writes: 0.00, response time: 4.01ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 128, tps: 40215.81, reads: 402160.14, writes: 0.00, response time: 4.05ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 128, tps: 40064.94, reads: 400661.11, writes: 0.00, response time: 4.02ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 128, tps: 39663.00, reads: 396635.01, writes: 0.00, response time: 4.21ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 128, tps: 39755.22, reads: 397531.54, writes: 0.00, response time: 4.17ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 128, tps: 39762.50, reads: 397635.28, writes: 0.00, response time: 4.16ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 128, tps: 39817.98, reads: 398200.13, writes: 0.00, response time: 4.11ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 128, tps: 39675.91, reads: 396761.75, writes: 0.00, response time: 4.20ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 128, tps: 40962.72, reads: 409620.24, writes: 0.00, response time: 3.69ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 128, tps: 41126.66, reads: 411263.58, writes: 0.00, response time: 3.69ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 128, tps: 40484.38, reads: 404835.45, writes: 0.00, response time: 3.90ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 128, tps: 40135.69, reads: 401360.19, writes: 0.00, response time: 3.93ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 128, tps: 40775.64, reads: 407745.38, writes: 0.00, response time: 3.61ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 128, tps: 40315.36, reads: 403165.56, writes: 0.00, response time: 3.78ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 128, tps: 38199.53, reads: 381990.97, writes: 0.00, response time: 5.22ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 128, tps: 38448.48, reads: 384479.47, writes: 0.00, response time: 5.00ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 128, tps: 38201.32, reads: 382020.48, writes: 0.00, response time: 5.28ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 128, tps: 39325.35, reads: 393236.49, writes: 0.00, response time: 4.41ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 128, tps: 39761.99, reads: 397621.25, writes: 0.00, response time: 4.16ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 128, tps: 39848.27, reads: 398498.66, writes: 0.00, response time: 4.16ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 48203260 write: 0 other: 9640652 total: 57843912 transactions: 4820326 (40168.58 per sec.) read/write requests: 48203260 (401685.80 per sec.) other operations: 9640652 (80337.16 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0024s total number of events: 4820326 total time taken by event execution: 15346.0271s response time: min: 0.67ms avg: 3.18ms max: 94.84ms approx. 95 percentile: 4.03ms Threads fairness: events (avg/stddev): 37658.7969/2795.25 execution time (avg/stddev): 119.8908/0.03 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 256 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 256, tps: 40601.22, reads: 406376.15, writes: 0.00, response time: 7.69ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 256, tps: 41680.14, reads: 416820.77, writes: 0.00, response time: 7.50ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 256, tps: 40440.65, reads: 404430.13, writes: 0.00, response time: 7.70ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 256, tps: 40394.02, reads: 403893.89, writes: 0.00, response time: 8.13ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 256, tps: 41610.93, reads: 416148.66, writes: 0.00, response time: 7.52ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 256, tps: 41539.72, reads: 415425.89, writes: 0.00, response time: 7.59ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 256, tps: 41469.35, reads: 414645.46, writes: 0.00, response time: 7.60ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 256, tps: 41370.62, reads: 413702.22, writes: 0.00, response time: 7.63ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 256, tps: 41652.31, reads: 416548.72, writes: 0.00, response time: 7.50ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 256, tps: 41627.70, reads: 416277.37, writes: 0.00, response time: 7.38ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 256, tps: 41476.52, reads: 414742.91, writes: 0.00, response time: 7.63ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 256, tps: 41494.74, reads: 414958.72, writes: 0.00, response time: 7.59ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 256, tps: 41320.34, reads: 413190.73, writes: 0.00, response time: 7.58ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 256, tps: 41680.68, reads: 416816.47, writes: 0.00, response time: 6.90ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 256, tps: 41314.97, reads: 413155.32, writes: 0.00, response time: 6.93ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 256, tps: 40194.67, reads: 401932.32, writes: 0.00, response time: 8.05ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 256, tps: 40149.44, reads: 401495.36, writes: 0.00, response time: 8.26ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 256, tps: 40181.98, reads: 401835.76, writes: 0.00, response time: 8.29ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 256, tps: 40195.96, reads: 401929.61, writes: 0.00, response time: 8.32ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 256, tps: 39917.66, reads: 399223.98, writes: 0.00, response time: 8.95ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 256, tps: 38596.65, reads: 385946.49, writes: 0.00, response time: 11.88ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 256, tps: 38401.74, reads: 384027.44, writes: 0.00, response time: 12.84ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 256, tps: 40979.66, reads: 409788.90, writes: 0.00, response time: 7.62ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 256, tps: 41532.34, reads: 415324.10, writes: 0.00, response time: 7.58ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 256, tps: 40092.27, reads: 400950.34, writes: 0.00, response time: 8.59ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 256, tps: 40177.41, reads: 401721.05, writes: 0.00, response time: 8.53ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 256, tps: 40227.32, reads: 402313.90, writes: 0.00, response time: 8.34ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 256, tps: 40091.65, reads: 400900.18, writes: 0.00, response time: 8.63ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 256, tps: 41147.65, reads: 411466.18, writes: 0.00, response time: 7.59ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 256, tps: 40070.32, reads: 400720.20, writes: 0.00, response time: 8.70ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 256, tps: 41197.06, reads: 411946.29, writes: 0.00, response time: 7.31ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 256, tps: 41537.96, reads: 415380.28, writes: 0.00, response time: 6.91ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 256, tps: 40694.65, reads: 406953.87, writes: 0.00, response time: 7.17ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 256, tps: 39388.04, reads: 393867.07, writes: 0.00, response time: 10.26ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 256, tps: 38819.59, reads: 388249.88, writes: 0.00, response time: 12.32ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 256, tps: 39164.40, reads: 391610.63, writes: 0.00, response time: 11.27ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 256, tps: 38970.70, reads: 389720.28, writes: 0.00, response time: 11.95ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 256, tps: 38891.62, reads: 388912.83, writes: 0.00, response time: 12.09ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 256, tps: 40083.33, reads: 400809.67, writes: 0.00, response time: 8.37ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 256, tps: 40156.04, reads: 401580.75, writes: 0.00, response time: 8.20ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 48618590 write: 0 other: 9723718 total: 58342308 transactions: 4861859 (40513.57 per sec.) read/write requests: 48618590 (405135.73 per sec.) other operations: 9723718 (81027.15 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0057s total number of events: 4861859 total time taken by event execution: 30703.0194s response time: min: 0.63ms avg: 6.32ms max: 208.04ms approx. 95 percentile: 7.77ms Threads fairness: events (avg/stddev): 18991.6367/814.17 execution time (avg/stddev): 119.9337/0.02 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 512 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 512, tps: 37768.38, reads: 378485.73, writes: 0.00, response time: 40.56ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 512, tps: 39707.79, reads: 397083.88, writes: 0.00, response time: 18.12ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 512, tps: 40084.04, reads: 400833.42, writes: 0.00, response time: 15.83ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 512, tps: 39743.98, reads: 397419.44, writes: 0.00, response time: 18.12ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 512, tps: 40350.72, reads: 403510.50, writes: 0.00, response time: 15.76ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 512, tps: 41293.32, reads: 412945.51, writes: 0.00, response time: 14.85ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 512, tps: 41446.96, reads: 414439.61, writes: 0.00, response time: 14.87ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 512, tps: 40178.41, reads: 401850.39, writes: 0.00, response time: 15.85ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 512, tps: 38905.57, reads: 389039.01, writes: 0.00, response time: 22.34ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 512, tps: 38597.07, reads: 385994.32, writes: 0.00, response time: 23.53ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 512, tps: 39883.67, reads: 398826.65, writes: 0.00, response time: 16.84ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 512, tps: 39842.28, reads: 398349.09, writes: 0.00, response time: 17.48ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 512, tps: 39757.43, reads: 397608.29, writes: 0.00, response time: 18.31ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 512, tps: 39820.99, reads: 398222.56, writes: 0.00, response time: 17.51ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 512, tps: 39846.30, reads: 398400.35, writes: 0.00, response time: 17.17ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 512, tps: 39871.69, reads: 398746.87, writes: 0.00, response time: 17.06ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 512, tps: 39744.29, reads: 397453.55, writes: 0.00, response time: 17.91ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 512, tps: 39841.04, reads: 398369.37, writes: 0.00, response time: 17.38ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 512, tps: 39816.02, reads: 398166.58, writes: 0.00, response time: 18.72ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 512, tps: 39793.99, reads: 397977.54, writes: 0.00, response time: 17.60ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 512, tps: 38866.33, reads: 388657.61, writes: 0.00, response time: 22.77ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 512, tps: 38266.26, reads: 382626.32, writes: 0.00, response time: 23.86ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 512, tps: 38260.05, reads: 382633.51, writes: 0.00, response time: 23.87ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 512, tps: 39726.38, reads: 397277.48, writes: 0.00, response time: 18.41ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 512, tps: 39654.87, reads: 396507.35, writes: 0.00, response time: 18.39ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 512, tps: 39711.41, reads: 397129.74, writes: 0.00, response time: 18.91ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 512, tps: 39761.73, reads: 397608.27, writes: 0.00, response time: 17.94ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 512, tps: 39025.66, reads: 390308.96, writes: 0.00, response time: 20.97ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 512, tps: 40689.27, reads: 406970.06, writes: 0.00, response time: 15.04ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 512, tps: 40413.04, reads: 404011.38, writes: 0.00, response time: 15.51ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 512, tps: 41321.61, reads: 413254.80, writes: 0.00, response time: 14.91ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 512, tps: 41454.38, reads: 414506.48, writes: 0.00, response time: 14.81ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 512, tps: 41422.03, reads: 414212.61, writes: 0.00, response time: 14.87ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 512, tps: 41453.33, reads: 414574.33, writes: 0.00, response time: 14.83ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 512, tps: 41418.95, reads: 414221.20, writes: 0.00, response time: 14.90ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 512, tps: 41484.01, reads: 414793.43, writes: 0.00, response time: 14.74ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 512, tps: 41212.90, reads: 412150.37, writes: 0.00, response time: 14.91ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 512, tps: 39987.07, reads: 399861.04, writes: 0.00, response time: 17.02ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 512, tps: 39882.24, reads: 398816.35, writes: 0.00, response time: 17.71ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 512, tps: 40037.79, reads: 400380.54, writes: 0.00, response time: 17.13ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 48015430 write: 0 other: 9603086 total: 57618516 transactions: 4801543 (40008.74 per sec.) read/write requests: 48015430 (400087.44 per sec.) other operations: 9603086 (80017.49 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0123s total number of events: 4801543 total time taken by event execution: 61239.5444s response time: min: 0.55ms avg: 12.75ms max: 485.26ms approx. 95 percentile: 16.85ms Threads fairness: events (avg/stddev): 9378.0137/266.67 execution time (avg/stddev): 119.6085/0.14 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1024 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 1024, tps: 34653.02, reads: 347864.51, writes: 0.00, response time: 137.55ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 1024, tps: 37485.12, reads: 374264.51, writes: 0.00, response time: 148.29ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 1024, tps: 37288.72, reads: 373692.88, writes: 0.00, response time: 44.66ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 1024, tps: 35214.67, reads: 352158.38, writes: 0.00, response time: 34.79ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 1024, tps: 36287.31, reads: 362903.79, writes: 0.00, response time: 41.45ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 1024, tps: 36446.92, reads: 364430.22, writes: 0.00, response time: 47.97ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 1024, tps: 36088.25, reads: 360920.79, writes: 0.00, response time: 51.28ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 1024, tps: 36055.18, reads: 360491.10, writes: 0.00, response time: 53.34ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 1024, tps: 36780.63, reads: 367880.66, writes: 0.00, response time: 43.76ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 1024, tps: 36955.33, reads: 369504.26, writes: 0.00, response time: 42.75ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 1024, tps: 37103.99, reads: 371034.60, writes: 0.00, response time: 42.08ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 1024, tps: 36166.00, reads: 361666.99, writes: 0.00, response time: 49.61ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 1024, tps: 36160.03, reads: 361549.35, writes: 0.00, response time: 46.68ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 1024, tps: 35580.65, reads: 355877.88, writes: 0.00, response time: 50.92ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 1024, tps: 35334.68, reads: 353348.15, writes: 0.00, response time: 54.37ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 1024, tps: 36292.03, reads: 362939.31, writes: 0.00, response time: 50.24ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 1024, tps: 36236.60, reads: 362289.00, writes: 0.00, response time: 48.89ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 1024, tps: 36375.35, reads: 363829.81, writes: 0.00, response time: 50.64ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 1024, tps: 36184.96, reads: 361825.98, writes: 0.00, response time: 52.00ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 1024, tps: 36352.04, reads: 363521.37, writes: 0.00, response time: 51.89ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 1024, tps: 35762.34, reads: 357483.39, writes: 0.00, response time: 52.39ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 1024, tps: 36447.70, reads: 364621.64, writes: 0.00, response time: 45.84ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 1024, tps: 36890.27, reads: 368884.65, writes: 0.00, response time: 40.65ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 1024, tps: 35598.38, reads: 355953.14, writes: 0.00, response time: 52.46ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 1024, tps: 36206.80, reads: 362098.01, writes: 0.00, response time: 48.06ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 1024, tps: 36417.97, reads: 364224.02, writes: 0.00, response time: 43.79ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 1024, tps: 36522.16, reads: 365220.96, writes: 0.00, response time: 45.85ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 1024, tps: 36165.04, reads: 361630.38, writes: 0.00, response time: 50.31ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 1024, tps: 36292.34, reads: 362904.71, writes: 0.00, response time: 50.37ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 1024, tps: 36211.49, reads: 362125.86, writes: 0.00, response time: 51.05ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 1024, tps: 36190.22, reads: 361891.53, writes: 0.00, response time: 47.93ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 1024, tps: 36494.30, reads: 364990.97, writes: 0.00, response time: 44.70ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 1024, tps: 35986.34, reads: 359823.36, writes: 0.00, response time: 38.81ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 1024, tps: 36116.03, reads: 361222.97, writes: 0.00, response time: 42.88ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 1024, tps: 35827.65, reads: 358230.15, writes: 0.00, response time: 50.43ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 1024, tps: 36237.72, reads: 362356.86, writes: 0.00, response time: 52.25ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 1024, tps: 36235.26, reads: 362329.95, writes: 0.00, response time: 50.87ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 1024, tps: 36772.03, reads: 367768.99, writes: 0.00, response time: 40.16ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 1024, tps: 36954.97, reads: 369491.38, writes: 0.00, response time: 45.69ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 1024, tps: 36213.33, reads: 362139.25, writes: 0.00, response time: 37.96ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 43527770 write: 0 other: 8705554 total: 52233324 transactions: 4352777 (36263.97 per sec.) read/write requests: 43527770 (362639.74 per sec.) other operations: 8705554 (72527.95 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0303s total number of events: 4352777 total time taken by event execution: 122203.4056s response time: min: 0.45ms avg: 28.07ms max: 1953.17ms approx. 95 percentile: 49.27ms Threads fairness: events (avg/stddev): 4250.7588/115.43 execution time (avg/stddev): 119.3393/0.22 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 2048 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 2048, tps: 31874.12, reads: 321490.44, writes: 0.00, response time: 228.88ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 2048, tps: 37376.09, reads: 373554.93, writes: 0.00, response time: 291.77ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 2048, tps: 36252.26, reads: 362849.62, writes: 0.00, response time: 387.04ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 2048, tps: 39055.10, reads: 390477.38, writes: 0.00, response time: 290.46ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 2048, tps: 37733.33, reads: 377635.31, writes: 0.00, response time: 152.52ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 2048, tps: 34147.45, reads: 341530.50, writes: 0.00, response time: 121.12ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 2048, tps: 32745.59, reads: 327449.28, writes: 0.00, response time: 88.88ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 2048, tps: 32533.77, reads: 325378.65, writes: 0.00, response time: 88.72ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 2048, tps: 32808.87, reads: 327960.00, writes: 0.00, response time: 96.45ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 2048, tps: 32300.88, reads: 323154.51, writes: 0.00, response time: 86.91ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 2048, tps: 32625.09, reads: 326267.86, writes: 0.00, response time: 95.19ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 2048, tps: 32326.38, reads: 323197.44, writes: 0.00, response time: 99.50ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 2048, tps: 32422.25, reads: 324167.13, writes: 0.00, response time: 83.07ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 2048, tps: 32206.41, reads: 322124.05, writes: 0.00, response time: 87.61ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 2048, tps: 32503.60, reads: 324971.65, writes: 0.00, response time: 101.36ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 2048, tps: 31802.07, reads: 318026.06, writes: 0.00, response time: 109.79ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 2048, tps: 31714.98, reads: 317197.78, writes: 0.00, response time: 111.35ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 2048, tps: 32124.99, reads: 321152.58, writes: 0.00, response time: 91.50ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 2048, tps: 31882.05, reads: 318988.86, writes: 0.00, response time: 111.08ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 2048, tps: 32502.98, reads: 324848.42, writes: 0.00, response time: 110.45ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 2048, tps: 32620.66, reads: 326350.96, writes: 0.00, response time: 121.81ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 2048, tps: 32495.94, reads: 324979.69, writes: 0.00, response time: 84.49ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 2048, tps: 32393.09, reads: 323899.27, writes: 0.00, response time: 108.59ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 2048, tps: 32439.64, reads: 324357.68, writes: 0.00, response time: 82.79ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 2048, tps: 32599.70, reads: 325987.69, writes: 0.00, response time: 106.72ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 2048, tps: 32207.00, reads: 322102.64, writes: 0.00, response time: 112.15ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 2048, tps: 32421.82, reads: 324172.15, writes: 0.00, response time: 110.78ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 2048, tps: 32589.30, reads: 325948.62, writes: 0.00, response time: 111.08ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 2048, tps: 32421.32, reads: 324244.50, writes: 0.00, response time: 102.09ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 2048, tps: 32698.62, reads: 326825.56, writes: 0.00, response time: 87.87ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 2048, tps: 32373.01, reads: 323822.05, writes: 0.00, response time: 95.90ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 2048, tps: 32305.36, reads: 323083.27, writes: 0.00, response time: 104.25ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 2048, tps: 32616.32, reads: 326214.85, writes: 0.00, response time: 89.25ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 2048, tps: 32644.01, reads: 326348.77, writes: 0.00, response time: 88.53ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 2048, tps: 32326.24, reads: 323276.45, writes: 0.00, response time: 93.49ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 2048, tps: 31596.69, reads: 316000.87, writes: 0.00, response time: 78.64ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 2048, tps: 32420.25, reads: 324147.55, writes: 0.00, response time: 91.03ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 2048, tps: 31649.00, reads: 316518.35, writes: 0.00, response time: 88.93ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 2048, tps: 32149.05, reads: 321523.21, writes: 0.00, response time: 86.93ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 2048, tps: 32513.28, reads: 325018.83, writes: 0.00, response time: 93.63ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 39513070 write: 0 other: 7902614 total: 47415684 transactions: 3951307 (32908.74 per sec.) read/write requests: 39513070 (329087.37 per sec.) other operations: 7902614 (65817.47 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0686s total number of events: 3951307 total time taken by event execution: 244841.4969s response time: min: 0.48ms avg: 61.96ms max: 3659.33ms approx. 95 percentile: 106.52ms Threads fairness: events (avg/stddev): 1929.3491/135.58 execution time (avg/stddev): 119.5515/0.19 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 4096 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 4096, tps: 29747.80, reads: 303027.01, writes: 0.00, response time: 450.61ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 4096, tps: 32543.89, reads: 325460.20, writes: 0.00, response time: 347.50ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 4096, tps: 35881.51, reads: 358490.73, writes: 0.00, response time: 558.15ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 4096, tps: 37186.68, reads: 371996.10, writes: 0.00, response time: 635.96ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 4096, tps: 36813.05, reads: 368383.85, writes: 0.00, response time: 779.76ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 4096, tps: 35145.18, reads: 351359.50, writes: 0.00, response time: 614.44ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 4096, tps: 36743.40, reads: 367487.01, writes: 0.00, response time: 597.21ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 4096, tps: 36226.96, reads: 360683.59, writes: 0.00, response time: 661.99ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 4096, tps: 30898.69, reads: 311314.87, writes: 0.00, response time: 421.76ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 4096, tps: 30369.72, reads: 303604.83, writes: 0.00, response time: 236.19ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 4096, tps: 30964.32, reads: 309694.17, writes: 0.00, response time: 158.81ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 4096, tps: 30657.32, reads: 306672.21, writes: 0.00, response time: 157.39ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 4096, tps: 30045.66, reads: 300257.25, writes: 0.00, response time: 168.50ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 4096, tps: 29939.33, reads: 299419.27, writes: 0.00, response time: 158.71ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 4096, tps: 30766.70, reads: 307547.33, writes: 0.00, response time: 157.53ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 4096, tps: 30904.72, reads: 309302.19, writes: 0.00, response time: 188.02ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 4096, tps: 31395.63, reads: 313837.00, writes: 0.00, response time: 175.14ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 4096, tps: 31009.32, reads: 310055.23, writes: 0.00, response time: 171.35ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 4096, tps: 31224.88, reads: 312308.51, writes: 0.00, response time: 165.90ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 4096, tps: 31017.55, reads: 310134.50, writes: 0.00, response time: 184.23ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 4096, tps: 30524.57, reads: 305282.72, writes: 0.00, response time: 163.00ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 4096, tps: 30462.02, reads: 304575.19, writes: 0.00, response time: 154.17ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 4096, tps: 30287.01, reads: 302910.46, writes: 0.00, response time: 163.88ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 4096, tps: 30841.24, reads: 308477.78, writes: 0.00, response time: 153.57ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 4096, tps: 30953.86, reads: 309541.58, writes: 0.00, response time: 153.57ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 4096, tps: 30536.53, reads: 305324.25, writes: 0.00, response time: 154.68ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 4096, tps: 30483.01, reads: 304849.75, writes: 0.00, response time: 179.01ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 4096, tps: 30111.39, reads: 301109.94, writes: 0.00, response time: 199.67ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 4096, tps: 30665.47, reads: 306607.00, writes: 0.00, response time: 200.93ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 4096, tps: 30752.42, reads: 307604.84, writes: 0.00, response time: 192.74ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 4096, tps: 30765.08, reads: 307581.51, writes: 0.00, response time: 170.59ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 4096, tps: 30535.26, reads: 305387.26, writes: 0.00, response time: 179.65ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 4096, tps: 30277.24, reads: 302743.72, writes: 0.00, response time: 189.20ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 4096, tps: 30936.92, reads: 309482.85, writes: 0.00, response time: 172.95ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 4096, tps: 30212.88, reads: 302002.76, writes: 0.00, response time: 189.77ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 4096, tps: 29841.24, reads: 298496.03, writes: 0.00, response time: 167.35ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 4096, tps: 30232.12, reads: 302198.84, writes: 0.00, response time: 162.56ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 4096, tps: 31107.98, reads: 311207.82, writes: 0.00, response time: 168.56ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 4096, tps: 30789.37, reads: 307856.39, writes: 0.00, response time: 171.30ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 4096, tps: 30158.85, reads: 301512.16, writes: 0.00, response time: 178.69ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 37839720 write: 0 other: 7567944 total: 45407664 transactions: 3783972 (31496.92 per sec.) read/write requests: 37839720 (314969.18 per sec.) other operations: 7567944 (62993.84 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.1379s total number of events: 3783972 total time taken by event execution: 489440.9713s response time: min: 0.45ms avg: 129.35ms max: 5219.06ms approx. 95 percentile: 207.35ms Threads fairness: events (avg/stddev): 923.8213/99.92 execution time (avg/stddev): 119.4924/0.32 sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 8192 Report intermediate results every 3 second(s) Random number generator seed is 0 and will be ignored Threads started! [ 3s] threads: 8192, tps: 25910.86, reads: 270702.00, writes: 0.00, response time: 1280.09ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 8192, tps: 29706.82, reads: 296335.16, writes: 0.00, response time: 686.40ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 8192, tps: 29747.35, reads: 297456.14, writes: 0.00, response time: 734.66ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 8192, tps: 29606.80, reads: 296287.66, writes: 0.00, response time: 717.28ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 8192, tps: 31061.13, reads: 310319.68, writes: 0.00, response time: 853.28ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 8192, tps: 32673.02, reads: 326873.24, writes: 0.00, response time: 1074.14ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 8192, tps: 32349.32, reads: 323555.58, writes: 0.00, response time: 1145.54ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 8192, tps: 32144.38, reads: 321117.18, writes: 0.00, response time: 1335.28ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 8192, tps: 30011.69, reads: 302067.54, writes: 0.00, response time: 1547.61ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 8192, tps: 30096.89, reads: 300859.57, writes: 0.00, response time: 1235.67ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 8192, tps: 30726.16, reads: 306138.96, writes: 0.00, response time: 871.34ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 8192, tps: 32368.77, reads: 323230.71, writes: 0.00, response time: 1382.04ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 8192, tps: 33828.79, reads: 338247.87, writes: 0.00, response time: 1204.26ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 8192, tps: 34503.22, reads: 345485.90, writes: 0.00, response time: 1289.32ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 8192, tps: 35115.62, reads: 351278.24, writes: 0.00, response time: 1461.61ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 8192, tps: 32219.22, reads: 321890.23, writes: 0.00, response time: 1342.89ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 8192, tps: 33621.48, reads: 336423.76, writes: 0.00, response time: 1542.99ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 8192, tps: 32348.63, reads: 323451.33, writes: 0.00, response time: 1682.41ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 8192, tps: 31671.74, reads: 316791.70, writes: 0.00, response time: 1384.11ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 8192, tps: 30295.52, reads: 303411.53, writes: 0.00, response time: 1146.57ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 8192, tps: 29480.34, reads: 295573.04, writes: 0.00, response time: 889.26ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 8192, tps: 31952.80, reads: 318689.99, writes: 0.00, response time: 1276.27ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 8192, tps: 30550.22, reads: 305741.89, writes: 0.00, response time: 629.14ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 8192, tps: 30954.60, reads: 309639.02, writes: 0.00, response time: 1439.90ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 8192, tps: 30241.69, reads: 302775.60, writes: 0.00, response time: 624.26ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 8192, tps: 29450.09, reads: 294326.28, writes: 0.00, response time: 493.39ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 8192, tps: 29416.18, reads: 294401.09, writes: 0.00, response time: 365.97ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 8192, tps: 29601.69, reads: 295979.54, writes: 0.00, response time: 337.76ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 8192, tps: 29215.50, reads: 292207.37, writes: 0.00, response time: 323.99ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 8192, tps: 29020.05, reads: 290150.21, writes: 0.00, response time: 340.09ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 8192, tps: 28869.77, reads: 288689.71, writes: 0.00, response time: 351.27ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 8192, tps: 28829.40, reads: 288581.64, writes: 0.00, response time: 338.47ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 8192, tps: 29378.03, reads: 293475.26, writes: 0.00, response time: 335.84ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 8192, tps: 29515.82, reads: 295285.51, writes: 0.00, response time: 326.82ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 8192, tps: 28757.54, reads: 287640.72, writes: 0.00, response time: 334.24ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 8192, tps: 29043.57, reads: 290253.68, writes: 0.00, response time: 323.31ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 8192, tps: 29108.90, reads: 291131.97, writes: 0.00, response time: 334.54ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 8192, tps: 28711.20, reads: 287051.30, writes: 0.00, response time: 337.76ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 8192, tps: 29178.20, reads: 291734.33, writes: 0.00, response time: 337.76ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 8192, tps: 29164.83, reads: 292004.98, writes: 0.00, response time: 324.96ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 36695390 write: 0 other: 7339078 total: 44034468 transactions: 3669539 (30501.89 per sec.) read/write requests: 36695390 (305018.93 per sec.) other operations: 7339078 (61003.79 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.3053s total number of events: 3669539 total time taken by event execution: 978165.8141s response time: min: 0.46ms avg: 266.56ms max: 7311.44ms approx. 95 percentile: 837.08ms Threads fairness: events (avg/stddev): 447.9418/163.58 execution time (avg/stddev): 119.4050/0.38