# KILLALL QUERIES

The `KILLALL QUERIES` command 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.
* SingleStore 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 SingleStore Commands](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands.md)).

## Example

```

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

```

***

Modified at: June 12, 2026

Source: [/db/v9.1/reference/sql-reference/operational-commands/killall-queries/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/killall-queries/)

(An index of the documentation is available at /llms.txt)