mysql查看锁

show processlist

select * from information_schema.PROCESSLIST where info is not null and time > 0;

select * from information_schema.processlist where command <> 'Sleep' and id <> connection_id();
--查看锁表
show open tables where in_use>0 ;

select * from  information_schema.innodb_locks\G;

查看正在锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; 

查看等待锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; 

show engine innodb status