数据库事务和锁——INNODB_LOCKS, INNODB_LOCK_WAITS, INNODB_TRX表的简单介绍_innodb_trx、innodb_locks、innodb_lock_waits分析-CSDN博客网友收藏

数据库事务和锁——INNODB_LOCKS, INNODB_LOCK_WAITS, INNODB_TRX表的简单介绍_innodb_trx、innodb_locks、innodb_lock_waits分析-CSDN博客

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