This morning I had an issue where my transactions weren’t being committed and needed to figure out why. When Googling for a way to see what transactions were conducted, but not active I came across a great ‘Show INNODB Status’ post from MySQL Performance Blog.

If you have the correct admin privileges; log into your MySQL DB server and type the following:

show innodb status

You will be presented a wealth of information, including transaction history (or snapshot if there are many). The aforementioned link will give you a section by section explanation, which proved to be quite helpful in debugging my specific issue.