mysql查看被锁表

SHOW ENGINE INNODB STATUS;

------------------------
LATEST DETECTED FAILURE
------------------------
...

TRANSACTIONS
------------
Trx id counter 1073741824
Purge done for trx's n:o < 1073741823 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 1, OS thread handle 0x7f8d9d0f1700, query id 1 localhost root
show engine innodb status
---TRANSACTION 2837905, ACTIVE 10 sec starting index read
mysql thread id 12345, OS thread handle 0x7f8d9d0f1700, query id 666 localhost root updating
UPDATE table_name SET column1 = 'value1' WHERE id = 1
------- TRX HAS BEEN WAITING 8 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 18 page no 8204 n bits 72 index `PRIMARY` of table `database_name`.`table_name` trx id 2837905 lock_mode X locks rec but not gap waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
...

KILL TRANSACTION 2837905;