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>