ContextQMD
Back to Shardingsphere

Show Compute Node Info.En

docs/document/content/user-manual/shardingsphere-proxy/distsql/syntax/ral/show-compute-node-info.en.md

5.5.31.8 KB
Original Source

+++ title = "SHOW COMPUTE NODE INFO" weight = 5 +++

Description

The SHOW COMPUTE NODE INFO syntax is used to query current proxy instance information.

Syntax

{{< tabs >}} {{% tab name="Grammar" %}}

sql
ShowComputeNodeInfo ::=
  'SHOW' 'COMPUTE' 'NODE' 'INFO'

{{% /tab %}} {{% tab name="Railroad diagram" %}}

<iframe frameborder="0" name="diagram" id="diagram" width="100%" height="100%"></iframe> {{% /tab %}} {{< /tabs >}}

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 current proxy instance information
sql
SHOW COMPUTE NODE INFO;
sql
mysql> SHOW COMPUTE NODES;
+--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+
| instance_id                          | instance_type | host       | port | status | mode_type  | worker_id | labels | version  |
+--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+
| 3e84d33e-cb97-42f2-b6ce-f78fea0ded89 | PROXY         | 127.0.0.1  | 3307 | OK     | Cluster    | -1        |        | 5.4.2    |
+--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+
1 row in set (0.01 sec)

Reserved word

SHOW, COMPUTE, NODE, INFO