mysqlslap测试

其实我今天也是第一次用，还没有很深入的了解这个工具的原理。
不过就下述而言，总体并发5，50，150是不错的，10，20比较差。
dba-test-A1-104:/usr/local # mysqlslap -a --concurrency=5,10,20,50,150 --number-of-queries 100000 --debug-info
Benchmark
        Average number of seconds to run all queries: 1053.520 seconds
        Minimum number of seconds to run all queries: 1053.520 seconds
        Maximum number of seconds to run all queries: 1053.520 seconds
        Number of clients running queries: 5
        Average number of queries per client: 20000

Benchmark
        Average number of seconds to run all queries: 1354.247 seconds
        Minimum number of seconds to run all queries: 1354.247 seconds
        Maximum number of seconds to run all queries: 1354.247 seconds
        Number of clients running queries: 10
        Average number of queries per client: 10000

Benchmark
        Average number of seconds to run all queries: 1221.182 seconds
        Minimum number of seconds to run all queries: 1221.182 seconds
        Maximum number of seconds to run all queries: 1221.182 seconds
        Number of clients running queries: 20
        Average number of queries per client: 5000

Benchmark
        Average number of seconds to run all queries: 1016.130 seconds
        Minimum number of seconds to run all queries: 1016.130 seconds
        Maximum number of seconds to run all queries: 1016.130 seconds
        Number of clients running queries: 50
        Average number of queries per client: 2000

Benchmark
        Average number of seconds to run all queries: 1012.727 seconds
        Minimum number of seconds to run all queries: 1012.727 seconds
        Maximum number of seconds to run all queries: 1012.727 seconds
        Number of clients running queries: 150
        Average number of queries per client: 666


User time 2473.98, System time 1242.23
Maximum resident set size 0, Integral resident set size 0
Non-physical pagefaults 156527636, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 106583066, Involuntary context switches 3655760

老外这篇文章挺好的
http://blogs.techrepublic.com.com/howdoi/?p=133

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/82392/viewspace-410225/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/82392/viewspace-410225/