How MySQL looks at locks

A by the View chart

SELECT r.trx_id waiting_trx_id,

r.trx_mysql_thread_id Waiting_thread,

R.trx_query Waiting_query,

b.trx_id blocking_trx_id,

b.trx_mysql_thread_id Blocking_thread,

B.trx_query Blocking_query

From Information_schema.innodb_lock_waits W

INNER JOIN Information_schema.innodb_trx B on

b.trx_id = w.blocking_trx_id

INNER JOIN Information_schema.innodb_trx R on

r.trx_id = w.requesting_trx_id

B View by parameter

Show global variables like '%lock% ';

C View the status of the InnoDB engine

Show Engine InnoDB status\g;

How MySQL looks at locks