DM for MySQL Blocking and Blocked Sessions

by Oct 31, 2018

A common request I get during demos is for the ability to identify blocking sessions.  This is identified as a critical need by many potential clients.

Currently DM for MySQL shows blocked sessions (waiting on locks), but there is no way to identify what object or what user is holding the lock. I would like to see two columns added to the “Threads” tab, “Blocked by” and “Blocking.”  The first would show the thread that is blocking that thread, and the second column would show that that thread is blocking other threads. Having an identifier to help identify the blocked object would also be helpful.