title: mysql query locking tables
body: <p>Hi Is there a way of checking which query is locking tables in mysql? We can Identify which tables are locked however Its difficult to find the query that is locking tables. We have tried show processlist, show engine innodb status, and also looked at some tables such INNODB_TRX and INNODB_LOCKS. Is there a specific method that can point out what is causing the locks?</p>