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.
SHOW LEAVES
On this page
Shows the leaves in a cluster.
Syntax
SHOW LEAVES;
Output
Column |
Description |
---|---|
|
Host name or IP address |
|
Port number |
|
Availability group to which this leaf belongs |
|
Pair host |
|
Pair port |
|
Leaf state (see Leaf States) |
|
Number of opened connections |
|
Average round-trip latency in milliseconds, calculated as |
|
The unique |
|
Time left for the node to recover after failing and coming back online. |
|
The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves). |
|
Internal |
Remarks
-
Refer to the Permission Matrix for the required permission.
Example
SHOW LEAVES;
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+------------------------------+
| Host | Port | Availability_Group | Pair_Host | Pair_Port | State | Opened_Connections | Average_Roundtrip_Latency_ms |
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+------------------------------+
| 192.168.1.110 | 3306 | 1 | 192.168.1.112 | 3306 | online | 5 | 0.299 |
| 192.168.1.111 | 3306 | 1 | 192.168.1.113 | 3306 | online | 5 | 0.293 |
| 192.168.1.112 | 3306 | 2 | 192.168.1.110 | 3306 | online | 1 | 0.271 |
| 192.168.1.113 | 3306 | 2 | 192.168.1.111 | 3306 | online | 1 | 0.264 |
+---------------+-------+--------------------+---------------+-----------+--------+--------------------+------------------------------+
4 rows in set (0.00 sec)
Last modified: July 31, 2023