How do you repeat a raw SQL query # times to MySQL?

Question

I want to test the load a MySQL server can handle using a couple versions of a query and for that I'm looking for something like apachebench (but for mysql).

I'm hoping to run 500 or more concurrent requests every second for a couple minutes and see if MySQL is up to the challenge.

possible duplicate of [mysql load testing tools](http://stackoverflow.com/questions/1593498/mysql-load-testing-tools) — OMG Ponies, Sep 05 '10 at 01:24

score 1 · Accepted Answer · edited Jun 11 '12 at 23:43

1

Does Super Smack solve your problem?

edited Jun 11 '12 at 23:43

Community

1
1

answered Sep 05 '10 at 01:30

Corith Malin

1,505
10
18

How do you repeat a raw SQL query # times to MySQL?

1 Answers1