Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

SHOW AGGREGATORS

The SHOW AGGREGATORS command shows 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:

Was this article helpful?