Registered 2008-10-23 by Philip Stoev

This project implements a pseudo-random data and query generator that can be used to test any Perl DBI, JDBC or ODBC-compatible SQL server, in particular MySQL, but also JavaDB and PostgreSQL.

The Random Query Generator is a new tool for generating complete databases and executing queries against them for the purpose of functional and stress testing.

The tool is capable of executing test scenarios that include:
* 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;

The tool is useful for the following audiences:
* 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.
* Implementors who wish to evaluate MySQL stability and performance can generate syntetic data and workloads that match the application they are planning to deploy;

 Copyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved.

Project information


RDF metadata

View full history Series and milestones

2.0 series is the current focus of development.

Get Involved


Latest version is 2.2.0
released on 2010-02-09

All downloads