MySQL查锁定的表并解锁

查open tables

[code lang="sql"]
SHOW OPEN TABLES WHERE in_use>0;[/code]

查Process List

[code lang="sql"]
SHOW FULL PROCESSLIST;[/code]

查Transactions

[code lang="sql"]
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;[/code]

杀死进程

[code lang="sql"]
KILL process_ID/transaction_process_ID;[/code]