Does it exist a tool like ab (apache bench) for mysql?
ex: I create a table, I fill as i want (some MO of rows)
then:
shell> tool -conccurency=20 -requests=2000 -query="SELECT * FROM table WHERE col = 42"
will result into some summarized result
I know that mysqlslap seems to play something like that, but it seems to work only with a mysqlslap database (a fake one). I couldn't make it work with an existing DB
I found the solution.
I have to write my requests like this:
SELECT my_db.my_table .... for mysqlslap use my own db