SHOW LEAVES

Shows the leaves in a cluster.

Syntax

SHOW LEAVES;

Output

Column

Description

Host

Host name or IP address

Port

Port number

Availability_Group

Availability group to which this leaf belongs

Pair_Host

Pair host

Pair_Port

Pair port

State

Leaf state (see Leaf States)

Opened_Connections

Number of opened connections

Average_Roundtrip_Latency_ms

Average round-trip latency in milliseconds, calculated as SELECT 1 from the master aggregator to the leaf

NodeId

The unique ID of a given leaf node.

Grace_Period_in_Seconds

Time left for the node to recover after failing and coming back online. This is set by engine variable failover_initial_grace_interval_seconds

Minimum_Pre_Prepare_Ts

The timestamp of the cluster-wide oldest distributed transaction among all participants (master aggregator and leaves).

Runtime_State

Internal

Remarks

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

Was this article helpful?