Simulate heavy usage
mysql, php
Solution
Look at `mysqlslap`. It is a load emulator that lets you see how well a particular query set or table engine performs under high-load conditions.
More information here: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html
Edit: I just noticed this tool is only available for MySQL > 5.1.4. I don't know what version you are currently using.
Problem
I'm making a online game (with hopefully thousands of players each hour) which uses quite a few queries to the mysql database. Before release, It would be nice if I could simulate heavy usage to see the performance. Is there anyway to do this? Thanks in advance