Mysql / Mariadb performance test

(Last Updated On: 26 June, 2017)

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.

Benchmark
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

real 0m9.390s
user 0m0.085s
sys 0m0.165s

Referance: https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap

 

Leave a Reply

Your email address will not be published. Required fields are marked *