How to debug InnoDB lock waits
January 23 2012, 4:15pm
This article shows you how to use a little-known InnoDB feature to find out what is holding the lock for which an InnoDB transaction is waiting. I then show you how to use an undocumented feature to make this even easier with innotop.
Via: http://www.xaprb.com/blog/2007/09/18/how-to-debug-innodb-lock-waits/
Your favourite external commenting service goes here! I recommend http://www.disqus.com
