Outdated Version
You are viewing an older version of this section. View current production version.
SHOW LEAVES
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
memsql> 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)
