Showing entries 1 to 1
Displaying posts with tag: lock contention (reset)
Dec
21
2007
How I patched InnoDB to show locks held
Posted by Baron Schwartz (xaprb) on Fri 21 Dec 2007 21:45 UTC
Tags:

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