Use Maatkit's query profiler to measure impact of data amount on MySQL performances, or generatedata.com to generate the data you need to test your app.

You can test your application responsiveness using HTTP testing
tools like :

• Apache's bundled 'ab' tool (Apache Bench)

• JMeter

• Selenium