I have to different Linux servers, and wanted to test if one where faster than the other. I used mysqlslap together with the “time” command in a bash shell.
# time mysqlslap –user=root –password=
cat /root/mysql –host=localhost concurrency=50 –iterations=100 –number-int-cols=5 –number-char-cols=20 –auto-generate-sql –verbose
In this way I could get out different values from the server which I could compare.
Average number of seconds to run all queries: 0.007 seconds
Minimum number of seconds to run all queries: 0.006 seconds
Maximum number of seconds to run all queries: 0.024 seconds
Number of clients running queries: 1
Average number of queries per client: 0