SHOW LEAVES

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

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 Permission Matrix for the required permission.

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)