Better Database Debugging for Shorter Downtimes

Robert Hamel (Pythian)
Average rating: ****.
(4.00, 8 ratings)

We will go through the most common issues we have faced in this regard and demonstrate how proper instrumentation at the database level can make you a better DBA.

These instrumentation techniques do not require special tools and can mostly be implemented via stored procedures, events, or simple shell scripts. The Pythian Group has developed and refined these techniques since 1998, for 52 different MySQL environments (clients) spread across 700+ databases.

Areas that will be addressed are:

collecting and using performance metrics (how and what to collect) Configuration auditing DDL auditing Event scheduler jobs Range partitioning

Robert Hamel

Pythian

15 years+ experience as Data Architect/DBA specializing in high volume OLTP and data warehouse environments starting with Oracle and branching out into MySQL in 2003.

Comments on this page are now closed.

Comments

Dan Lu
04/20/2010 11:14am PDT

Is it possible to share the code to keep track of the mysql’s variable changes? I don’t think it is in the slide presentation.

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/19/2010 8:37pm PDT

Video for this presentation is online at www.youtube.com/watch?v=B9J...

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/19/2010 8:34pm PDT

The file is actually a ppt but is listed as a text file. There are slides in PDF format at technocation.org/files/doc/...

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo 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

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.