SQL Load Testing

We have been doing some MS SQL Server load testing and deadlock investigation at work, using the Microsoft RML Utilities. These consist of a tool called ReadTrace which will process a SQL Profiler trace into XML files, and generate an analytics database (with reports!) and a tool called ostress which can replay these xml files against a database, and simulate several users. I have been looking for a similar tool for MySQL and apart from several “load” scripts, all I could find was something called bristlecone. I will be testing this out in the next couple of weeks and will report back here with my results.

Tags: ,

Leave a Reply