Mysql query stress testing program We are writing queries for our website, and when we test the queries in a dev environment, the queries run pretty fast. The problem that we are having is the dev environment has less that 10 active users on it, while our live environment has 4,000+ simultaneous users and then our server just cant handle the queries.

So, is there a tool out there that can take some queries and do some stress testing on them, so we can test the queries before we put them live and kill the server?
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 !!!