Outdated Version
You are viewing an older version of this section. View current production version.
SHOW AGGREGATORS
Show the aggregators in a cluster.
SHOW AGGREGATORS;
Notes
- 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 |
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)
