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: 6887.39, reads: 68877.60, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 4, tps: 7063.40, reads: 70639.30, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 4, tps: 7144.99, reads: 71447.22, writes: 0.00, response time: 0.64ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 4, tps: 7357.41, reads: 73570.06, writes: 0.00, response time: 0.61ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 4, tps: 7820.34, reads: 78203.42, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 4, tps: 7627.00, reads: 76276.38, writes: 0.00, response time: 0.61ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 4, tps: 7716.03, reads: 77157.63, writes: 0.00, response time: 0.63ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 4, tps: 7128.99, reads: 71290.56, writes: 0.00, response time: 0.68ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 4, tps: 7678.99, reads: 76791.55, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 4, tps: 7475.68, reads: 74757.45, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 4, tps: 7524.66, reads: 75245.27, writes: 0.00, response time: 0.65ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 4, tps: 7980.67, reads: 79805.69, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 4, tps: 7939.99, reads: 79398.61, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 4, tps: 7625.27, reads: 76253.75, writes: 0.00, response time: 0.65ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 4, tps: 8025.67, reads: 80262.05, writes: 0.00, response time: 0.59ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 4, tps: 8099.30, reads: 80991.37, writes: 0.00, response time: 0.58ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 4, tps: 7998.75, reads: 79981.86, writes: 0.00, response time: 0.61ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 4, tps: 7585.68, reads: 75861.81, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 4, tps: 7435.58, reads: 74351.83, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 4, tps: 7483.66, reads: 74837.97, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 4, tps: 7632.98, reads: 76330.10, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 4, tps: 8356.12, reads: 83560.16, writes: 0.00, response time: 0.57ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 4, tps: 7862.01, reads: 78621.09, writes: 0.00, response time: 0.62ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 4, tps: 7423.99, reads: 74239.92, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 4, tps: 7813.00, reads: 78127.34, writes: 0.00, response time: 0.64ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 4, tps: 7667.24, reads: 76674.07, writes: 0.00, response time: 0.64ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 4, tps: 8237.69, reads: 82378.20, writes: 0.00, response time: 0.53ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 4, tps: 7737.74, reads: 77375.43, writes: 0.00, response time: 0.63ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 4, tps: 7841.57, reads: 78420.70, writes: 0.00, response time: 0.61ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 4, tps: 7136.35, reads: 71360.87, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 4, tps: 7265.66, reads: 72653.61, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 4, tps: 7198.99, reads: 71989.61, writes: 0.00, response time: 0.69ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 4, tps: 7360.99, reads: 73610.21, writes: 0.00, response time: 0.63ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 4, tps: 7211.34, reads: 72110.44, writes: 0.00, response time: 0.68ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 4, tps: 6874.01, reads: 68743.46, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 4, tps: 6515.66, reads: 65156.56, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 4, tps: 7773.41, reads: 77735.77, writes: 0.00, response time: 0.66ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 4, tps: 7909.36, reads: 79097.31, writes: 0.00, response time: 0.63ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 4, tps: 7454.97, reads: 74542.05, writes: 0.00, response time: 0.68ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 4, tps: 7779.01, reads: 77795.40, writes: 0.00, response time: 0.65ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 9079550 write: 0 other: 1815910 total: 10895460 transactions: 907955 (7566.26 per sec.) read/write requests: 9079550 (75662.59 per sec.) other operations: 1815910 (15132.52 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: 907955 total time taken by event execution: 479.2713s response time: min: 0.40ms avg: 0.53ms max: 5.08ms approx. 95 percentile: 0.67ms Threads fairness: events (avg/stddev): 226988.7500/3378.35 execution time (avg/stddev): 119.8178/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: 14088.57, reads: 140894.35, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 8, tps: 14741.68, reads: 147420.50, writes: 0.00, response time: 0.69ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 8, tps: 14428.32, reads: 144284.90, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 8, tps: 14595.36, reads: 145954.91, writes: 0.00, response time: 0.68ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 8, tps: 13845.99, reads: 138457.20, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 8, tps: 14129.33, reads: 141295.62, writes: 0.00, response time: 0.70ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 8, tps: 14150.36, reads: 141499.64, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 8, tps: 13953.66, reads: 139536.98, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 8, tps: 12998.63, reads: 129985.98, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 8, tps: 13467.03, reads: 134672.59, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 8, tps: 13434.33, reads: 134340.63, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 8, tps: 13620.01, reads: 136200.72, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 8, tps: 13887.33, reads: 138871.65, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 8, tps: 13482.33, reads: 134829.00, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 8, tps: 13308.65, reads: 133080.52, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 8, tps: 13803.69, reads: 138037.25, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 8, tps: 14168.34, reads: 141691.03, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 8, tps: 13232.66, reads: 132323.27, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 8, tps: 13767.32, reads: 137671.57, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 8, tps: 13662.67, reads: 136625.39, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 8, tps: 13287.00, reads: 132871.00, writes: 0.00, response time: 0.72ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 8, tps: 14202.66, reads: 142022.95, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 8, tps: 13199.00, reads: 131992.02, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 8, tps: 13691.64, reads: 136919.07, writes: 0.00, response time: 0.76ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 8, tps: 13727.69, reads: 137275.23, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 8, tps: 13519.68, reads: 135198.10, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 8, tps: 13533.33, reads: 135335.30, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 8, tps: 14066.33, reads: 140660.62, writes: 0.00, response time: 0.75ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 8, tps: 14743.68, reads: 147437.46, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 8, tps: 13849.32, reads: 138495.90, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 8, tps: 13451.67, reads: 134511.38, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 8, tps: 14141.33, reads: 141417.29, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 8, tps: 13848.67, reads: 138482.99, writes: 0.00, response time: 0.71ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 8, tps: 13694.64, reads: 136949.41, writes: 0.00, response time: 0.74ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 8, tps: 13246.35, reads: 132464.79, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 8, tps: 13714.35, reads: 137142.17, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 8, tps: 14105.66, reads: 141055.60, writes: 0.00, response time: 0.73ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 8, tps: 13212.96, reads: 132129.27, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 8, tps: 13646.37, reads: 136464.71, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 8, tps: 13728.98, reads: 137292.10, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 16541380 write: 0 other: 3308276 total: 19849656 transactions: 1654138 (13784.40 per sec.) read/write requests: 16541380 (137843.99 per sec.) other operations: 3308276 (27568.80 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0007s total number of events: 1654138 total time taken by event execution: 958.6061s response time: min: 0.43ms avg: 0.58ms max: 16.89ms approx. 95 percentile: 0.75ms Threads fairness: events (avg/stddev): 206767.2500/8568.71 execution time (avg/stddev): 119.8258/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: 21824.57, reads: 218266.39, writes: 0.00, response time: 0.85ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 16, tps: 23021.98, reads: 230222.50, writes: 0.00, response time: 0.82ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 16, tps: 23600.71, reads: 236006.79, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 16, tps: 23791.29, reads: 237915.89, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 16, tps: 23693.36, reads: 236932.63, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 16, tps: 23800.61, reads: 237998.39, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 16, tps: 23698.74, reads: 236990.10, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 16, tps: 23604.99, reads: 236056.57, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 16, tps: 23505.34, reads: 235054.71, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 16, tps: 23413.30, reads: 234133.96, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 16, tps: 23482.68, reads: 234823.46, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 16, tps: 23586.70, reads: 235859.97, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 16, tps: 23740.65, reads: 237413.53, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 16, tps: 23784.95, reads: 237846.19, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 16, tps: 24087.39, reads: 240880.58, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 16, tps: 24029.34, reads: 240292.44, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 16, tps: 23750.99, reads: 237510.21, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 16, tps: 23721.68, reads: 237215.48, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 16, tps: 23770.30, reads: 237699.02, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 16, tps: 23825.70, reads: 238262.66, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 16, tps: 23724.64, reads: 237239.11, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 16, tps: 23838.02, reads: 238390.58, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 16, tps: 23618.65, reads: 236177.12, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 16, tps: 23695.96, reads: 236963.28, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 16, tps: 23625.71, reads: 236257.45, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 16, tps: 23584.33, reads: 235842.35, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 16, tps: 23288.98, reads: 232893.75, writes: 0.00, response time: 0.77ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 16, tps: 23546.03, reads: 235456.99, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 16, tps: 24018.65, reads: 240187.14, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 16, tps: 23911.03, reads: 239102.94, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 16, tps: 23977.30, reads: 239776.38, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 16, tps: 23991.34, reads: 239923.41, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 16, tps: 23915.34, reads: 239144.72, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 16, tps: 23810.99, reads: 238114.20, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 16, tps: 23673.67, reads: 236735.41, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 16, tps: 23504.01, reads: 235040.48, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 16, tps: 23644.66, reads: 236443.65, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 16, tps: 24093.01, reads: 240930.40, writes: 0.00, response time: 0.78ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 16, tps: 23742.99, reads: 237432.88, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 16, tps: 23740.31, reads: 237405.09, writes: 0.00, response time: 0.79ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 28400540 write: 0 other: 5680108 total: 34080648 transactions: 2840054 (23666.84 per sec.) read/write requests: 28400540 (236668.40 per sec.) other operations: 5680108 (47333.68 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0014s total number of events: 2840054 total time taken by event execution: 1917.8110s response time: min: 0.47ms avg: 0.68ms max: 8.69ms approx. 95 percentile: 0.78ms Threads fairness: events (avg/stddev): 177503.3750/3285.53 execution time (avg/stddev): 119.8632/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: 30670.00, reads: 306747.69, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 32, tps: 30863.30, reads: 308633.33, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 32, tps: 30777.65, reads: 307779.18, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 32, tps: 30777.07, reads: 307763.71, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 32, tps: 30817.60, reads: 308179.03, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 32, tps: 30864.37, reads: 308653.39, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 32, tps: 30887.66, reads: 308866.58, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 32, tps: 30783.00, reads: 307828.35, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 32, tps: 30843.99, reads: 308425.87, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 32, tps: 30813.35, reads: 308147.15, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 32, tps: 30865.30, reads: 308644.68, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 32, tps: 30866.07, reads: 308668.00, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 32, tps: 30850.64, reads: 308515.69, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 32, tps: 30808.32, reads: 308090.24, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 32, tps: 30849.02, reads: 308477.51, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 32, tps: 30891.03, reads: 308908.31, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 32, tps: 30874.32, reads: 308750.89, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 32, tps: 30847.33, reads: 308461.61, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 32, tps: 30859.95, reads: 308602.87, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 32, tps: 30848.05, reads: 308480.48, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 32, tps: 30855.00, reads: 308548.70, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 32, tps: 30815.67, reads: 308161.06, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 32, tps: 30739.33, reads: 307392.97, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 32, tps: 30848.00, reads: 308481.98, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 32, tps: 30854.32, reads: 308531.54, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 32, tps: 30852.68, reads: 308532.81, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 32, tps: 30843.61, reads: 308435.72, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 32, tps: 30735.72, reads: 307365.19, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 32, tps: 30821.33, reads: 308205.93, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 32, tps: 30838.36, reads: 308392.56, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 32, tps: 30844.67, reads: 308442.99, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 32, tps: 30763.32, reads: 307635.87, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 32, tps: 30806.66, reads: 308069.59, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 32, tps: 30796.33, reads: 307958.94, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 32, tps: 30841.36, reads: 308418.90, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 32, tps: 30796.00, reads: 307957.63, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 32, tps: 30782.33, reads: 307823.29, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 32, tps: 30751.33, reads: 307501.95, writes: 0.00, response time: 1.28ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 32, tps: 30867.35, reads: 308678.19, writes: 0.00, response time: 1.27ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 32, tps: 30858.32, reads: 308588.22, writes: 0.00, response time: 1.26ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 36989410 write: 0 other: 7397882 total: 44387292 transactions: 3698941 (30824.15 per sec.) read/write requests: 36989410 (308241.46 per sec.) other operations: 7397882 (61648.29 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0014s total number of events: 3698941 total time taken by event execution: 3835.0350s response time: min: 0.61ms avg: 1.04ms max: 12.16ms approx. 95 percentile: 1.27ms Threads fairness: events (avg/stddev): 115591.9062/656.50 execution time (avg/stddev): 119.8448/0.00 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: 34777.88, reads: 347868.84, writes: 0.00, response time: 2.80ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 64, tps: 35196.03, reads: 351959.97, writes: 0.00, response time: 2.73ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 64, tps: 35286.26, reads: 352871.91, writes: 0.00, response time: 2.67ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 64, tps: 35048.34, reads: 350498.78, writes: 0.00, response time: 2.78ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 64, tps: 35188.39, reads: 351857.93, writes: 0.00, response time: 2.70ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 64, tps: 35122.60, reads: 351224.99, writes: 0.00, response time: 2.72ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 64, tps: 35146.65, reads: 351479.17, writes: 0.00, response time: 2.73ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 64, tps: 34990.05, reads: 349914.51, writes: 0.00, response time: 2.80ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 64, tps: 35175.27, reads: 351737.34, writes: 0.00, response time: 2.75ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 64, tps: 35252.75, reads: 352543.49, writes: 0.00, response time: 2.68ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 64, tps: 35266.34, reads: 352656.03, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 64, tps: 35243.27, reads: 352435.66, writes: 0.00, response time: 2.72ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 64, tps: 35204.39, reads: 352023.56, writes: 0.00, response time: 2.74ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 64, tps: 35273.34, reads: 352748.77, writes: 0.00, response time: 2.70ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 64, tps: 35260.99, reads: 352603.60, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 64, tps: 35176.98, reads: 351765.76, writes: 0.00, response time: 2.72ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 64, tps: 35173.29, reads: 351733.21, writes: 0.00, response time: 2.74ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 64, tps: 35261.08, reads: 352605.51, writes: 0.00, response time: 2.69ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 64, tps: 35344.32, reads: 353446.21, writes: 0.00, response time: 2.70ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 64, tps: 35117.68, reads: 351190.48, writes: 0.00, response time: 2.74ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 64, tps: 35271.99, reads: 352715.54, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 64, tps: 35208.98, reads: 352089.83, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 64, tps: 35224.01, reads: 352237.45, writes: 0.00, response time: 2.69ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 64, tps: 35135.01, reads: 351339.74, writes: 0.00, response time: 2.72ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 64, tps: 35163.61, reads: 351639.76, writes: 0.00, response time: 2.72ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 64, tps: 35101.06, reads: 351011.92, writes: 0.00, response time: 2.75ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 64, tps: 35221.69, reads: 352228.86, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 64, tps: 35056.63, reads: 350570.33, writes: 0.00, response time: 2.76ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 64, tps: 35223.33, reads: 352223.33, writes: 0.00, response time: 2.69ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 64, tps: 35364.36, reads: 353651.26, writes: 0.00, response time: 2.68ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 64, tps: 35216.30, reads: 352148.69, writes: 0.00, response time: 2.70ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 64, tps: 35208.34, reads: 352094.74, writes: 0.00, response time: 2.73ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 64, tps: 35126.33, reads: 351251.59, writes: 0.00, response time: 2.76ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 64, tps: 35117.36, reads: 351195.64, writes: 0.00, response time: 2.74ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 64, tps: 35210.65, reads: 352092.51, writes: 0.00, response time: 2.69ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 64, tps: 35199.33, reads: 352007.67, writes: 0.00, response time: 2.74ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 64, tps: 35112.65, reads: 351097.51, writes: 0.00, response time: 2.77ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 64, tps: 35194.98, reads: 351978.43, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 64, tps: 35170.72, reads: 351701.15, writes: 0.00, response time: 2.71ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 64, tps: 35150.63, reads: 351507.98, writes: 0.00, response time: 2.73ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 42216170 write: 0 other: 8443234 total: 50659404 transactions: 4221617 (35179.43 per sec.) read/write requests: 42216170 (351794.34 per sec.) other operations: 8443234 (70358.87 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: 4221617 total time taken by event execution: 7673.9247s response time: min: 0.62ms avg: 1.82ms max: 34.93ms approx. 95 percentile: 2.72ms Threads fairness: events (avg/stddev): 65962.7656/322.61 execution time (avg/stddev): 119.9051/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: 34556.78, reads: 345769.14, writes: 0.00, response time: 9.50ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 128, tps: 35134.10, reads: 351334.35, writes: 0.00, response time: 9.34ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 128, tps: 35139.31, reads: 351385.45, writes: 0.00, response time: 9.10ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 128, tps: 35130.98, reads: 351334.47, writes: 0.00, response time: 9.09ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 128, tps: 34956.01, reads: 349528.75, writes: 0.00, response time: 9.40ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 128, tps: 34874.64, reads: 348771.39, writes: 0.00, response time: 9.62ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 128, tps: 35119.02, reads: 351170.51, writes: 0.00, response time: 9.20ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 128, tps: 35025.37, reads: 350234.65, writes: 0.00, response time: 9.31ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 128, tps: 34975.65, reads: 349796.83, writes: 0.00, response time: 9.45ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 128, tps: 34755.30, reads: 347503.03, writes: 0.00, response time: 9.56ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 128, tps: 35060.65, reads: 350653.53, writes: 0.00, response time: 9.08ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 128, tps: 35097.00, reads: 350982.70, writes: 0.00, response time: 9.09ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 128, tps: 34928.69, reads: 349282.88, writes: 0.00, response time: 9.13ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 128, tps: 35077.63, reads: 350771.68, writes: 0.00, response time: 9.34ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 128, tps: 35168.41, reads: 351697.76, writes: 0.00, response time: 9.32ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 128, tps: 35064.98, reads: 350621.17, writes: 0.00, response time: 9.07ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 128, tps: 35172.28, reads: 351727.18, writes: 0.00, response time: 9.11ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 128, tps: 35244.74, reads: 352451.70, writes: 0.00, response time: 9.06ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 128, tps: 35039.96, reads: 350398.23, writes: 0.00, response time: 9.13ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 128, tps: 35251.36, reads: 352517.24, writes: 0.00, response time: 9.11ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 128, tps: 35091.96, reads: 350908.61, writes: 0.00, response time: 9.38ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 128, tps: 34961.96, reads: 349626.58, writes: 0.00, response time: 9.47ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 128, tps: 35011.10, reads: 350101.97, writes: 0.00, response time: 9.31ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 128, tps: 34960.64, reads: 349634.07, writes: 0.00, response time: 9.50ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 128, tps: 35159.00, reads: 351573.00, writes: 0.00, response time: 9.35ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 128, tps: 35086.99, reads: 350858.26, writes: 0.00, response time: 9.32ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 128, tps: 34907.70, reads: 349082.96, writes: 0.00, response time: 9.42ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 128, tps: 35047.00, reads: 350475.31, writes: 0.00, response time: 9.25ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 128, tps: 35208.60, reads: 352074.00, writes: 0.00, response time: 9.09ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 128, tps: 35198.30, reads: 351984.68, writes: 0.00, response time: 9.13ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 128, tps: 35196.09, reads: 351966.61, writes: 0.00, response time: 9.20ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 128, tps: 35171.64, reads: 351717.35, writes: 0.00, response time: 8.93ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 128, tps: 35339.67, reads: 353387.36, writes: 0.00, response time: 9.49ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 128, tps: 35191.27, reads: 351920.71, writes: 0.00, response time: 9.15ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 128, tps: 35344.41, reads: 353441.12, writes: 0.00, response time: 9.06ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 128, tps: 35117.32, reads: 351175.52, writes: 0.00, response time: 9.09ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 128, tps: 34963.68, reads: 349645.09, writes: 0.00, response time: 9.31ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 128, tps: 35523.35, reads: 355224.81, writes: 0.00, response time: 8.86ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 128, tps: 35059.31, reads: 350600.74, writes: 0.00, response time: 9.26ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 128, tps: 35348.66, reads: 353471.96, writes: 0.00, response time: 9.23ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 42111130 write: 0 other: 8422226 total: 50533356 transactions: 4211113 (35090.86 per sec.) read/write requests: 42111130 (350908.59 per sec.) other operations: 8422226 (70181.72 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0060s total number of events: 4211113 total time taken by event execution: 15352.2060s response time: min: 0.57ms avg: 3.65ms max: 59.38ms approx. 95 percentile: 9.24ms Threads fairness: events (avg/stddev): 32899.3203/149.16 execution time (avg/stddev): 119.9391/0.01 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: 33695.39, reads: 337355.91, writes: 0.00, response time: 23.11ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 256, tps: 34187.77, reads: 341889.38, writes: 0.00, response time: 22.88ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 256, tps: 34270.01, reads: 342696.10, writes: 0.00, response time: 22.33ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 256, tps: 34453.68, reads: 344517.84, writes: 0.00, response time: 22.06ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 256, tps: 34030.98, reads: 340311.80, writes: 0.00, response time: 23.07ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 256, tps: 33851.37, reads: 338534.32, writes: 0.00, response time: 23.47ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 256, tps: 34483.96, reads: 344812.57, writes: 0.00, response time: 22.85ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 256, tps: 34056.00, reads: 340552.67, writes: 0.00, response time: 22.46ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 256, tps: 34639.03, reads: 346426.27, writes: 0.00, response time: 21.09ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 256, tps: 34468.00, reads: 344649.37, writes: 0.00, response time: 22.50ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 256, tps: 34372.62, reads: 343779.23, writes: 0.00, response time: 22.56ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 256, tps: 34681.93, reads: 346801.99, writes: 0.00, response time: 22.42ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 256, tps: 34269.46, reads: 342690.23, writes: 0.00, response time: 22.77ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 256, tps: 34669.33, reads: 346670.61, writes: 0.00, response time: 22.24ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 256, tps: 34224.64, reads: 342257.42, writes: 0.00, response time: 22.50ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 256, tps: 34374.22, reads: 343716.86, writes: 0.00, response time: 22.40ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 256, tps: 34375.45, reads: 343756.47, writes: 0.00, response time: 22.57ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 256, tps: 34194.99, reads: 341945.90, writes: 0.00, response time: 22.98ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 256, tps: 34473.66, reads: 344808.95, writes: 0.00, response time: 22.28ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 256, tps: 34090.28, reads: 340826.45, writes: 0.00, response time: 23.54ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 256, tps: 34475.33, reads: 344807.60, writes: 0.00, response time: 22.36ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 256, tps: 34107.92, reads: 341060.52, writes: 0.00, response time: 23.14ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 256, tps: 33949.16, reads: 339462.25, writes: 0.00, response time: 23.55ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 256, tps: 34325.21, reads: 343343.11, writes: 0.00, response time: 22.75ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 256, tps: 34962.11, reads: 349540.45, writes: 0.00, response time: 22.57ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 256, tps: 34532.65, reads: 345336.50, writes: 0.00, response time: 22.35ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 256, tps: 34376.04, reads: 343797.02, writes: 0.00, response time: 22.67ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 256, tps: 34548.62, reads: 345455.52, writes: 0.00, response time: 22.25ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 256, tps: 34480.06, reads: 344798.29, writes: 0.00, response time: 22.73ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 256, tps: 34278.96, reads: 342779.90, writes: 0.00, response time: 22.88ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 256, tps: 34120.92, reads: 341248.55, writes: 0.00, response time: 23.25ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 256, tps: 33886.42, reads: 338886.85, writes: 0.00, response time: 23.71ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 256, tps: 34339.00, reads: 343356.02, writes: 0.00, response time: 23.08ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 256, tps: 34653.68, reads: 346539.15, writes: 0.00, response time: 22.41ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 256, tps: 33936.30, reads: 339300.02, writes: 0.00, response time: 23.23ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 256, tps: 34531.70, reads: 345358.37, writes: 0.00, response time: 22.39ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 256, tps: 34232.32, reads: 342306.24, writes: 0.00, response time: 23.05ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 256, tps: 34499.01, reads: 345009.42, writes: 0.00, response time: 22.27ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 256, tps: 34117.97, reads: 341199.99, writes: 0.00, response time: 22.78ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 256, tps: 34118.69, reads: 341155.58, writes: 0.00, response time: 23.82ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 41172620 write: 0 other: 8234524 total: 49407144 transactions: 4117262 (34307.98 per sec.) read/write requests: 41172620 (343079.80 per sec.) other operations: 8234524 (68615.96 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0089s total number of events: 4117262 total time taken by event execution: 30707.7782s response time: min: 0.57ms avg: 7.46ms max: 126.02ms approx. 95 percentile: 22.73ms Threads fairness: events (avg/stddev): 16083.0547/113.22 execution time (avg/stddev): 119.9523/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: 30183.41, reads: 302603.45, writes: 0.00, response time: 54.81ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 512, tps: 30905.76, reads: 309088.92, writes: 0.00, response time: 59.09ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 512, tps: 32102.67, reads: 320972.66, writes: 0.00, response time: 55.62ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 512, tps: 31893.34, reads: 318951.03, writes: 0.00, response time: 55.70ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 512, tps: 31329.31, reads: 313317.72, writes: 0.00, response time: 55.47ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 512, tps: 31025.03, reads: 310381.26, writes: 0.00, response time: 58.42ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 512, tps: 32679.01, reads: 326632.07, writes: 0.00, response time: 52.76ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 512, tps: 31637.94, reads: 316400.35, writes: 0.00, response time: 55.92ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 512, tps: 31269.73, reads: 312472.68, writes: 0.00, response time: 56.39ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 512, tps: 30730.97, reads: 307449.03, writes: 0.00, response time: 56.41ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 512, tps: 31624.34, reads: 316318.07, writes: 0.00, response time: 56.71ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 512, tps: 31783.04, reads: 317888.07, writes: 0.00, response time: 56.73ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 512, tps: 32043.25, reads: 320418.48, writes: 0.00, response time: 57.09ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 512, tps: 32114.41, reads: 321073.07, writes: 0.00, response time: 53.98ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 512, tps: 32432.99, reads: 324405.60, writes: 0.00, response time: 55.75ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 512, tps: 31314.34, reads: 313074.77, writes: 0.00, response time: 54.58ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 512, tps: 30366.63, reads: 303668.97, writes: 0.00, response time: 59.58ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 512, tps: 31803.00, reads: 318369.99, writes: 0.00, response time: 55.87ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 512, tps: 31405.38, reads: 313602.09, writes: 0.00, response time: 56.41ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 512, tps: 32313.30, reads: 323312.31, writes: 0.00, response time: 54.29ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 512, tps: 32116.98, reads: 321223.48, writes: 0.00, response time: 57.15ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 512, tps: 31830.71, reads: 318195.72, writes: 0.00, response time: 55.40ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 512, tps: 31569.63, reads: 315848.93, writes: 0.00, response time: 56.24ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 512, tps: 31388.04, reads: 313712.73, writes: 0.00, response time: 58.57ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 512, tps: 32167.60, reads: 322208.37, writes: 0.00, response time: 53.99ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 512, tps: 31215.33, reads: 311671.96, writes: 0.00, response time: 56.98ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 512, tps: 31309.65, reads: 313081.83, writes: 0.00, response time: 57.00ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 512, tps: 30917.70, reads: 309190.36, writes: 0.00, response time: 57.74ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 512, tps: 31967.67, reads: 320295.73, writes: 0.00, response time: 56.05ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 512, tps: 31746.01, reads: 316804.43, writes: 0.00, response time: 56.05ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 512, tps: 31688.35, reads: 316894.52, writes: 0.00, response time: 56.02ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 512, tps: 31078.35, reads: 310788.85, writes: 0.00, response time: 58.43ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 512, tps: 31248.29, reads: 312544.62, writes: 0.00, response time: 56.44ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 512, tps: 31352.38, reads: 313493.80, writes: 0.00, response time: 57.03ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 512, tps: 31453.32, reads: 314498.51, writes: 0.00, response time: 56.44ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 512, tps: 30820.95, reads: 308212.12, writes: 0.00, response time: 56.14ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 512, tps: 31568.39, reads: 315812.20, writes: 0.00, response time: 56.78ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 512, tps: 30726.90, reads: 307366.00, writes: 0.00, response time: 57.05ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 512, tps: 31122.44, reads: 310983.75, writes: 0.00, response time: 58.03ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 512, tps: 31216.01, reads: 312179.40, writes: 0.00, response time: 56.32ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 37789010 write: 0 other: 7557802 total: 45346812 transactions: 3778901 (31486.23 per sec.) read/write requests: 37789010 (314862.25 per sec.) other operations: 7557802 (62972.45 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0176s total number of events: 3778901 total time taken by event execution: 61413.3188s response time: min: 0.58ms avg: 16.25ms max: 250.25ms approx. 95 percentile: 56.42ms Threads fairness: events (avg/stddev): 7380.6660/62.88 execution time (avg/stddev): 119.9479/0.04 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: 26309.12, reads: 264726.16, writes: 0.00, response time: 135.10ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 1024, tps: 27118.60, reads: 271941.66, writes: 0.00, response time: 139.88ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 1024, tps: 26319.03, reads: 262590.30, writes: 0.00, response time: 139.71ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 1024, tps: 27300.32, reads: 273043.17, writes: 0.00, response time: 140.68ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 1024, tps: 25626.32, reads: 256043.83, writes: 0.00, response time: 142.07ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 1024, tps: 26230.29, reads: 262245.23, writes: 0.00, response time: 139.75ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 1024, tps: 25662.33, reads: 256599.26, writes: 0.00, response time: 145.69ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 1024, tps: 25575.73, reads: 255829.68, writes: 0.00, response time: 139.96ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 1024, tps: 26826.98, reads: 268211.81, writes: 0.00, response time: 144.47ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 1024, tps: 25553.03, reads: 255585.32, writes: 0.00, response time: 140.30ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 1024, tps: 26180.33, reads: 261704.32, writes: 0.00, response time: 139.17ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 1024, tps: 26017.99, reads: 260971.20, writes: 0.00, response time: 148.46ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 1024, tps: 26262.34, reads: 261888.40, writes: 0.00, response time: 138.67ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 1024, tps: 25587.31, reads: 255799.41, writes: 0.00, response time: 146.65ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 1024, tps: 25240.71, reads: 253111.43, writes: 0.00, response time: 142.37ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 1024, tps: 26391.64, reads: 263242.08, writes: 0.00, response time: 136.53ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 1024, tps: 25932.67, reads: 259069.67, writes: 0.00, response time: 139.21ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 1024, tps: 27443.64, reads: 275370.11, writes: 0.00, response time: 135.15ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 1024, tps: 24788.32, reads: 247103.51, writes: 0.00, response time: 150.07ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 1024, tps: 27251.38, reads: 272953.44, writes: 0.00, response time: 138.55ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 1024, tps: 26281.59, reads: 262531.21, writes: 0.00, response time: 142.80ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 1024, tps: 25841.75, reads: 257786.55, writes: 0.00, response time: 138.71ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 1024, tps: 26712.30, reads: 267702.96, writes: 0.00, response time: 135.67ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 1024, tps: 26250.64, reads: 262426.77, writes: 0.00, response time: 142.63ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 1024, tps: 25522.06, reads: 255379.95, writes: 0.00, response time: 147.71ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 1024, tps: 25483.95, reads: 254770.48, writes: 0.00, response time: 143.48ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 1024, tps: 24037.69, reads: 240575.56, writes: 0.00, response time: 148.73ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 1024, tps: 26264.03, reads: 262276.30, writes: 0.00, response time: 147.18ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 1024, tps: 25371.33, reads: 253877.34, writes: 0.00, response time: 142.88ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 1024, tps: 24631.95, reads: 246329.84, writes: 0.00, response time: 148.86ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 1024, tps: 26761.05, reads: 267939.52, writes: 0.00, response time: 140.72ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 1024, tps: 25784.91, reads: 257515.72, writes: 0.00, response time: 151.02ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 1024, tps: 26079.36, reads: 261065.90, writes: 0.00, response time: 142.67ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 1024, tps: 26366.33, reads: 264111.27, writes: 0.00, response time: 144.39ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 1024, tps: 26406.06, reads: 263343.58, writes: 0.00, response time: 143.27ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 1024, tps: 27594.63, reads: 275902.34, writes: 0.00, response time: 136.04ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 1024, tps: 26451.63, reads: 264502.35, writes: 0.00, response time: 139.84ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 1024, tps: 25823.08, reads: 258624.45, writes: 0.00, response time: 143.18ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 1024, tps: 26784.29, reads: 267339.60, writes: 0.00, response time: 139.79ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 1024, tps: 25284.33, reads: 254082.29, writes: 0.00, response time: 139.21ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 31310760 write: 0 other: 6262152 total: 37572912 transactions: 3131076 (26087.39 per sec.) read/write requests: 31310760 (260873.92 per sec.) other operations: 6262152 (52174.78 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0226s total number of events: 3131076 total time taken by event execution: 122751.6172s response time: min: 0.55ms avg: 39.20ms max: 731.22ms approx. 95 percentile: 141.95ms Threads fairness: events (avg/stddev): 3057.6914/41.13 execution time (avg/stddev): 119.8746/0.10 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: 13535.73, reads: 138124.19, writes: 0.00, response time: 557.48ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 2048, tps: 7735.02, reads: 77672.54, writes: 0.00, response time: 906.73ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 2048, tps: 9909.69, reads: 98810.88, writes: 0.00, response time: 827.12ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 2048, tps: 7692.62, reads: 77046.55, writes: 0.00, response time: 956.64ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 2048, tps: 8471.71, reads: 84596.11, writes: 0.00, response time: 868.22ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 2048, tps: 7290.30, reads: 73021.34, writes: 0.00, response time: 911.63ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 2048, tps: 9085.37, reads: 90926.34, writes: 0.00, response time: 846.91ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 2048, tps: 8918.01, reads: 89053.09, writes: 0.00, response time: 884.75ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 2048, tps: 9246.30, reads: 92607.36, writes: 0.00, response time: 864.59ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 2048, tps: 8088.01, reads: 80607.73, writes: 0.00, response time: 920.13ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 2048, tps: 8938.65, reads: 89748.52, writes: 0.00, response time: 831.34ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 2048, tps: 8702.37, reads: 86783.32, writes: 0.00, response time: 827.62ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 2048, tps: 7451.98, reads: 74651.76, writes: 0.00, response time: 921.79ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 2048, tps: 6631.33, reads: 66734.64, writes: 0.00, response time: 956.93ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 2048, tps: 7327.67, reads: 73013.74, writes: 0.00, response time: 924.55ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 2048, tps: 7456.33, reads: 74217.27, writes: 0.00, response time: 932.33ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 2048, tps: 8339.66, reads: 83329.90, writes: 0.00, response time: 893.26ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 2048, tps: 7467.69, reads: 75181.89, writes: 0.00, response time: 871.34ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 2048, tps: 7777.66, reads: 77485.60, writes: 0.00, response time: 988.08ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 2048, tps: 7449.33, reads: 74047.62, writes: 0.00, response time: 990.74ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 2048, tps: 6907.98, reads: 69558.42, writes: 0.00, response time: 1047.78ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 2048, tps: 7820.71, reads: 78036.44, writes: 0.00, response time: 925.38ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 2048, tps: 7179.99, reads: 72293.86, writes: 0.00, response time: 863.30ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 2048, tps: 7550.33, reads: 75937.63, writes: 0.00, response time: 977.19ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 2048, tps: 8551.97, reads: 84564.01, writes: 0.00, response time: 861.75ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 2048, tps: 7537.37, reads: 75382.00, writes: 0.00, response time: 963.25ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 2048, tps: 7610.68, reads: 76247.82, writes: 0.00, response time: 924.83ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 2048, tps: 7441.31, reads: 74360.43, writes: 0.00, response time: 1000.88ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 2048, tps: 6961.35, reads: 69638.80, writes: 0.00, response time: 943.84ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 2048, tps: 6655.66, reads: 67488.60, writes: 0.00, response time: 980.71ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 2048, tps: 7152.32, reads: 70975.86, writes: 0.00, response time: 955.78ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 2048, tps: 7029.36, reads: 69773.31, writes: 0.00, response time: 969.62ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 2048, tps: 7863.66, reads: 78837.23, writes: 0.00, response time: 878.15ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 2048, tps: 6993.02, reads: 69938.85, writes: 0.00, response time: 950.36ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 2048, tps: 6801.98, reads: 68352.75, writes: 0.00, response time: 1069.97ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 2048, tps: 8003.66, reads: 79542.23, writes: 0.00, response time: 883.42ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 2048, tps: 8783.35, reads: 87921.88, writes: 0.00, response time: 812.40ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 2048, tps: 7087.00, reads: 71515.31, writes: 0.00, response time: 996.09ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 2048, tps: 7822.01, reads: 77621.75, writes: 0.00, response time: 920.13ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 2048, tps: 8136.32, reads: 81318.58, writes: 0.00, response time: 832.59ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 9542660 write: 0 other: 1908532 total: 11451192 transactions: 954266 (7945.84 per sec.) read/write requests: 9542660 (79458.35 per sec.) other operations: 1908532 (15891.67 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0964s total number of events: 954266 total time taken by event execution: 245549.8707s response time: min: 0.44ms avg: 257.32ms max: 3390.72ms approx. 95 percentile: 906.73ms Threads fairness: events (avg/stddev): 465.9502/16.87 execution time (avg/stddev): 119.8974/0.18 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: 469.96, reads: 17395.04, writes: 0.00, response time: 2803.59ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 4096, tps: 617.65, reads: 5250.53, writes: 0.00, response time: 5592.78ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 4096, tps: 944.03, reads: 8507.29, writes: 0.00, response time: 8123.42ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 4096, tps: 489.33, reads: 3971.29, writes: 0.00, response time: 11250.73ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 4096, tps: 639.34, reads: 5220.70, writes: 0.00, response time: 13667.26ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 4096, tps: 445.32, reads: 4436.16, writes: 0.00, response time: 16185.72ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 4096, tps: 752.02, reads: 3871.43, writes: 0.00, response time: 18228.15ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 4096, tps: 461.00, reads: 3318.68, writes: 0.00, response time: 16464.26ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 4096, tps: 165.00, reads: 2404.99, writes: 0.00, response time: 13927.44ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 4096, tps: 322.67, reads: 3564.41, writes: 0.00, response time: 16176.04ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 4096, tps: 323.99, reads: 3871.91, writes: 0.00, response time: 18321.15ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 4096, tps: 255.00, reads: 2780.99, writes: 0.00, response time: 20405.78ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 4096, tps: 324.33, reads: 3436.60, writes: 0.00, response time: 22443.65ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 4096, tps: 560.70, reads: 5760.65, writes: 0.00, response time: 24952.49ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 4096, tps: 358.66, reads: 3612.59, writes: 0.00, response time: 27256.14ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 4096, tps: 374.34, reads: 3792.42, writes: 0.00, response time: 28627.58ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 4096, tps: 295.99, reads: 2999.27, writes: 0.00, response time: 30023.05ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 4096, tps: 58.67, reads: 745.98, writes: 0.00, response time: 36123.98ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 4096, tps: 73.33, reads: 847.69, writes: 0.00, response time: 38375.66ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 4096, tps: 302.99, reads: 2859.27, writes: 0.00, response time: 40138.03ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 4096, tps: 357.33, reads: 3609.35, writes: 0.00, response time: 40066.00ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 4096, tps: 1357.37, reads: 13182.33, writes: 0.00, response time: 41506.51ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 4096, tps: 753.34, reads: 7556.68, writes: 0.00, response time: 30140.11ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 4096, tps: 235.99, reads: 2329.27, writes: 0.00, response time: 33409.14ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 4096, tps: 832.02, reads: 8354.49, writes: 0.00, response time: 25997.05ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 4096, tps: 403.99, reads: 3657.91, writes: 0.00, response time: 29303.85ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 4096, tps: 311.01, reads: 3413.11, writes: 0.00, response time: 30852.11ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 4096, tps: 611.32, reads: 6273.87, writes: 0.00, response time: 23516.56ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 4096, tps: 913.47, reads: 9109.05, writes: 0.00, response time: 23587.06ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 4096, tps: 265.39, reads: 2834.31, writes: 0.00, response time: 23679.02ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 4096, tps: 243.67, reads: 2261.32, writes: 0.00, response time: 27215.38ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 4096, tps: 205.67, reads: 2193.03, writes: 0.00, response time: 29033.18ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 4096, tps: 86.33, reads: 1015.62, writes: 0.00, response time: 33872.35ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 4096, tps: 80.00, reads: 959.69, writes: 0.00, response time: 36988.41ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 4096, tps: 180.00, reads: 1840.36, writes: 0.00, response time: 36767.63ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 4096, tps: 93.67, reads: 1002.00, writes: 0.00, response time: 41705.78ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 4096, tps: 270.66, reads: 2699.62, writes: 0.00, response time: 36999.49ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 4096, tps: 246.67, reads: 2422.07, writes: 0.00, response time: 40779.90ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 4096, tps: 119.00, reads: 1190.63, writes: 0.00, response time: 46063.47ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 4096, tps: 181.00, reads: 1641.35, writes: 0.00, response time: 45054.33ms (95%), errors: 0.00, reconnects: 0.00 [ 123s] threads: 4096, tps: 255.33, reads: 1971.31, writes: 0.00, response time: 47095.21ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 520430 write: 0 other: 104086 total: 624516 transactions: 52043 (417.76 per sec.) read/write requests: 520430 (4177.62 per sec.) other operations: 104086 (835.52 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 124.5757s total number of events: 52043 total time taken by event execution: 506306.2419s response time: min: 0.78ms avg: 9728.61ms max: 76825.77ms approx. 95 percentile: 33529.36ms Threads fairness: events (avg/stddev): 12.7058/3.29 execution time (avg/stddev): 123.6099/1.27 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: 669.89, reads: 16646.50, writes: 0.00, response time: 103.48ms (95%), errors: 0.00, reconnects: 0.00 [ 6s] threads: 8192, tps: 0.00, reads: 1229.00, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 9s] threads: 8192, tps: 0.33, reads: 782.98, writes: 0.00, response time: 6289.09ms (95%), errors: 0.00, reconnects: 0.00 [ 12s] threads: 8192, tps: 0.00, reads: 1816.33, writes: 0.00, response time: 0.00ms (95%), errors: 0.00, reconnects: 0.00 [ 15s] threads: 8192, tps: 0.33, reads: 1590.34, writes: 0.00, response time: 14179.85ms (95%), errors: 0.00, reconnects: 0.00 [ 18s] threads: 8192, tps: 0.33, reads: 774.68, writes: 0.00, response time: 15018.68ms (95%), errors: 0.00, reconnects: 0.00 [ 21s] threads: 8192, tps: 1.00, reads: 1124.34, writes: 0.00, response time: 20694.89ms (95%), errors: 0.00, reconnects: 0.00 [ 24s] threads: 8192, tps: 21.67, reads: 1011.03, writes: 0.00, response time: 23906.93ms (95%), errors: 0.00, reconnects: 0.00 [ 27s] threads: 8192, tps: 124.67, reads: 1296.99, writes: 0.00, response time: 26843.20ms (95%), errors: 0.00, reconnects: 0.00 [ 30s] threads: 8192, tps: 170.66, reads: 1104.64, writes: 0.00, response time: 29647.95ms (95%), errors: 0.00, reconnects: 0.00 [ 33s] threads: 8192, tps: 91.33, reads: 1045.98, writes: 0.00, response time: 32433.60ms (95%), errors: 0.00, reconnects: 0.00 [ 36s] threads: 8192, tps: 115.67, reads: 1239.71, writes: 0.00, response time: 35661.99ms (95%), errors: 0.00, reconnects: 0.00 [ 39s] threads: 8192, tps: 113.33, reads: 1006.64, writes: 0.00, response time: 38594.54ms (95%), errors: 0.00, reconnects: 0.00 [ 42s] threads: 8192, tps: 45.00, reads: 206.01, writes: 0.00, response time: 41931.10ms (95%), errors: 0.00, reconnects: 0.00 [ 45s] threads: 8192, tps: 145.99, reads: 761.97, writes: 0.00, response time: 43647.20ms (95%), errors: 0.00, reconnects: 0.00 [ 48s] threads: 8192, tps: 205.68, reads: 1196.75, writes: 0.00, response time: 47307.15ms (95%), errors: 0.00, reconnects: 0.00 [ 51s] threads: 8192, tps: 166.32, reads: 529.63, writes: 0.00, response time: 50800.39ms (95%), errors: 0.00, reconnects: 0.00 [ 54s] threads: 8192, tps: 209.34, reads: 571.35, writes: 0.00, response time: 53069.78ms (95%), errors: 0.00, reconnects: 0.00 [ 57s] threads: 8192, tps: 133.67, reads: 929.66, writes: 0.00, response time: 56784.20ms (95%), errors: 0.00, reconnects: 0.00 [ 60s] threads: 8192, tps: 256.01, reads: 844.35, writes: 0.00, response time: 59784.38ms (95%), errors: 0.00, reconnects: 0.00 [ 63s] threads: 8192, tps: 53.00, reads: 716.65, writes: 0.00, response time: 61656.36ms (95%), errors: 0.00, reconnects: 0.00 [ 66s] threads: 8192, tps: 31.33, reads: 137.00, writes: 0.00, response time: 65128.06ms (95%), errors: 0.00, reconnects: 0.00 [ 69s] threads: 8192, tps: 188.00, reads: 1664.66, writes: 0.00, response time: 68384.61ms (95%), errors: 0.00, reconnects: 0.00 [ 72s] threads: 8192, tps: 41.00, reads: 1991.36, writes: 0.00, response time: 71268.65ms (95%), errors: 0.00, reconnects: 0.00 [ 75s] threads: 8192, tps: 198.00, reads: 776.66, writes: 0.00, response time: 74720.32ms (95%), errors: 0.00, reconnects: 0.00 [ 78s] threads: 8192, tps: 325.68, reads: 402.69, writes: 0.00, response time: 77545.91ms (95%), errors: 0.00, reconnects: 0.00 [ 81s] threads: 8192, tps: 266.32, reads: 198.66, writes: 0.00, response time: 80598.89ms (95%), errors: 0.00, reconnects: 0.00 [ 84s] threads: 8192, tps: 117.00, reads: 1332.66, writes: 0.00, response time: 83172.39ms (95%), errors: 0.00, reconnects: 0.00 [ 87s] threads: 8192, tps: 187.34, reads: 610.01, writes: 0.00, response time: 85930.90ms (95%), errors: 0.00, reconnects: 0.00 [ 90s] threads: 8192, tps: 201.66, reads: 2405.28, writes: 0.00, response time: 87409.66ms (95%), errors: 0.00, reconnects: 0.00 [ 93s] threads: 8192, tps: 179.67, reads: 2016.01, writes: 0.00, response time: 91341.81ms (95%), errors: 0.00, reconnects: 0.00 [ 96s] threads: 8192, tps: 85.67, reads: 1068.04, writes: 0.00, response time: 94230.12ms (95%), errors: 0.00, reconnects: 0.00 [ 99s] threads: 8192, tps: 80.33, reads: 1030.29, writes: 0.00, response time: 97122.50ms (95%), errors: 0.00, reconnects: 0.00 [ 102s] threads: 8192, tps: 12.00, reads: 358.34, writes: 0.00, response time: 101127.68ms (95%), errors: 0.00, reconnects: 0.00 [ 105s] threads: 8192, tps: 6.67, reads: 214.00, writes: 0.00, response time: 103671.68ms (95%), errors: 0.00, reconnects: 0.00 [ 108s] threads: 8192, tps: 145.00, reads: 2806.66, writes: 0.00, response time: 105930.31ms (95%), errors: 0.00, reconnects: 0.00 [ 111s] threads: 8192, tps: 53.00, reads: 1501.33, writes: 0.00, response time: 109509.15ms (95%), errors: 0.00, reconnects: 0.00 [ 114s] threads: 8192, tps: 278.67, reads: 852.02, writes: 0.00, response time: 112331.23ms (95%), errors: 0.00, reconnects: 0.00 [ 117s] threads: 8192, tps: 176.66, reads: 1570.64, writes: 0.00, response time: 114503.98ms (95%), errors: 0.00, reconnects: 0.00 [ 120s] threads: 8192, tps: 21.67, reads: 268.01, writes: 0.00, response time: 117595.50ms (95%), errors: 0.00, reconnects: 0.00 [ 123s] threads: 8192, tps: 890.31, reads: 7186.48, writes: 0.00, response time: 120193.45ms (95%), errors: 0.00, reconnects: 0.00 OLTP test statistics: queries performed: read: 235520 write: 0 other: 47104 total: 282624 transactions: 23552 (188.42 per sec.) read/write requests: 235520 (1884.15 per sec.) other operations: 47104 (376.83 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 125.0006s total number of events: 23552 total time taken by event execution: 1009085.9972s response time: min: 0.86ms avg: 42845.02ms max: 124954.91ms approx. 95 percentile: 89207.12ms Threads fairness: events (avg/stddev): 2.8750/1.22 execution time (avg/stddev): 123.1794/1.56