Outdated Version

You are viewing an older version of this section. View current production version.

SHOW LEAVES

Info

MemSQL Helios 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

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)