Mysql query stress testing program
As was pointed out in the comments, you could go with mysqlslap.

If you are a little more adventurous, you may want to setup you own by deliberately dummying down the MySQL configurations or just collecting query profiles. Here are some of my posts and some of the others that address doing stress testing and query profiling. I hope the ideas help.


Apr 04, 2013 : Stress test MySQL with queries captured with general log in MySQL


Accepted Answer
My Answer

Mar 10, 2013 : Stress Test to Saturate Memory for MySQL InnoDB


Accepted Answer
My Answer

Jun 08, 2012 : How to improve MySQL Server Performance..??
Dec 28, 2011 : Is there a tool like Microsoft&#39;s &quot;SQL Server Profiler&quot; for MySQL?
Jul 09, 2011 : Testing Query Speed (My Answer was MySQL-specific)


Give it a Try !!!