SHOW COMPUTE NODES

Description

The SHOW COMPUTE NODES syntax is used to query proxy instance information.

Syntax

Grammar Railroad diagram

  1. ShowComputeNodes ::=
  2.   'SHOW' 'COMPUTE' 'NODES'

Return Value Description

ColumnsDescription
instance_idproxy instance id
hosthost address
portport number
statusproxy instance status
mode_typeproxy instance mode
worker_idworker id
labelslabels
versionversion

Example

  • Query proxy instance information
  1. SHOW COMPUTE NODES;
  1. mysql> SHOW COMPUTE NODES;
  2. +--------------------------------------+---------------+------+--------+-----------+-----------+--------+---------+
  3. | instance_id                          | host          | port | status | mode_type | worker_id | labels | version |
  4. +--------------------------------------+---------------+------+--------+-----------+-----------+--------+---------+
  5. | 734bb036-b15d-4af0-be87-2372d8b6a0cd | 192.168.5.163 | 3307 | OK     | Cluster   | -1        |        | 5.3.0   |
  6. +--------------------------------------+---------------+------+--------+-----------+-----------+--------+---------+
  7. 1 row in set (0.01 sec)

Dedicated Terminology

SHOW, COMPUTE, NODES