FILL and FLUSH CONNECTION POOLS

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)