information_schema.innodb_locks
这个表罗列了两类锁:
- 事务请求了但是还没有获取到的锁
- 事务持有的锁,并且这个锁阻塞了其他事务的执行
The INNODB_LOCKS table contains information about each lock that an InnoDB transaction has requested but not yet acquired, and each lock that a transaction holds that is blocking another transaction.