SELECT * FROM information_schema.innodb_lock_waits; 锁等待的对应关系
SELECT * FROM information_schema.innodb_locks; 当前出现的锁 SELECT * FROM information_schema.innodb_trx; 当前运行的所有事务本文共 221 字，大约阅读时间需要 1 分钟。
SELECT * FROM information_schema.innodb_lock_waits; 锁等待的对应关系
SELECT * FROM information_schema.innodb_locks; 当前出现的锁 SELECT * FROM information_schema.innodb_trx; 当前运行的所有事务转载于:https://my.oschina.net/maojindaoGG/blog/2876746