SHOW AGGREGATORS

Show the aggregators in a cluster.

Syntax

SHOW AGGREGATORS [EXTENDED];

Remarks

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

Role

Whether a given aggregator is a master or child. This will be leader for master aggregators, and follower for children.

NodeID

The unique ID of a given aggregator node.

Runtime_State

Internal

SHOW AGGREGATORS EXTENDED

SHOW AGGREGATORS EXTENDED adds these additional columns:

Column

Description

Local_Minimum_Pre_Prepare_Ts

The timestamp of the coordinator's oldest distributed transaction.

Minimum_Pre_Prepare_Ts

The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves).

Availability_Group

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

Was this article helpful?