MySQL: Check blocking locks

 SELECT 
    r.trx_id AS waiting_trx_id,
    r.trx_mysql_thread_id AS waiting_thread,
    r.trx_query AS waiting_query,
    b.trx_id AS blocking_trx_id,
    b.trx_mysql_thread_id AS blocking_thread,
    b.trx_query AS blocking_query
FROM performance_schema.data_lock_waits w
JOIN information_schema.innodb_trx b 
    ON w.blocking_engine_transaction_id = b.trx_id
JOIN information_schema.innodb_trx r 
    ON w.requesting_engine_transaction_id = r.trx_id;
    
    
    
    SELECT 
    r.trx_id AS waiting_trx_id,
    r.trx_mysql_thread_id AS waiting_thread,
    r.trx_query AS waiting_query,
    b.trx_id AS blocking_trx_id,
    b.trx_mysql_thread_id AS blocking_thread,
    b.trx_query AS blocking_query,
    b.trx_started as blocking_start_time
FROM performance_schema.data_lock_waits w
JOIN information_schema.innodb_trx b 
    ON w.blocking_engine_transaction_id = b.trx_id
JOIN information_schema.innodb_trx r 
    ON w.requesting_engine_transaction_id = r.trx_id;