INNODB_LOCKS, INNODB_LOCK_WAITS, INNODB_TRX是MYSQL中事务和锁相关的表。通常我们遇到事务超时或锁相关问题时,直接运行下面SQL语句即可进行简单检查:--查看事务select * from information_schema.INNODB_TRX;--查看锁select * from information_schema.INNODB_........
INNODB_LOCKS, INNODB_LOCK_WAITS, INNODB_TRX是MYSQL中事务和锁相关的表。通常我们遇到事务超时或锁相关问题时,直接运行下面SQL语句即可进行简单检查:--查看事务select * from information_schema.INNODB_TRX;--查看锁select * from information_schema.INNODB_........