1、查询是否锁表
show open tables where in_use>0;
2、查询进程
show processlist
查询到相对应的进程,然后 kill id
3、查看正在锁的事务
select * from information_schema.innodb_locks;
4、查看等待锁的事务
select * from information_schema.innodb_lock_waits;
5、查看等待锁的事务
select * from information_schema.innodb_trx;
eg:
information_schema.innodb_lock_waits–锁等待的对应关系
information_schema.innodb_locks–当前出现的锁
information_schema.innodb_trx–当前运行的所有事务
没有评论