如何查询mysql哪个语句正在锁表,show full processlist;没有查到有效的信息
1、查询是否锁表 show OPEN TABLES where In_use > 0; 2、查看正在锁的事务 SELECT FROM INFORMATION_SCHEMA.INNODB_LOCKS; 3、查看等待锁的事务 SELECT FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;