mysql查看当前表锁

SHOW ENGINE INNODB STATUS;

START TRANSACTION;
UPDATE users SET status = 'active' WHERE id = 1;

SHOW ENGINE INNODB STATUS;

---TRANSACTION 3730028, ACTIVE 10 sec updating or deleting
mysql tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 123456, OS thread handle 0x7f8d9d0f1700, query id 7890123 localhost root updating
UPDATE users SET status = 'active' WHERE id = 1
------- TRX HAS BEEN WAITING 10 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 123 page no 4 n bits 72 index `PRIMARY` of table `test`.`users` trx id 3730028 lock_mode X locks rec but not gap waiting
Record lock, heap no 1 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
 0: len 4; hex 80000001; asc     ;;
 1: len 6; hex 00000000005f; asc     _;;
 2: len 7; hex f80000000001; asc       ;;
 3: len 30; hex 4d6172795f6e616d65; asc My_name;;
 4: len 3; hex 01; asc  ;;