mysql

1.命令是用来查看当前出现的锁

 SELECT * FROM information_schema.INNODB_LOCKs;

2.命令是用来查看锁等待的对应关系

SELECT * FROM information_schema.INNODB_LOCK_waits;

3.命令是用来查看当前运行的所以事务：

select * from information_schema.innodb_trx

3.