Oct 30, 2017

Stress test MySQL with mysqlslap

Quick start, just run:
$ 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=8
To 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