SingleStore DB

information_schema.AGGREGATORS

This table contains information about aggregators. It is useful for understanding the number and attributes of the aggregators for a given cluster.

Column Name

Description

HOST

The hostname or IP address for the related aggregator.

PORT

The port number of the related aggregator.

STATE

The current state of a given aggregator.

OPENED_CONNECTIONS

The number of connections opened on a given aggregator.

AVERAGE_ROUNDTRIP_LATENCY

The average ping roundtrip latency in milliseconds for a given aggregator.

MASTER_AGGREGATOR

If a given aggregator is in the role of master, this will be 1, otherwise 0.

ROLE

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

NODE_ID

The unique ID of a given aggregator node.