← Back to team overview

maria-developers team mailing list archive

  1. maria-developers team
  2. Mailing list archive
  3. Message #06095

Re: MDEV-4911 - KILL command with query id

  Thread Previous • Date Previous • • Thread Next 
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

  Thread Previous • Date Previous • • Thread Next