Kill Query with query ID - MariaDB 10.0.5

rspadim's profile image rspadim posted 9 years ago in General Permalink
Hi guys, that's very important, i need to kill a connection, but using the query ID
Here is how mariadb solve this problem:

https://mariadb.com/kb/en/mariadb/data-manipulation-kill-connection-query/
KILL QUERY ID (introduced in MariaDB 10.0.5) terminates the query by query_id, leaving the connection intact.

---
here what changed:
https://mariadb.com/kb/en/mariadb/information-schema-processlist-table/
QUERY_ID Query ID. MariaDB 10.0.5


when QUERY_ID columns exists at INFORMATION_SCHEMA.PROCESSLIST, use KILL QUERY ID <query id> instead of KILL <process id>

Please login to leave a reply, or register at first.