database0:~ # 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! WARNING: Operation time (0.000000) is less than minimal counted value, counting as 1.000000 WARNING: Percentile statistics will be inaccurate Done. OLTP test statistics: queries performed: read: 1400000 write: 0 other: 200000 total: 1600000 transactions: 100000 (1069.59 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 1400000 (14974.23 per sec.) other operations: 200000 (2139.18 per sec.) Test execution summary: total time: 93.4940s total number of events: 100000 total time taken by event execution: 186.0497 per-request statistics: min: 0.0000s avg: 0.0019s max: 0.1263s approx. 95 percentile: 0.0021s Threads fairness: events (avg/stddev): 50000.0000/912.00 execution time (avg/stddev): 93.0249/0.01 database0:~ #