I've written before about how to figure out which connection is holding the InnoDB locks for which other connections are waiting. In other words, how to figure out who's blocking you from getting work done. The short and sweet: turn on the InnoDB lock monitor and use innotop to look at the locks held and waited-for. This has some disadvantages, so I made a patch to solve the issue the way I like it. The result is significantly more ability to find and solve InnoDB lock wait issues.
Showing entries 1 to 1
Dec
21
2007
Showing entries 1 to 1
Top 20 Authors
Frederic Descamps (13)Joshua Otwell (6)
Olivier Dasini (6)
Dave Stokes (5)
Saroj Tripathy (5)
Marco Tusa (4)
Michael McLaughlin (4)
Daniel Nichter (3)
Jesper Krogh (3)
Mirko Ortensi (3)
Vlad Mihalcea (3)
Hardik Savani (2)
Kristian Köhntopp (2)
Andrew Grimo (1)
David Yeager (1)
Dimitri Kravtchuk (1)
Jean-François Gagné (1)
Keith Hollman (1)
Krunal Bauskar (1)
Lalit (1)