mysql 查询表死锁语句
1.确定是否锁表 select * from information_schema.innodb_locks; 2.查询正在锁的事务 select * from information_schema.innodb_locks; 3.查询等待锁的事务 select * from information_schema.innodb_lock_waits; 4.查询未提交的事务 select * from information_schema.innodb_trx 5.查询所有的线程 select * from information_schema.PROCESSLIST;
注：记录命令用于排查问题
