Hi,

We have lots of mysql servers, master-slave and sharded databases. A recurring task when a new feature/application comes in to test the database with real workload. This needs test data and test query generation. Until now I did this with ad-hoc scripts, I looked for tools to do this, so far I found nothing.

The closest thing to this was benerator, but it doesn't generate test queries. I need to measure write performance too (or concurrent read/write performance), so it would be good if I can tell the tool to generate bulk inserts with n records or generate a csv file or generate single insert... statements, so I can simulate the application's workload (of course I can do this with the application itself, but in development stage it is important to see how the database itself performs).

Does such a tool exists? No problem if it is mysql only. If not, I think I will write one.

Peter Boros

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to