Sql query performance test

AWSnewbie
AWSnewbie used Ask the Experts™
on
Hello
I'm looking for a performance tool to test single sql query which will run hundreds of times with in 15 minutes in DB .

I have found Sqlquerystress tool by googling. I'm Looking for any other  great tools  which suffice my requirements.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer
Commented:
Doesn't sound like that much stresss. Hundreds of times in 15 minutes means 1 query per second..
Database Analyst
Commented:
"...to test single sql query which will run hundreds of times..." - what are you looking for in particular?
How to execute a single SQL query hundreds of times and monitor MySQL performance/issues during that execution?

Put the query in a script, in a loop that runs x,000 times.
But that's not a very good benchmark of anything. If you're trying to simulate real load, you will need to have some concurrent activity, not just x,000,000 queries issued and returned one at a time.

I use mysqlslap since about 5.1 and can't complain I'm missing anything.

http://www.techrepublic.com/blog/how-do-i/how-do-i-stress-test-mysql-with-mysqlslap/
https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap

Author

Commented:
Thanks for the replies. I'm going with Sqlquerystress tool.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial