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.
SHOW AGGREGATORS
Info
SingleStore Managed Service does not support this command.
Show the aggregators in a cluster.
Syntax
SHOW AGGREGATORS;
Remarks
- This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStore DB Commands ).
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)
