Product Solutions Support
Try MemSQL

SHOW AGGREGATORS

Show the aggregators in a cluster.

SHOW AGGREGATORS;

Notes

Output

Column Description
Host Host name or IP address
Port Port number
State Aggregator state
Opened_Connections Number of opened connections
Average_Roundtrip_Latency Average round-trip latency
`Master_Aggregator Master aggregator for this cluster

Example

memsql> SHOW AGGREGATORS;
+---------------+-------+--------+--------------------+---------------------------+-------------------+
| Host          | Port  | State  | Opened_Connections | Average_Roundtrip_Latency | 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)
Was this article useful?