Skip to main content

SingleStoreDB v8.1

FILL and FLUSH CONNECTION POOLS

Used to 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

FILL CONNECTION POOLS;
Query OK, 2 rows affected (2.02 sec)

FLUSH CONNECTION POOLS;
Query OK, 2 rows affected (200 ms)
In this section: