Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

SHOW LEAVES

Syntax

SQL

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

Refer to the Permissions Matrix for the required permissions.

Example

SQL

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)