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)