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