SHOW LEAVES
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. This is set by engine variable |
| The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves). |
| Internal |
Remarks
See 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)