我杀死的线程仍然在我的线程列表中，如何消除它？
+-----+------+-----------+-------------+---------+-------+-----------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+-------------+---------+-------+-----------+------------------------------------------------------------------------------------------------------+
| 678 | root | localhost | hthtthv | Killed | 36923 | query end | INSERT INTO `gtgttg` VALUES (1,'tgtg'),(2,'Shopping'),(4,'tgtgtg'),( |
| 695 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+-----+------+-----------+-------------+---------+-------+-----------+------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
最佳答案
它需要恢复它所做的操作，因此这可能需要很长时间。如果它是一个InnoDB数据库，您可以查看这个问题：https://dba.stackexchange.com/questions/5654/internal-reason-for-killing-process-taking-up-long-time-in-mysql
所以最后：你需要等待它被淘汰
关于mysql - 仍然在我的进程列表中被杀死的进程，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/10883936/