title: Detecting locked tables (locked by LOCK TABLE)
body: <p>Is there a way to detect locked tables in MySQL? I mean tables locked by the <code>LOCK TABLE table WRITE/READ</code> command.</p>
  
  <p><sub>(Note that readers interested in detecting <em>named</em> locks acquired with <code>GET_LOCK</code> should read <a href="https://stackoverflow.com/q/11034504/1709587">Show all current locks from get_lock</a> instead.)</sub></p>