--查看是否死锁
show open tables where IN_USE >0;
--查询进程
show processlist;
--查看正在锁得事务
select * from information_schema.innodb_locks;
--查看等待锁得事物
select * from information_schema.INNODB_LOCK_WAITS;
--查看是否死锁
show open tables where IN_USE >0;
--查询进程
show processlist;
--查看正在锁得事务
select * from information_schema.innodb_locks;
--查看等待锁得事物
select * from information_schema.INNODB_LOCK_WAITS;