← Back to team overview

maria-developers team mailing list archive

Re: MDEV-4911 - KILL command with query id

 

maybe we could use (a bit complex, but nice):

KILL QUERY_ID IN (SELECT QUERY_ID FROM information_schema.PROCESSLIST WHERE ...)
or
KILL THREAD_ID IN (SELECT id FROM information_schema.PROCESSLIST WHERE ...)
or
KILL USER IN (SELECT user FROM information_schema.PROCESSLIST WHERE ...)



References