title: Get locked tables in mysql query
body: <p>Is there any way via a MySQL query to get the locked tables?  I have a C# threading application running and there are bunch of tables getting locked in the app.</p>
  
  <p>I need to see the locked tables and analyze the code that could be locking it.</p>