Outdated Version

You are viewing an older version of this section. View current production version.

KILLALL QUERIES

Kills all running queries or closes all connections.

Syntax

KILLALL [CONNECTIONS | QUERIES] [LIKE 'pattern']

Remarks

  • KILLALL CONNECTIONS will disconnect the clients associated with killed queries. This is the default.
  • KILLALL QUERIES will not disconnect the clients associated with killed queries. An error will be sent to all such clients.
  • pattern - Only kill queries which match this pattern.
  • KILLALL will only kill queries running on the same node as this operation.
  • MemSQL checks for the kill bit during any potentially long running loop during query execution and rolls back the query’s transaction if the kill bit is set.
  • This command will only kill queries running on the same node as it.
  • This command must be run on the master aggregator or a child aggregator node (see Node Requirements for MemSQL Commands).

Example

memsql> KILLALL QUERIES LIKE 'SELECT%';
Query OK, 0 rows affected (0.00 sec)