SingleStore DB

SHOW AGGREGATORS

Show the aggregators in a cluster.

Syntax
SHOW AGGREGATORS;
Remarks

Output

Column

Description

Host

Host name or IP address

Port

Port number

State

Aggregator state

Opened_Connections

Number of opened connections

Average_Roundtrip_Latency_ms

Average round-trip latency in milliseconds

Master_Aggregator

Master aggregator for this cluster

Example
SHOW AGGREGATORS;
+---------------+-------+--------+--------------------+------------------------------+-------------------+
| Host          | Port  | State  | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator |
+---------------+-------+--------+--------------------+------------------------------+-------------------+
| 127.0.0.1     |  3306 | online |                  0 |                      NULL    |                 1 |
| 192.168.1.116 |  3306 | online |                  1 |                     0.200    |                 0 |
+---------------+-------+--------+--------------------+------------------------------+-------------------+
2 rows in set (0.00 sec)