MYSQL查询事务并强制删除 SELECT * from information_schema.INNODB_TRX KILL trx_mysql_thread_id(该字段) ; 暴力全部删除 select concat('KILL ',id,';') from information_schema.processlist p WHERE p.USER = '库名' ; 把查询结果复制后批量执行