This presentation was done by Sheeri Cabral of The Pythian Group and went into how to use
SHOW ENGINE INNODB STATUS to get more information about your Innodb tables, foreign keys and transactions. This is a great presentation to learn how InnoDB works.
It also went through how to use
SHOW ENGINE INNODB STATUS to tune several InnoDB variables:
The slides can be downloaded from:
(Note that the slides open up to the middle section, which has slides plus notes, but if you just want the slides without notes, that starts on page 1 of the PDF.)
The video can be watched below, or directly on YouTube at http://www.youtube.com/watch?v=ocdjspoLM58
Interested in working with Sheeri? Schedule a tech call.