sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 32774 write: 11705 other: 4682 total: 49161 transactions: 2341 (37.67 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 44479 (715.78 per sec.) other operations: 4682 (75.35 per sec.) Test execution summary: total time: 62.1408s total number of events: 2341 total time taken by event execution: 6110.1103 per-request statistics: min: 8.61ms avg: 2610.04ms max: 9359.42ms approx. 95 percentile: 5161.63ms Threads fairness: events (avg/stddev): 23.4100/2.44 execution time (avg/stddev): 61.1011/0.64 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 43456 write: 15520 other: 6208 total: 65184 transactions: 3104 (49.52 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 58976 (940.79 per sec.) other operations: 6208 (99.03 per sec.) Test execution summary: total time: 62.6877s total number of events: 3104 total time taken by event execution: 6141.0546 per-request statistics: min: 8.01ms avg: 1978.43ms max: 7815.15ms approx. 95 percentile: 3965.12ms Threads fairness: events (avg/stddev): 31.0400/3.13 execution time (avg/stddev): 61.4105/0.79 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 31836 write: 11370 other: 4548 total: 47754 transactions: 2274 (36.19 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 43206 (687.62 per sec.) other operations: 4548 (72.38 per sec.) Test execution summary: total time: 62.8346s total number of events: 2274 total time taken by event execution: 6148.9806 per-request statistics: min: 8.30ms avg: 2704.04ms max: 9686.37ms approx. 95 percentile: 5405.14ms Threads fairness: events (avg/stddev): 22.7400/2.97 execution time (avg/stddev): 61.4898/0.89 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 38318 write: 13685 other: 5474 total: 57477 transactions: 2737 (44.46 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 52003 (844.65 per sec.) other operations: 5474 (88.91 per sec.) Test execution summary: total time: 61.5678s total number of events: 2737 total time taken by event execution: 6090.2863 per-request statistics: min: 7.63ms avg: 2225.17ms max: 9545.56ms approx. 95 percentile: 4577.80ms Threads fairness: events (avg/stddev): 27.3700/3.13 execution time (avg/stddev): 60.9029/0.46 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 35602 write: 12715 other: 5086 total: 53403 transactions: 2543 (40.85 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 48317 (776.20 per sec.) other operations: 5086 (81.70 per sec.) Test execution summary: total time: 62.2484s total number of events: 2543 total time taken by event execution: 6124.2542 per-request statistics: min: 8.31ms avg: 2408.28ms max: 9202.83ms approx. 95 percentile: 4942.39ms Threads fairness: events (avg/stddev): 25.4300/2.93 execution time (avg/stddev): 61.2425/0.68 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 33936 write: 12120 other: 4848 total: 50904 transactions: 2424 (39.29 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 46056 (746.51 per sec.) other operations: 4848 (78.58 per sec.) Test execution summary: total time: 61.6951s total number of events: 2424 total time taken by event execution: 6093.6095 per-request statistics: min: 8.05ms avg: 2513.87ms max: 9945.71ms approx. 95 percentile: 5095.62ms Threads fairness: events (avg/stddev): 24.2400/2.23 execution time (avg/stddev): 60.9361/0.51 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 38724 write: 13830 other: 5532 total: 58086 transactions: 2766 (44.25 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 52554 (840.84 per sec.) other operations: 5532 (88.51 per sec.) Test execution summary: total time: 62.5020s total number of events: 2766 total time taken by event execution: 6135.1641 per-request statistics: min: 8.00ms avg: 2218.06ms max: 8574.81ms approx. 95 percentile: 4627.40ms Threads fairness: events (avg/stddev): 27.6600/2.65 execution time (avg/stddev): 61.3516/0.74 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 32844 write: 11730 other: 4692 total: 49266 transactions: 2346 (37.26 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 44574 (707.91 per sec.) other operations: 4692 (74.52 per sec.) Test execution summary: total time: 62.9657s total number of events: 2346 total time taken by event execution: 6132.2605 per-request statistics: min: 8.62ms avg: 2613.92ms max: 8684.94ms approx. 95 percentile: 5150.83ms Threads fairness: events (avg/stddev): 23.4600/2.58 execution time (avg/stddev): 61.3226/0.73 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 41902 write: 14965 other: 5986 total: 62853 transactions: 2993 (48.29 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 56867 (917.47 per sec.) other operations: 5986 (96.58 per sec.) Test execution summary: total time: 61.9824s total number of events: 2993 total time taken by event execution: 6113.5912 per-request statistics: min: 8.38ms avg: 2042.63ms max: 7505.06ms approx. 95 percentile: 4313.07ms Threads fairness: events (avg/stddev): 29.9300/2.80 execution time (avg/stddev): 61.1359/0.59 sysbench 0.4.10: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 99 times) Running the test with following options: Number of threads: 100 Doing OLTP test. Running mixed OLTP test Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) Using "BEGIN" for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exiting... (last message repeated 99 times) Done. OLTP test statistics: queries performed: read: 32662 write: 11665 other: 4666 total: 48993 transactions: 2333 (37.14 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 44327 (705.64 per sec.) other operations: 4666 (74.28 per sec.) Test execution summary: total time: 62.8184s total number of events: 2333 total time taken by event execution: 6149.8724 per-request statistics: min: 8.54ms avg: 2636.04ms max: 8498.31ms approx. 95 percentile: 5191.07ms Threads fairness: events (avg/stddev): 23.3300/2.74 execution time (avg/stddev): 61.4987/0.77