freebsd 7.0 amd64
mysqlslap -a --concurrency=5,10,20,50,150 --number-of-queries 100000 --debug-info
Benchmark
Average number of seconds to run all queries: 766.733 seconds
Minimum number of seconds to run all queries: 766.733 seconds
Maximum number of seconds to run all queries: 766.733 seconds
Number of clients running queries: 5
Average number of queries per client: 20000
Benchmark
Average number of seconds to run all queries: 820.050 seconds
Minimum number of seconds to run all queries: 820.050 seconds
Maximum number of seconds to run all queries: 820.050 seconds
Number of clients running queries: 10
Average number of queries per client: 10000
Benchmark
Average number of seconds to run all queries: 884.095 seconds
Minimum number of seconds to run all queries: 884.095 seconds
Maximum number of seconds to run all queries: 884.095 seconds
Number of clients running queries: 20
Average number of queries per client: 5000
Benchmark
Average number of seconds to run all queries: 694.475 seconds
Minimum number of seconds to run all queries: 694.475 seconds
Maximum number of seconds to run all queries: 694.475 seconds
Number of clients running queries: 50
Average number of queries per client: 2000
Benchmark
Average number of seconds to run all queries: 598.458 seconds
Minimum number of seconds to run all queries: 598.458 seconds
Maximum number of seconds to run all queries: 598.458 seconds
Number of clients running queries: 150
Average number of queries per client: 666
User time 3902.23, System time 9027.33
Maximum resident set size 1097740, Integral resident set size 13645752
Non-physical pagefaults 173927169, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 500888 out 106847448, Signals 0
Voluntary context switches 309713247, Involuntary context switches 63286046
不知道这个结果是好还是坏,第一次做mysql 压力测试