mysql

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

 SELECT * FROM information_schema.INNODB_LOCKs;

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

SELECT * FROM information_schema.INNODB_LOCK_waits;

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

select * from information_schema.innodb_trx

3.

 

posted @ 2020-09-22 21:03  ascas  阅读(53)  评论(0编辑  收藏  举报