This presentation was be 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[Read more...]