If You Love It, Break It: Testing MySQL with the Random Query Generator

This session will describe the Random Query Generator, a new tool for generating complete databases and executing queries against them for the purpose of stress testing.

• Generate a database from a description of the desired data contents and properties;
• Execute random queries based on SQL templates the queries must conform to;
• Compare the results returned by different server versions, configurations, or storage engines;
• Monitor the server during the test and detect deadlocks, crashes, replication failures and other interesting events;

• Customers who wish to evaluate MySQL stability and performance will be able to generate syntetic data and workloads that match the application they are planning to deploy;
• Storage engine implementors can use the tool to test their code and the way it interacts with features of the core server (such as partitioning and replication);
• Individual users who are eager to break the server will have a powerful weapon in their hands.