Important
Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.
SHOW AGGREGATORS
On this page
The SHOW AGGREGATORS command shows the aggregators in a cluster.
Syntax
SHOW AGGREGATORS [EXTENDED];
Remarks
-
Refer to the Permissions Matrix for the required permissions.
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: