mysql slap_压测：mysqlslap

[root@VMUest ~]# mysqlslap -a -h192.168.85.129 -umydba -pmysql5635 -P3306 --concurrency=50,100 --number-of-queries 1000 --iterations=5 --engine=myisam,innodb --debug-infoWarning: Using a password on the command line interface can be insecure.

Benchmark

Runningforengine myisam

Average number of seconds to run all queries:0.432seconds

Minimum number of seconds to run all queries:0.382seconds

Maximum number of seconds to run all queries:0.532seconds

Number of clients running queries:50Average number of queries per client:20Benchmark

Runningforengine myisam

Average number of seconds to run all queries:0.512seconds

Minimum number of seconds to run all queries:0.414seconds

Maximum number of seconds to run all queries:0.710seconds

Number of clients running queries:100Average number of queries per client:10Benchmark

Runningforengine innodb

Average number of seconds to run all queries:0.898seconds

Minimum number of seconds to run all queries:0.606seconds

Maximum number of seconds to run all queries:1.520seconds

Number of clients running queries:50Average number of queries per client:20Benchmark

Runningforengine innodb

Average number of seconds to run all queries:0.744seconds

Minimum number of seconds to run all queries:0.606seconds

Maximum number of seconds to run all queries:0.954seconds

Number of clients running queries:100Average number of queries per client:10Usertime 1.47, System time 2.65Maximum resident set size11060, Integral resident set size 0Non-physical pagefaults 26225, Physical pagefaults 0, Swaps 0Blocksin 0 out 0, Messages in 0 out 0, Signals 0Voluntary context switches40290, Involuntary context switches 5719