SHOW AGGREGATORS
On this page
Show the aggregators in a cluster.
Syntax
SHOW AGGREGATORS [EXTENDED];
Remarks
-
Refer to 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 |
|
|
Whether a given aggregator is a master or child. |
|
|
The unique |
|
|
Internal |
SHOW AGGREGATORS EXTENDED
SHOW AGGREGATORS EXTENDED adds these additional columns:
|
Column |
Description |
|---|---|
|
|
The timestamp of the coordinator's oldest distributed transaction. |
|
|
The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves). |
|
|
The ID of the availability group to which the aggregator belongs. |
Example
SHOW AGGREGATORS;
+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
| Host | Port | State | Opened_Connections | Average_Roundtrip_Latency_ms | Master_Aggregator | NodeID | Runtime_State |
+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
| 127.0.0.1 | 3306 | online | 0 | NULL | 1 | 4 | online |
| 192.168.1.116 | 3306 | online | 1 | 0.200 | 0 | 5 | online |
+---------------+-------+--------+--------------------+------------------------------+-------------------+--------+---------------+
2 rows in set (0.00 sec)Last modified: June 2, 2023