Conference News & Coverage
Sponsors

Diamond Sponsors

  • Fotango
  • Intel
  • Microsoft

Gold Sponsors

  • Dell Inc.
  • Hewlett Packard
  • IBM
  • Mozilla Corporation

Silver Sponsors

  • ActiveState
  • Autodesk
  • Google
  • Greenplum
  • Ingres
  • Novell, Inc.
  • NYTimes.com
  • OpSource
  • Rearden Commerce
  • SnapLogic
  • ThoughtWorks
  • Ticketmaster

Sponsors & Exhibitors

For information on exhibition and sponsorship opportunities at the convention, contact Sharon Cordesse

For Media Partnership opportunities, please contact Avila Reese

Download the OSCON Sponsor/Exhibitor Prospectus (PDF).

Conference News

To stay abreast of Conference news and to receive email notification when registration opens, please sign up here.

Press & Media

For media-related inquiries, contact Dawn Applegate at

Program Ideas

Drop us a line at and tell us who and/or what would make OSCON a must-attend event.

User Groups & Professional Associations

For user group and professional association related inquiries, contact Marsee Henon at

Tutorial

Target Practice: A Workshop in Tuning MySQL Queries

Jay Pipes, Community Relations Manager, North America, MySQL AB

Track: Databases
Date: Monday, July 23
Time: 8:30am - 12:00pm
Location: D136

This tutorial is for all those database developer gun-slingers who want to rid their applications of poorly performing queries and their outlaw cousin, the inefficient schema.

Take aim at poor application performance by learning how to read and understand MySQL query execution plans and tailor your SQL code and schema for optimal performance and scalability. The tutorial is designed as a hands-on workshop that demonstrates how query and index tuning can dramatically decrease application response time and make your all-important customer happy.

All of the following core concepts will be covered in detail:

  • The ins and outs of the MySQL query optimization process
  • The EXPLAIN command, in-depth
  • Profiling queries using the SHOW PROFILE command new in MySQL 5.0.35 Community Server

Hands-on demonstrations of:

  • How simple changes to indexing or schema design have dramatic effects on performance
  • How to set up a simple, but effective, benchmarking framework on your local development machine to harness techniques you learn during the tutorial

While there are some rather advanced topics covered in the tutorial, audience members with light to intermediate experience using MySQL should be able to follow along with the material. Laptops aren't required, but for those who do have one, the tutorial is designed so attendees can follow along with the demonstrations on their laptops using a local instance of MySQL.