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)
