Some operations are not killable:
In some cases, you may not be able to kill a query using the KILL command. Here are some alternative methods: mysql kill query
The syntax for stopping a specific query is straightforward: KILL QUERY [processlist_id]; Use code with caution. Some operations are not killable: In some cases,
So suppose you write a Python script to do some MySQL queries… and you have a big honking table in your database, and you write an... Massachusetts Institute of Technology MySQL 9.6 Reference Manual :: 15.7.8.4 KILL Statement 15.7. 8.4 KILL Statement. ... Each connection to mysqld runs in a separate thread. You can kill a thread with the KILL processlist... MySQL :: Developer Zone Killing my softly with QUERY - Ronald Bradford Jul 12, 2009 — Massachusetts Institute of Technology MySQL 9
This kills the query and terminates the connection thread entirely.
When you issue KILL QUERY <thread_id> :