SHOW INNODB STATUS Walk Through
By: Peter Zaitsev
I found Peter’s blog from a StackOverflow question about deadlocking. It’s well documented and looks promoising. Here is the link for the orginal SO question.
MySQL 5.0 Reference Manual – The InnoDB Transaction Model and Locking
Manuals are always good reads.