Outdated Version
You are viewing an older version of this section. View current production version.
SHOW AGGREGATORS
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 MemSQL 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
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)
