# FILL and FLUSH CONNECTION POOLS

The `FILL CONNECTION POOLS` and `FLUSH CONNECTION POOLS` commands open and close (reset) connections to leaf nodes.

## Syntax

```
{FILL | FLUSH} CONNECTION POOLS;

```

## Remarks

* `FILL`: opens the maximum number of pooled connections (specified for the connection) to each leaf node in the cluster.
* `FLUSH`: shuts down all existing connections and closes idle pooled connections.
* This command can be run on any node in the cluster. It opens/closes connections only from the nodes on which it is executed. Hence, in order to open/close connections from multiple nodes, this command must be individually executed on each node.

## Example

```sql
FILL CONNECTION POOLS;

```

```output

Query OK, 2 rows affected (2.02 sec)

```

```sql
FLUSH CONNECTION POOLS;

```

```output

Query OK, 2 rows affected (200 ms)
```

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/cluster-management-commands/fill-and-flush-connection-pools/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/cluster-management-commands/fill-and-flush-connection-pools/)

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