root@serv002:~# sysbench --num-threads=10 --test=oltp --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=qq --oltp-table-size=500000 --mysql-table-engine=myisam prepare
sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Creating table 'sbtest'...
Creating 500000 records in table 'sbtest'...
root@serv002:~# sysbench --num-threads=10 --test=oltp --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=qq --oltp-table-size=500000 --mysql-table-engine=myisam run
sysbench 0.4.12: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
Running the test with following options:
Number of threads: 10
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "LOCK TABLES WRITE" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (256.44 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (4872.45 per sec.)
other operations: 20000 (512.89 per sec.)
Test execution summary:
total time: 38.9947s
total number of events: 10000
total time taken by event execution: 389.5782
per-request statistics:
min: 3.11ms
avg: 38.96ms
max: 62.12ms
approx. 95 percentile: 47.87ms
Threads fairness:
events (avg/stddev): 1000.0000/0.00
execution time (avg/stddev): 38.9578/0.01
root@serv002:~#