MySQL查锁定的表并解锁

查open tables SHOW OPEN TABLES WHERE in_use>0; 查Process List SHOW FULL PROCESSLIST; 查Transactions SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX; 杀死进程 KILL process_ID/transaction_process_ID;