跳转至

SQL

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;