Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SHOW LEAVES

Info

SingleStore Managed Service does not support this command.

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

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)