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 6
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, process no 1151, OS thread id 1150134400
MySQL thread id 42, query id 6 localhost root
show engine innodb status
---TRANSACTION 2857, ACTIVE 1 sec updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 368, 1 row lock(s)
MySQL thread id 47, query id 7 localhost root updating
UPDATE users SET status = 'locked' WHERE id = 1
------- TRX HAS BEEN WAITING 1 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 30 page no 3 n bits 72 index `PRIMARY` of table `test`.`users` trx id 2857 lock_mode X waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
...