1 查看锁等待的事务
select * from information_schema.INNODB_TRX;
2 查看插件
show plugins;
3 查看锁的情况
SHOW STATUS like '%lock%';
1 查看锁等待的事务
select * from information_schema.INNODB_TRX;
2 查看插件
show plugins;
3 查看锁的情况
SHOW STATUS like '%lock%';
转载于:https://www.cnblogs.com/stxyg/p/6932387.html