SHOW AGGREGATORS
Show the aggregators in a cluster.
Syntax
SHOW AGGREGATORS;
Remarks
See the Permission Matrix for the required permission.
Output
Column | Description |
---|---|
| Host name or IP address |
| Port number |
| Aggregator state |
| Number of opened connections |
| Average round-trip latency in milliseconds |
| 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)