Determine Reason for Deadlock in MySQL We've been seeing some deadlocks occur but have not been able to reproduce.  Is there any way to determine, after the fact, what queries were running, etc to figure out why deadlock occurred?
SHOW INNODB STATUS will give you the last detected deadlock.