如何查看mysql哪张表被锁

SHOW ENGINE INNODB STATUS;

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.tr->thread_id blocking_thread, 
    b.trx_query blocking_query, 
    b.lock_id blocking_lock_id, 
    b.lock_trx_id blocking_trx_lock_id, 
    b.lock_mode blocking_lock_mode, 
    b.lock_type blocking_lock_type, 
    b.lock_table blocking_lock_table, 
    b.lock_index blocking_lock_index, 
    b.lock_data blocking_lock_data, 
    b.trx_wait_started blocking_wait_started, 
    b.trx_wait_exceeded blocking_wait_exceeded 
FROM 
    information_schema.innodb_lock_waits w 
INNER JOIN 
    information_schema.innodb_locks b ON b.lock_id = w.requested_lock_id 
INNER JOIN 
    information_schema.innodb_trx btr ON btr.trx_id = b.lock_trx_id 
INNER JOIN 
    information_schema.innodb_trx r ON r.trx_id = w.blocking_trx_id;