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