Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
SingleStore Managed Service does not support this command.
Show the aggregators in a cluster.
SHOW AGGREGATORS;
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 |
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)