mysql锁相关命令
一、查看mysql锁相关命令1、通过INFORMATION_SCHEMA.INNODB_TRX、INNODB_LOCKS、INNODB_LOCK_WAITS 获取事务与锁的信息1)查看哪些事务正在执行命令:SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;trx_state表示事务的状态mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX \G*********************