Harmless – returns ERROR 1094 (HY000): Unknown thread id .
SELECT * FROM information_schema.PROCESSLIST WHERE TIME > 10 AND COMMAND != 'Sleep' ORDER BY TIME DESC;
When you run a KILL command, MySQL doesn't always stop the process instantly. Instead: : The server sets a "kill flag" for that thread.
If you find a process with Id that has been running for 5,000 seconds:
| Command | Purpose | | :--- | :--- | | SHOW FULL PROCESSLIST | View all running threads and full queries. | | KILL <id> | Kill the query and close the connection. | | KILL QUERY <id> | Kill the query but keep the connection open. |
