SHOW COMPUTE NODES 语法用于查询计算节点信息。
ShowComputeNodes ::=
'SHOW' 'COMPUTE' 'NODES'
| 列 | 说明 |
|---|---|
| instance_id | 实例 id |
| instance_type | 实例类型 |
| host | 主机地址 |
| port | 端口号 |
| status | 实例状态 |
| mode_type | 模式类型 |
| worker_id | worker id |
| labels | 标签 |
| version | 版本 |
| database_name | 当前连接逻辑库（仅对 JDBC 生效） |
mysql> SHOW COMPUTE NODES;
+--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+--------------+
| instance_id | instance_type | host | port | status | mode_type | worker_id | labels | version | database_name |
+--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+--------------+
| 3e84d33e-cb97-42f2-b6ce-f78fea0ded89 | PROXY | 127.0.0.1 | 3307 | OK | Cluster | -1 | | 5.4.2 | logic_db |
+--------------------------------------+---------------+------------+------+--------+------------+-----------+--------+----------+--------------+
1 row in set (0.01 sec)
SHOW、COMPUTE、NODES