Back to Shardingsphere

Show Compute Node Info.Cn

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

5.5.31.7 KB
Original Source

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

描述

SHOW COMPUTE NODE INFO 语法用于查询当前 proxy 实例信息。

语法

{{< tabs >}} {{% tab name="语法" %}}

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

{{% /tab %}} {{% tab name="铁路图" %}}

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

返回值说明

说明
instance_idproxy 实例编号
host主机地址
port端口号
statusproxy 实例状态
mode_typeproxy 实例模式
worker_idworker id
labels标签
version版本

示例

  • 查询当前 proxy 实例信息
sql
SHOW COMPUTE NODE INFO;
sql
mysql> SHOW COMPUTE NODE INFO;
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)

保留字

SHOWCOMPUTENODEINFO

相关链接