Sql query performance test
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.
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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"...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
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
Premium Content
You need an Expert Office subscription to comment.Start Free Trial