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

Average rating: ****.
(4.00, 3 ratings)

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.

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;

This session will be useful for the following audience:

  • 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.

Philip Stoev

Sun Microsystems

Philip Stoev is a QA Engineer in the SystemQA team of MySQL.

Comments on this page are now closed.


Picture of Sheeri K. Cabral
Sheeri K. Cabral
07/29/2009 5:30am PDT

The video is now up on YouTube at www.youtube.com/watch?v=_jf...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
06/25/2009 12:35am PDT

Play the video directly in your browser at technocation.org/node/741/play or download it at technocation.org/node/741/d...

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.