Stress test MySQL with mysqlslap
Quick start, just run:
You can force mysqlslap to run a particular test more than once by adding the –iterations switch to the command line.
./mysqlslap --auto-generate-sql --concurrency=1000 --number-of-queries=3888 --iterations=8 | tee /tmp/mysqlslap.`date +%F`.csv
Benchmark
Average number of seconds to run all queries: 0.857 seconds
Minimum number of seconds to run all queries: 0.750 seconds
Maximum number of seconds to run all queries: 0.900 seconds
Number of clients running queries: 1000
Average number of queries per client: 3
$ mysqlslap --auto-generate-sql --concurrency=200 --number-of-queries=1000
You can see verbose output by adding the -v switch to the mysqlslap command line (adding extra ‘v’s increases the verbosity level)
You can force mysqlslap to run a particular test more than once by adding the –iterations switch to the command line.
--iterations=8To save the report for future comparison:
./mysqlslap --auto-generate-sql --concurrency=1000 --number-of-queries=3888 --iterations=8 | tee /tmp/mysqlslap.`date +%F`.csv
Benchmark
Average number of seconds to run all queries: 0.857 seconds
Minimum number of seconds to run all queries: 0.750 seconds
Maximum number of seconds to run all queries: 0.900 seconds
Number of clients running queries: 1000
Average number of queries per client: 3
Comments
Post a Comment