I did a study on the benchmarking tools available for mysql. I found mysqlslap to be the ideal tool for this. You can install mysqlslap by using the following command
$home> sudo apt-get install mysqlslap.
Once install you can use mysqlslap --help to get the argument list and synopsis for how to use it.
you can use number of iteration and concurrency limit for benchmarking performance of mysql.
for example:
mysqlslap -uroot -p -q Desktop/emp.sql -i15000
in this case the sql query written in the file emp.sql will run for 15000 times.
One important note is that mysqlslap only work if all of your tables,views,proc used in the query are under mysqlslap database.
