You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

SHOW AGGREGATORS

Info

MemSQL Helios does not support this command.

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

memsql> 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)