Mysql压力测试mysqlslap

Mysql自带压力测试工具研究

#测试机  4cpus 4GMemsize
测试结果
# mysqlslap --concurrency=1000 --iterations=10  -a --socket=/tmp/mysql.sock -uroot -p
Enter password: 
Benchmark
        Average number of seconds to run all queries: 6.616 seconds
        Minimum number of seconds to run all queries: 6.329 seconds
        Maximum number of seconds to run all queries: 6.840 seconds
        Number of clients running queries: 1000
        Average number of queries per client: 0


服务器负载
load average: 94.39, 86.30, 36.61        


mysqlslap --concurrency=100 --iterations=10  -a  -uroot
mysqlslap --concurrency=100 --iterations=10  -a  -uroot