In addition to the great advice you have already been given you may want to look at The MySQL Benchmark Suite and BENCHMARK, both, oddly enough, from the MySQL documentation. Why not construct your own benchmarking tests catered for your environment, which you have not supplied a great deal of information about? From a Perl perspective there is Benchmarking Your Code from the Tutorials section of this site.

Hope this helps

Martin