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: 35616 write: 12720 other: 5088 total: 53424 transactions: 2544 (40.82 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 48336 (775.63 per sec.) other operations: 5088 (81.65 per sec.) Test execution summary: total time: 62.3185s total number of events: 2544 total time taken by event execution: 6124.1530 per-request statistics: min: 7.60ms avg: 2407.29ms max: 9326.92ms approx. 95 percentile: 5138.51ms Threads fairness: events (avg/stddev): 25.4400/2.62 execution time (avg/stddev): 61.2415/0.67 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: 29344 write: 10480 other: 4192 total: 44016 transactions: 2096 (33.75 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 39824 (641.31 per sec.) other operations: 4192 (67.51 per sec.) Test execution summary: total time: 62.0982s total number of events: 2096 total time taken by event execution: 6103.1231 per-request statistics: min: 8.32ms avg: 2911.80ms max: 12112.38ms approx. 95 percentile: 6056.31ms Threads fairness: events (avg/stddev): 20.9600/2.47 execution time (avg/stddev): 61.0312/0.57 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: 38430 write: 13725 other: 5490 total: 57645 transactions: 2745 (43.51 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 52155 (826.60 per sec.) other operations: 5490 (87.01 per sec.) Test execution summary: total time: 63.0957s total number of events: 2745 total time taken by event execution: 6159.5329 per-request statistics: min: 7.43ms avg: 2243.91ms max: 10092.83ms approx. 95 percentile: 5031.96ms Threads fairness: events (avg/stddev): 27.4500/2.84 execution time (avg/stddev): 61.5953/0.88 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: 23632 write: 8440 other: 3376 total: 35448 transactions: 1688 (26.61 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 32072 (505.68 per sec.) other operations: 3376 (53.23 per sec.) Test execution summary: total time: 63.4229s total number of events: 1688 total time taken by event execution: 6156.7349 per-request statistics: min: 8.69ms avg: 3647.35ms max: 13627.01ms approx. 95 percentile: 7752.81ms Threads fairness: events (avg/stddev): 16.8800/2.49 execution time (avg/stddev): 61.5673/0.96 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: 40614 write: 14505 other: 5802 total: 60921 transactions: 2901 (47.21 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 55119 (896.91 per sec.) other operations: 5802 (94.41 per sec.) Test execution summary: total time: 61.4543s total number of events: 2901 total time taken by event execution: 6087.8759 per-request statistics: min: 7.65ms avg: 2098.54ms max: 7256.23ms approx. 95 percentile: 4229.96ms Threads fairness: events (avg/stddev): 29.0100/2.51 execution time (avg/stddev): 60.8788/0.43 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: 26754 write: 9555 other: 3822 total: 40131 transactions: 1911 (29.87 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 36309 (567.56 per sec.) other operations: 3822 (59.74 per sec.) Test execution summary: total time: 63.9739s total number of events: 1911 total time taken by event execution: 6243.7552 per-request statistics: min: 7.73ms avg: 3267.27ms max: 12888.52ms approx. 95 percentile: 8189.34ms Threads fairness: events (avg/stddev): 19.1100/2.41 execution time (avg/stddev): 62.4376/1.07 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: 27468 write: 9810 other: 3924 total: 41202 transactions: 1962 (31.28 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 37278 (594.32 per sec.) other operations: 3924 (62.56 per sec.) Test execution summary: total time: 62.7236s total number of events: 1962 total time taken by event execution: 6127.1770 per-request statistics: min: 8.18ms avg: 3122.92ms max: 11872.83ms approx. 95 percentile: 7080.57ms Threads fairness: events (avg/stddev): 19.6200/2.39 execution time (avg/stddev): 61.2718/0.70 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: 41440 write: 14800 other: 5920 total: 62160 transactions: 2960 (46.35 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 56240 (880.71 per sec.) other operations: 5920 (92.71 per sec.) Test execution summary: total time: 63.8578s total number of events: 2960 total time taken by event execution: 6203.0922 per-request statistics: min: 7.55ms avg: 2095.64ms max: 10620.27ms approx. 95 percentile: 4474.83ms Threads fairness: events (avg/stddev): 29.6000/2.90 execution time (avg/stddev): 62.0309/1.15 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: 26516 write: 9470 other: 3788 total: 39774 transactions: 1894 (29.78 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 35986 (565.90 per sec.) other operations: 3788 (59.57 per sec.) Test execution summary: total time: 63.5904s total number of events: 1894 total time taken by event execution: 6182.2867 per-request statistics: min: 8.17ms avg: 3264.14ms max: 11913.93ms approx. 95 percentile: 6904.76ms Threads fairness: events (avg/stddev): 18.9400/2.38 execution time (avg/stddev): 61.8229/0.97 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: 37030 write: 13225 other: 5290 total: 55545 transactions: 2645 (42.81 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 50255 (813.32 per sec.) other operations: 5290 (85.61 per sec.) Test execution summary: total time: 61.7899s total number of events: 2645 total time taken by event execution: 6100.2766 per-request statistics: min: 8.58ms avg: 2306.34ms max: 9959.79ms approx. 95 percentile: 4880.64ms Threads fairness: events (avg/stddev): 26.4500/2.78 execution time (avg/stddev): 61.0028/0.53