SHOW AGGREGATORS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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