查看是否有表锁：show OPEN TABLES where In_use > 0 查询进程：show processlist 查看正在锁的事务：SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS 查看等待锁的事务：SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS_WAITS
京公网安备 11010502049817号