Find table locks and blocking transaction

The table locks and blocking transaction are a very common thing in any database system.
To find all locked and blocked transactions of MySQL Server:

SELECT
    pl.id
    ,pl.user
    ,pl.state
    ,it.trx_id
    ,it.trx_mysql_thread_id
    ,it.trx_query AS query
    ,it.trx_id AS blocking_trx_id
    ,it.trx_mysql_thread_id AS blocking_thread
    ,it.trx_query AS blocking_query
FROM information_schema.processlist AS pl
INNER JOIN information_schema.innodb_trx AS it
ON pl.id = it.trx_mysql_thread_id
INNER JOIN information_schema.innodb_lock_waits AS ilw
ON it.trx_id = ilw.requesting_trx_id
        AND it.trx_id = ilw.blocking_trx_id;

For more information on latest deadlocks and transaction locks, please refer:
mysql> show engine innodb status\G

References:
http://www.dbrnd.com/2016/02/mysql-script-to-identify-the-locks-and-blocking-transactions/