MySQL查看锁情况

查看锁表情况

show status like ‘Table%’;

查看正在被锁定的的表

show OPEN TABLES where In_use > 0;

查看正在锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;

查看等待锁的事务

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;

查看当前执行的SQL

show processlist