SHOW COMPUTE NODES

Description

The SHOW COMPUTE NODES syntax is used to query compute nodes information.

Syntax

Grammar Railroad diagram

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

Return Value Description

ColumnsDescription
instance_idinstance id
instance_typeinstance type
hosthost
portport
statusstatus
mode_typemode type
worker_idworker id
labelslabels
versionversion

Example

  1. mysql> SHOW COMPUTE NODES;
  2. +--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+
  3. | instance_id                          | instance_type | host       | port | status | mode_type  | worker_id | labels | version  |
  4. +--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+
  5. | 3e84d33e-cb97-42f2-b6ce-f78fea0ded89 | PROXY         | 127.0.0.1  | 3307 | OK     | Cluster    | -1        |        | 5.4.2    |
  6. +--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+
  7. 1 row in set (0.01 sec)

Dedicated Terminology

SHOW, COMPUTE, NODES