SHOW PROCESSLIST SELECT * FROM information_schema.INNODB_TRX; kill 3200313 这个sql查询出来的结果执行一次,就行了 SELECT CONCAT(‘KILL ‘,trx_mysql_thread_id,’;’) FROM information_schema.INNODB_TRX;