Mastering InnoDB Diagnostics

Average rating: ****.
(4.08, 13 ratings)

Information for solving problems with InnoDB comes from many sources, including SHOW INNODB STATUS, table monitors, SHOW STATUS, SHOW MUTEX STATUS, and information_schema tables as well as operating systems information such as iostat, vmstat, Performance Monitor and gdb/PMP.

Knowing which information is useful when diagnosing real production problems is a tough skill to learn. This talk will teach people some of the best techniques for handling the most common InnoDB issues such as locking, deadlocks, data dictionary, and performance issues.

Harrison Fisk


Harrison has worked for over 7 years at MySQL AB and Sun Microsystems as a Trainer, Consultant, and now Staff Support Engineer. He has filled many roles during this time, from authoring training courses to handling some of the biggest users of MySQL.

He has also co-authored a book, MySQL Clustering.

Comments on this page are now closed.


Picture of Rick James
Rick James
04/15/2010 2:29am PDT

One of the meatiest talks at the conference. Fast paced, information loaded, useful.

Worth repeating at the next conference.

  • 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

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@

Press and Media

For media-related inquiries, contact Maureen Jennings at

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.