Important

Self-managed SingleStore will soon transition from version 9.1 RC to version 10. This new semantic versioning scheme will provide SingleStore with finer control over engine and feature releases that were not possible with the current versioning scheme.

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 prior to its general availability. Ahead of this transition, SingleStore 9.0 is recommended for production workloads, which can later be upgraded to SingleStore 10.

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)

SHOW LEAVES

On this page

Syntax

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?