mysql 查看表是否存在死锁

SHOW OPEN TABLES WHERE In_use > 0;

 

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS WHERE LOCK_TABLE = 'hljtxeip/hljtxeip_personworkrecord';

SELECT ID, USER, HOST, DB, COMMAND, TIME, INFO
FROM INFORMATION_SCHEMA.PROCESSLIST
WHERE DB = 'hljtxeip' AND (INFO LIKE '%hljtxeip_personworkrecord%' OR STATE LIKE '%Table_locks%');

 

 

KILL 1159