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: 45388 write: 16210 other: 6484 total: 68082 transactions: 3242 (52.66 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 61598 (1000.51 per sec.) other operations: 6484 (105.32 per sec.) Test execution summary: total time: 61.5667s total number of events: 3242 total time taken by event execution: 6083.5623 per-request statistics: min: 7.49ms avg: 1876.48ms max: 6830.30ms approx. 95 percentile: 3766.13ms Threads fairness: events (avg/stddev): 32.4200/3.34 execution time (avg/stddev): 60.8356/0.50 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: 34160 write: 12200 other: 4880 total: 51240 transactions: 2440 (39.14 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 46360 (743.57 per sec.) other operations: 4880 (78.27 per sec.) Test execution summary: total time: 62.3479s total number of events: 2440 total time taken by event execution: 6128.4552 per-request statistics: min: 7.80ms avg: 2511.66ms max: 8257.84ms approx. 95 percentile: 5039.50ms Threads fairness: events (avg/stddev): 24.4000/2.50 execution time (avg/stddev): 61.2846/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: 32410 write: 11575 other: 4630 total: 48615 transactions: 2315 (37.11 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 43985 (705.04 per sec.) other operations: 4630 (74.21 per sec.) Test execution summary: total time: 62.3864s total number of events: 2315 total time taken by event execution: 6115.3364 per-request statistics: min: 7.85ms avg: 2641.61ms max: 8678.19ms approx. 95 percentile: 5143.13ms Threads fairness: events (avg/stddev): 23.1500/2.46 execution time (avg/stddev): 61.1534/0.63 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: 39914 write: 14255 other: 5702 total: 59871 transactions: 2851 (46.09 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 54169 (875.79 per sec.) other operations: 5702 (92.19 per sec.) Test execution summary: total time: 61.8517s total number of events: 2851 total time taken by event execution: 6100.6959 per-request statistics: min: 7.71ms avg: 2139.84ms max: 7209.59ms approx. 95 percentile: 4396.49ms Threads fairness: events (avg/stddev): 28.5100/3.06 execution time (avg/stddev): 61.0070/0.54 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: 31038 write: 11085 other: 4434 total: 46557 transactions: 2217 (35.27 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 42123 (670.10 per sec.) other operations: 4434 (70.54 per sec.) Test execution summary: total time: 62.8603s total number of events: 2217 total time taken by event execution: 6163.5967 per-request statistics: min: 7.98ms avg: 2780.15ms max: 10283.86ms approx. 95 percentile: 5611.22ms Threads fairness: events (avg/stddev): 22.1700/2.49 execution time (avg/stddev): 61.6360/0.81 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: 40852 write: 14590 other: 5836 total: 61278 transactions: 2918 (46.37 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 55442 (880.95 per sec.) other operations: 5836 (92.73 per sec.) Test execution summary: total time: 62.9343s total number of events: 2918 total time taken by event execution: 6150.3659 per-request statistics: min: 7.31ms avg: 2107.73ms max: 6518.51ms approx. 95 percentile: 4245.18ms Threads fairness: events (avg/stddev): 29.1800/3.56 execution time (avg/stddev): 61.5037/0.93 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: 33110 write: 11825 other: 4730 total: 49665 transactions: 2365 (37.94 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 44935 (720.95 per sec.) other operations: 4730 (75.89 per sec.) Test execution summary: total time: 62.3273s total number of events: 2365 total time taken by event execution: 6114.7018 per-request statistics: min: 8.07ms avg: 2585.50ms max: 8101.24ms approx. 95 percentile: 5236.33ms Threads fairness: events (avg/stddev): 23.6500/2.52 execution time (avg/stddev): 61.1470/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: 38402 write: 13715 other: 5486 total: 57603 transactions: 2743 (44.34 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 52117 (842.49 per sec.) other operations: 5486 (88.68 per sec.) Test execution summary: total time: 61.8605s total number of events: 2743 total time taken by event execution: 6098.1257 per-request statistics: min: 7.08ms avg: 2223.16ms max: 8942.22ms approx. 95 percentile: 4692.96ms Threads fairness: events (avg/stddev): 27.4300/2.98 execution time (avg/stddev): 60.9813/0.58 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: 34916 write: 12470 other: 4988 total: 52374 transactions: 2494 (39.79 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 47386 (755.96 per sec.) other operations: 4988 (79.57 per sec.) Test execution summary: total time: 62.6831s total number of events: 2494 total time taken by event execution: 6135.0613 per-request statistics: min: 7.40ms avg: 2459.93ms max: 9050.84ms approx. 95 percentile: 5022.93ms Threads fairness: events (avg/stddev): 24.9400/2.93 execution time (avg/stddev): 61.3506/0.75 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: 33796 write: 12070 other: 4828 total: 50694 transactions: 2414 (38.96 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 45866 (740.17 per sec.) other operations: 4828 (77.91 per sec.) Test execution summary: total time: 61.9666s total number of events: 2414 total time taken by event execution: 6106.4913 per-request statistics: min: 8.06ms avg: 2529.62ms max: 10207.07ms approx. 95 percentile: 5065.21ms Threads fairness: events (avg/stddev): 24.1400/2.53 execution time (avg/stddev): 61.0649/0.56