ContextQMD
Back to Shardingsphere

Show Compute Node Mode.En

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

5.5.32.0 KB
Original Source

+++ title = "SHOW COMPUTE NODE MODE" weight = 6 +++

Description

The SHOW COMPUTE NODE MODE syntax is used to query current proxy instance mode configuration information.

Syntax

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

sql
ShowComputeNodeMode ::=
  'SHOW' 'COMPUTE' 'NODE' 'MODE'

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

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

Return Value Description

ColumnsDescription
typetype of proxy mode configuration
repositorytype of persist repository
propsproperties of persist repository

Example

  • Query current proxy instance mode configuration information
sql
SHOW COMPUTE NODE MODE;
sql
mysql> SHOW COMPUTE NODE MODE;
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| type    | repository | props                                                                                                                                                                  |
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Cluster | ZooKeeper  | {"operationTimeoutMilliseconds":500,"timeToLiveSeconds":60,"maxRetries":3,"namespace":"governance_ds","server-lists":"localhost:2181","retryIntervalMilliseconds":500} |
+---------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Reserved word

SHOW, COMPUTE, NODE, MODE