How MySQL.com Improved Their Database Performance with Query

Adam Donnison (Sun Microsystems)

MySQL.com is the public face of the Sun Database Group’s MySQL offering, with more than 70,000 downloads per day and millions of visitors each month. Key to this vital portal for developers, users and potential customers, is the MySQL database. To make sure other sites don’t have problems, MySQL.com uses the latest version available and this can provide unique challenges. Luckily the web team responsible for managing MySQL.com also have access to the latest version of Enterprise Tools like Query Analyzer.

Query Analyzer is able to provide database developers with in-depth details on how queries perform, how many times they run, and how many system resources they consume. With hooks to allow you to see exactly how the database will perform the query, Quan has proven an invaluable resource for the MySQL.com web team.

In this session Adam Donnison will explain how badly performing queries could slip through the cracks, and how using Quan found these queries within minutes of being deployed. In a graphic demonstration of the power of Query Analyzer, Adam was able to improve performance by several orders of magnitude, in just minutes.

Adam has worked closely with the Enterprise Tools team in every release cycle of Enterprise Monitor, and was particularly excited about Quan and its possibilities, but even he was impressed with the results.

Photo of Adam Donnison

Adam Donnison

Sun Microsystems

Adam is currently a member of the team responsible for the MySQL.com websites. He was primarily responsible for the design of the current web infrastructure, which now achieves an enviable uptime, showing that it can be done with open source and commodity hardware.

In previous incarnations Adam has been an analyst programmer, consultant, systems engineer, trainer and courseware developer.

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.