query locking table

Sometimes you may need to view MySQL query locking table. Here is how to view query that is locking MySQL tables.