- 论坛徽章:
- 0
|
sysbench --num-threads=100 --test=oltp 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 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
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 147854
write: 51211
other: 20561
total: 219626
transactions: 10000 (206.67 per sec.)
deadlocks: 561 (11.59 per sec.)
read/write requests: 199065 (4114.09 per sec.)
other operations: 20561 (424.94 per sec.)
Test execution summary:
total time: 48.3862s
total number of events: 10000
total time taken by event execution: 4831.1306
per-request statistics:
min: 0.0180s
avg: 0.4831s
max: 2.9758s
approx. 95 percentile: 1.0497s
Threads fairness:
events (avg/stddev): 100.0000/5.95
execution time (avg/stddev): 48.3113/0.05
报告中的内容还不是完全会看。算是一次尝试。
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/25477/showart_221435.html |
|