show processlist; kill id; 如果杀不完,杀了又出来新的,那就用下面的 select * from information_schema.innodb_trx Kill trx_mysql_thread_id;