Simulating traffic on mysql server

dlugasx · 03-22-2012, 06:14 AM

Hello everyone,

I have a question concerning mysql server.

Do You know any reasonable application to simulate traffic on mysql server ? Something which can execute n sql queries during specified time.

I would like to test my backup strategy on running system. Maybe somebody knows how to do it ?

thanks in advance

Dlugasx

acid_kewpie · 03-22-2012, 06:17 AM

http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html

dlugasx · 03-22-2012, 06:20 AM

Quote:

Originally Posted by acid_kewpie

http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html

5 Points and one big Beer

Thanks for help

)))

acid_kewpie · 03-22-2012, 06:27 AM

All I did was type "mysql load test" into google and click the first result ;-)