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

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

memsql> FLUSH CONNECTION POOLS;
Query OK, 2 rows affected (200 ms)
Was this article useful?