sles101:~ # sysbench --num-threads=2 --max-requests=100000 --test=oltp --oltp-read-only --mysql-host=localhost --mysql-user=mysql --mysql-db=test --myisam-max-rows=10000000 run sysbench v0.4.8: multi-threaded system evaluation benchmark No DB drivers specified, using mysql WARNING: Preparing of "BEGIN" is unsupported, using emulation (last message repeated 1 times) Running the test with following options: Number of threads: 2 Doing OLTP test. Running mixed OLTP test Doing read-only 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 Maximum number of requests for OLTP test is limited to 100000 Threads started! Done. OLTP test statistics: queries performed: read: 1400000 write: 0 other: 200000 total: 1600000 transactions: 100000 (412.11 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 1400000 (5769.59 per sec.) other operations: 200000 (824.23 per sec.) Test execution summary: total time: 242.6517s total number of events: 100000 total time taken by event execution: 484.4927 per-request statistics: min: 0.0022s avg: 0.0048s max: 2.1658s approx. 95 percentile: 0.0027s Threads fairness: events (avg/stddev): 50000.0000/2984.00 execution time (avg/stddev): 242.2463/0.03 sles101:~ #