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
请使用浏览器的分享功能分享到微信等