This is an automated email from the ASF dual-hosted git repository.
haonan pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new d526b743 add show services from 2082 (#1003)
d526b743 is described below
commit d526b743c0ce0bdb8385de94666b16b744362aeb
Author: leto-b <[email protected]>
AuthorDate: Tue Mar 31 17:08:55 2026 +0800
add show services from 2082 (#1003)
* add show services from 2082
* add update hint in the front
* fix link
* update version num
---
.../Table/Reference/System-Config-Manual_apache.md | 4 +-
.../Reference/System-Config-Manual_timecho.md | 4 +-
.../Master/Table/Reference/System-Tables_apache.md | 58 ++++++++++++++++------
.../Table/Reference/System-Tables_timecho.md | 55 +++++++++++++++-----
.../User-Manual/Maintenance-commands_apache.md | 30 ++++++++++-
.../User-Manual/Maintenance-commands_timecho.md | 28 +++++++++++
.../User-Manual/Maintenance-commands_apache.md | 29 +++++++++++
.../User-Manual/Maintenance-commands_timecho.md | 29 +++++++++++
.../Reference/System-Config-Manual_apache.md | 4 +-
.../Reference/System-Config-Manual_timecho.md | 4 +-
.../latest-Table/Reference/System-Tables_apache.md | 50 ++++++++++++++-----
.../Reference/System-Tables_timecho.md | 55 +++++++++++++++-----
.../User-Manual/Maintenance-commands_apache.md | 28 +++++++++++
.../User-Manual/Maintenance-commands_timecho.md | 28 +++++++++++
.../User-Manual/Maintenance-commands_apache.md | 29 +++++++++++
.../User-Manual/Maintenance-commands_timecho.md | 29 +++++++++++
.../Table/Reference/System-Config-Manual_apache.md | 12 ++---
.../Reference/System-Config-Manual_timecho.md | 12 ++---
.../Master/Table/Reference/System-Tables_apache.md | 35 +++++++++++--
.../Table/Reference/System-Tables_timecho.md | 30 ++++++++++-
.../User-Manual/Maintenance-statement_apache.md | 33 +++++++++++-
.../User-Manual/Maintenance-statement_timecho.md | 31 ++++++++++++
.../User-Manual/Maintenance-statement_apache.md | 31 ++++++++++++
.../User-Manual/Maintenance-statement_timecho.md | 31 ++++++++++++
.../Reference/System-Config-Manual_apache.md | 12 ++---
.../Reference/System-Config-Manual_timecho.md | 12 ++---
.../latest-Table/Reference/System-Tables_apache.md | 27 +++++++++-
.../Reference/System-Tables_timecho.md | 30 ++++++++++-
.../User-Manual/Maintenance-statement_apache.md | 31 ++++++++++++
.../User-Manual/Maintenance-statement_timecho.md | 31 ++++++++++++
.../User-Manual/Maintenance-statement_apache.md | 31 ++++++++++++
.../User-Manual/Maintenance-statement_timecho.md | 31 ++++++++++++
32 files changed, 790 insertions(+), 94 deletions(-)
diff --git
a/src/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
b/src/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
index 2aeddc93..2d71d982 100644
--- a/src/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
+++ b/src/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
@@ -1532,10 +1532,10 @@ The `iotdb-system.properties` file contains various
configurations for managing
- slow_query_threshold
| Name | slow_query_threshold |
-| ----------- | -------------------------------------- |
+| ----------- |----------------------------------------|
| Description | Time cost(ms) threshold for slow query |
| Type | long |
-| Default | 10000 |
+| Default | 3000 |
| Effective | Hot reload |
- query_cost_stat_window
diff --git
a/src/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
b/src/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
index 5f81aad5..f466cd72 100644
--- a/src/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
+++ b/src/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
@@ -1533,10 +1533,10 @@ The `iotdb-system.properties` file contains various
configurations for managing
- slow_query_threshold
| Name | slow_query_threshold |
-| ----------- | -------------------------------------- |
+| ----------- |----------------------------------------|
| Description | Time cost(ms) threshold for slow query |
| Type | long |
-| Default | 10000 |
+| Default | 3000 |
| Effective | Hot reload |
- query_cost_stat_window
diff --git a/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
b/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
index 2aa05d9f..01d10984 100644
--- a/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
+++ b/src/UserGuide/Master/Table/Reference/System-Tables_apache.md
@@ -57,6 +57,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +67,7 @@ IoTDB> show tables from information_schema
## 2. System Tables
-* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES` , `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`
(detailed descriptions in later sections)
+* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES` , `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`,
`SERVICES` (detailed descriptions in later sections)
* **Operations**: Read-only, only supports `SELECT`, `COUNT/SHOW DEVICES`,
`DESC`. Any modifications to table structure or content are not allowed and
will result in an error: `"The database 'information_schema' can only be
queried." `
* **Column Names**: System table column names are all lowercase by default
and separated by underscores (`_`).
@@ -343,7 +344,7 @@ IoTDB> select * from information_schema.topics
+----------+----------------------------------------------------------------+
```
-### 2.10 VIEWS Table
+### 2.10 VIEWS
> This system table is available starting from version V2.0.5.
@@ -369,9 +370,9 @@ IoTDB> select * from information_schema.views
```
-### 2.11 MODELS Table
+### 2.11 MODELS
-> This system table is available starting from version V 2.0.5 and has been
discontinued since version V 2.0.8.
+> This system table is available starting from version V 2.0.5 and has been
discontinued since version V 2.0.8-beta.
* Contains information about all models in the database.
* The table structure is as follows:
@@ -402,7 +403,7 @@ IoTDB> select * from information_schema.models where
model_type = 'BUILT_IN_FORE
```
-### 2.12 FUNCTIONS Table
+### 2.12 FUNCTIONS
> This system table is available starting from version V2.0.5.
@@ -434,7 +435,7 @@ IoTDB> select * from information_schema.functions where
function_type='built-in
```
-### 2.13 CONFIGURATIONS Table
+### 2.13 CONFIGURATIONS
> This system table is available starting from version V2.0.5.
@@ -473,7 +474,7 @@ IoTDB> select * from information_schema.configurations
```
-### 2.14 KEYWORDS Table
+### 2.14 KEYWORDS
> This system table is available starting from version V2.0.5.
@@ -506,7 +507,7 @@ IoTDB> select * from information_schema.keywords limit 10
```
-### 2.15 NODES Table
+### 2.15 NODES
> This system table is available starting from version V2.0.5.
@@ -538,7 +539,7 @@ IoTDB> select * from information_schema.nodes
```
-### 2.16 CONFIG\_NODES Table
+### 2.16 CONFIG\_NODES
> This system table is available starting from version V2.0.5.
@@ -564,7 +565,7 @@ IoTDB> select * from information_schema.config_nodes
```
-### 2.17 DATA\_NODES Table
+### 2.17 DATA\_NODES
> This system table is available starting from version V2.0.5.
@@ -594,9 +595,9 @@ IoTDB> select * from information_schema.data_nodes
+-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+
```
-### 2.18 CONNECTIONS Table
+### 2.18 CONNECTIONS
-> This system table is available starting from version V 2.0.8
+> This system table is available starting from version V 2.0.8-beta
* Contains all connections in the cluster.
* The table structure is as follows:
@@ -621,9 +622,9 @@ IoTDB> select * from information_schema.connections;
+-----------+-------+----------+---------+-----------------------------+---------+
```
-### 2.19 CURRENT_QUERIES Table
+### 2.19 CURRENT_QUERIES
-> This system table is available starting from version V 2.0.8
+> This system table is available starting from version V 2.0.8-beta
* Contains all queries whose execution end time falls within the range `[now()
- query_cost_stat_window, now())`, including currently executing queries. The
`query_cost_stat_window` parameter represents the query cost statistics window.
Its default value is 0 and can be configured via the `iotdb-system.properties`
configuration file.
* The table structure is as follows:
@@ -652,9 +653,9 @@ IoTDB> select * from information_schema.current_queries;
+-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+
```
-### 2.20 QUERIES_COSTS_HISTOGRAM Table
+### 2.20 QUERIES_COSTS_HISTOGRAM
-> This system table is available starting from version V 2.0.8
+> This system table is available starting from version V 2.0.8-beta
* Contains a histogram of query execution times within the past
`query_cost_stat_window` period (only statistics for completed SQL queries).
The `query_cost_stat_window` parameter represents the query cost statistics
window. Its default value is 0 and can be configured via the
`iotdb-system.properties` configuration file.
* The table structure is as follows:
@@ -686,6 +687,31 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
+------+----+-----------+
```
+### 2.21 SERVICES
+
+> This system table is available starting from version V 2.0.8-beta
+
+* Displays services (MQTT service, REST service) on all active DataNodes (with
RUNNING or READ-ONLY status).
+* Table structure:
+
+| Column Name | Data Type | Column Type | Description |
+|---------------|-----------|-------------|---------------------------------|
+| service_name | STRING | TAG | Service Name |
+| datanode_id | INT32 | ATTRIBUTE | DataNode ID where service runs |
+| state | STRING | ATTRIBUTE | Service status: RUNNING/STOPPED |
+
+
+* Query example:
+
+```sql
+IoTDB> SELECT * FROM information_schema.services
++------------+-----------+---------+
+|service_name|datanode_id|state |
++------------+-----------+---------+
+|MQTT |1 |STOPPED |
+|REST |1 |RUNNING |
++------------+-----------+---------+
+```
## 3. Permission Description
diff --git a/src/UserGuide/Master/Table/Reference/System-Tables_timecho.md
b/src/UserGuide/Master/Table/Reference/System-Tables_timecho.md
index 7bb37e58..b9850bb0 100644
--- a/src/UserGuide/Master/Table/Reference/System-Tables_timecho.md
+++ b/src/UserGuide/Master/Table/Reference/System-Tables_timecho.md
@@ -23,6 +23,10 @@
IoTDB has a built-in system database called `INFORMATION_SCHEMA`, which
contains a series of system tables for storing IoTDB runtime information (such
as currently executing SQL statements, etc.). Currently, the
`INFORMATION_SCHEMA` database only supports read operations.
+> 💡 **[V2.0.8.2 Version Update]**<br>
+> 👉 Added onw system tables: **[SERVICES](#_2-21-services)** (service status
management), enhancing cluster maintenance and performance analysis.
+
+
## 1. System Database
* **Name**: `INFORMATION_SCHEMA`
@@ -57,6 +61,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +71,7 @@ IoTDB> show tables from information_schema
## 2. System Tables
-* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES`, `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`
(detailed descriptions in later sections)
+* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES`, `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`,
`SERVICES` (detailed descriptions in later sections)
* **Operations**: Read-only, only supports `SELECT`, `COUNT/SHOW DEVICES`,
`DESC`. Any modifications to table structure or content are not allowed and
will result in an error: `"The database 'information_schema' can only be
queried." `
* **Column Names**: System table column names are all lowercase by default
and separated by underscores (`_`).
@@ -343,7 +348,7 @@ IoTDB> select * from information_schema.topics
+----------+----------------------------------------------------------------+
```
-### 2.10 VIEWS Table
+### 2.10 VIEWS
> This system table is available starting from version V2.0.5.
@@ -369,7 +374,7 @@ IoTDB> select * from information_schema.views
```
-### 2.11 MODELS Table
+### 2.11 MODELS
> This system table is available starting from version V 2.0.5 and has been
> discontinued since version V 2.0.8.
@@ -402,7 +407,7 @@ IoTDB> select * from information_schema.models where
model_type = 'BUILT_IN_FORE
```
-### 2.12 FUNCTIONS Table
+### 2.12 FUNCTIONS
> This system table is available starting from version V2.0.5.
@@ -434,7 +439,7 @@ IoTDB> select * from information_schema.functions where
function_type='built-in
```
-### 2.13 CONFIGURATIONS Table
+### 2.13 CONFIGURATIONS
> This system table is available starting from version V2.0.5.
@@ -473,7 +478,7 @@ IoTDB> select * from information_schema.configurations
```
-### 2.14 KEYWORDS Table
+### 2.14 KEYWORDS
> This system table is available starting from version V2.0.5.
@@ -506,7 +511,7 @@ IoTDB> select * from information_schema.keywords limit 10
```
-### 2.15 NODES Table
+### 2.15 NODES
> This system table is available starting from version V2.0.5.
@@ -538,7 +543,7 @@ IoTDB> select * from information_schema.nodes
```
-### 2.16 CONFIG\_NODES Table
+### 2.16 CONFIG\_NODES
> This system table is available starting from version V2.0.5.
@@ -564,7 +569,7 @@ IoTDB> select * from information_schema.config_nodes
```
-### 2.17 DATA\_NODES Table
+### 2.17 DATA\_NODES
> This system table is available starting from version V2.0.5.
@@ -594,7 +599,7 @@ IoTDB> select * from information_schema.data_nodes
+-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+
```
-### 2.18 CONNECTIONS Table
+### 2.18 CONNECTIONS
> This system table is available starting from version V 2.0.8
@@ -621,7 +626,7 @@ IoTDB> select * from information_schema.connections;
+-----------+-------+----------+---------+-----------------------------+---------+
```
-### 2.19 CURRENT_QUERIES Table
+### 2.19 CURRENT_QUERIES
> This system table is available starting from version V 2.0.8
@@ -652,7 +657,7 @@ IoTDB> select * from information_schema.current_queries;
+-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+
```
-### 2.20 QUERIES_COSTS_HISTOGRAM Table
+### 2.20 QUERIES_COSTS_HISTOGRAM
> This system table is available starting from version V 2.0.8
@@ -686,6 +691,32 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
+------+----+-----------+
```
+### 2.21 SERVICES
+
+> This system table is available starting from version V 2.0.8.2
+
+* Displays services (MQTT service, REST service) on all active DataNodes (with
RUNNING or READ-ONLY status).
+* Table structure:
+
+| Column Name | Data Type | Column Type | Description |
+|---------------|-----------|-------------|---------------------------------|
+| service_name | STRING | TAG | Service Name |
+| datanode_id | INT32 | ATTRIBUTE | DataNode ID where service runs |
+| state | STRING | ATTRIBUTE | Service status: RUNNING/STOPPED |
+
+
+* Query example:
+
+```sql
+IoTDB> SELECT * FROM information_schema.services
++------------+-----------+---------+
+|service_name|datanode_id|state |
++------------+-----------+---------+
+|MQTT |1 |STOPPED |
+|REST |1 |RUNNING |
++------------+-----------+---------+
+```
+
## 3. Permission Description
diff --git
a/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
index 659e7a5d..a91d8285 100644
--- a/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_apache.md
@@ -341,7 +341,7 @@ IoTDB> SHOW REGIONS
**Description**: Returns the RPC addresses and ports of all available
DataNodes in the current cluster. Note: A DataNode is considered "available" if
it is not in the REMOVING state.
-> This feature is supported starting from v2.0.8.
+> This feature is supported starting from v2.0.8-beta.
**Syntax**:
@@ -367,6 +367,34 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> Supported since V2.0.8-beta
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
## 2. Status Setting
diff --git
a/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_timecho.md
b/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_timecho.md
index 02185325..66a7444c 100644
--- a/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_timecho.md
+++ b/src/UserGuide/Master/Table/User-Manual/Maintenance-commands_timecho.md
@@ -367,6 +367,34 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> Supported since V2.0.8.2
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
## 2. Status Setting
diff --git
a/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
index e72ce52f..1ed8b852 100644
--- a/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_apache.md
@@ -273,6 +273,35 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> This feature is supported starting from v2.0.8-beta.
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
+
## 2. Status Setting
diff --git
a/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_timecho.md
b/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_timecho.md
index 78ab71b7..54259334 100644
--- a/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_timecho.md
+++ b/src/UserGuide/Master/Tree/User-Manual/Maintenance-commands_timecho.md
@@ -273,6 +273,35 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> This feature is supported starting from v2.0.8.2.
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
+
## 2. Status Setting
diff --git
a/src/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
b/src/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
index 2aeddc93..2d71d982 100644
--- a/src/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
+++ b/src/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
@@ -1532,10 +1532,10 @@ The `iotdb-system.properties` file contains various
configurations for managing
- slow_query_threshold
| Name | slow_query_threshold |
-| ----------- | -------------------------------------- |
+| ----------- |----------------------------------------|
| Description | Time cost(ms) threshold for slow query |
| Type | long |
-| Default | 10000 |
+| Default | 3000 |
| Effective | Hot reload |
- query_cost_stat_window
diff --git
a/src/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
b/src/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
index 5f81aad5..f466cd72 100644
--- a/src/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
+++ b/src/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
@@ -1533,10 +1533,10 @@ The `iotdb-system.properties` file contains various
configurations for managing
- slow_query_threshold
| Name | slow_query_threshold |
-| ----------- | -------------------------------------- |
+| ----------- |----------------------------------------|
| Description | Time cost(ms) threshold for slow query |
| Type | long |
-| Default | 10000 |
+| Default | 3000 |
| Effective | Hot reload |
- query_cost_stat_window
diff --git a/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
b/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
index a67792b5..01d10984 100644
--- a/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
+++ b/src/UserGuide/latest-Table/Reference/System-Tables_apache.md
@@ -57,6 +57,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +67,7 @@ IoTDB> show tables from information_schema
## 2. System Tables
-* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES` , `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`
(detailed descriptions in later sections)
+* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES` , `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`,
`SERVICES` (detailed descriptions in later sections)
* **Operations**: Read-only, only supports `SELECT`, `COUNT/SHOW DEVICES`,
`DESC`. Any modifications to table structure or content are not allowed and
will result in an error: `"The database 'information_schema' can only be
queried." `
* **Column Names**: System table column names are all lowercase by default
and separated by underscores (`_`).
@@ -343,7 +344,7 @@ IoTDB> select * from information_schema.topics
+----------+----------------------------------------------------------------+
```
-### 2.10 VIEWS Table
+### 2.10 VIEWS
> This system table is available starting from version V2.0.5.
@@ -369,7 +370,7 @@ IoTDB> select * from information_schema.views
```
-### 2.11 MODELS Table
+### 2.11 MODELS
> This system table is available starting from version V 2.0.5 and has been
> discontinued since version V 2.0.8-beta.
@@ -402,7 +403,7 @@ IoTDB> select * from information_schema.models where
model_type = 'BUILT_IN_FORE
```
-### 2.12 FUNCTIONS Table
+### 2.12 FUNCTIONS
> This system table is available starting from version V2.0.5.
@@ -434,7 +435,7 @@ IoTDB> select * from information_schema.functions where
function_type='built-in
```
-### 2.13 CONFIGURATIONS Table
+### 2.13 CONFIGURATIONS
> This system table is available starting from version V2.0.5.
@@ -473,7 +474,7 @@ IoTDB> select * from information_schema.configurations
```
-### 2.14 KEYWORDS Table
+### 2.14 KEYWORDS
> This system table is available starting from version V2.0.5.
@@ -506,7 +507,7 @@ IoTDB> select * from information_schema.keywords limit 10
```
-### 2.15 NODES Table
+### 2.15 NODES
> This system table is available starting from version V2.0.5.
@@ -538,7 +539,7 @@ IoTDB> select * from information_schema.nodes
```
-### 2.16 CONFIG\_NODES Table
+### 2.16 CONFIG\_NODES
> This system table is available starting from version V2.0.5.
@@ -564,7 +565,7 @@ IoTDB> select * from information_schema.config_nodes
```
-### 2.17 DATA\_NODES Table
+### 2.17 DATA\_NODES
> This system table is available starting from version V2.0.5.
@@ -594,7 +595,7 @@ IoTDB> select * from information_schema.data_nodes
+-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+
```
-### 2.18 CONNECTIONS Table
+### 2.18 CONNECTIONS
> This system table is available starting from version V 2.0.8-beta
@@ -621,7 +622,7 @@ IoTDB> select * from information_schema.connections;
+-----------+-------+----------+---------+-----------------------------+---------+
```
-### 2.19 CURRENT_QUERIES Table
+### 2.19 CURRENT_QUERIES
> This system table is available starting from version V 2.0.8-beta
@@ -652,7 +653,7 @@ IoTDB> select * from information_schema.current_queries;
+-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+
```
-### 2.20 QUERIES_COSTS_HISTOGRAM Table
+### 2.20 QUERIES_COSTS_HISTOGRAM
> This system table is available starting from version V 2.0.8-beta
@@ -686,6 +687,31 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
+------+----+-----------+
```
+### 2.21 SERVICES
+
+> This system table is available starting from version V 2.0.8-beta
+
+* Displays services (MQTT service, REST service) on all active DataNodes (with
RUNNING or READ-ONLY status).
+* Table structure:
+
+| Column Name | Data Type | Column Type | Description |
+|---------------|-----------|-------------|---------------------------------|
+| service_name | STRING | TAG | Service Name |
+| datanode_id | INT32 | ATTRIBUTE | DataNode ID where service runs |
+| state | STRING | ATTRIBUTE | Service status: RUNNING/STOPPED |
+
+
+* Query example:
+
+```sql
+IoTDB> SELECT * FROM information_schema.services
++------------+-----------+---------+
+|service_name|datanode_id|state |
++------------+-----------+---------+
+|MQTT |1 |STOPPED |
+|REST |1 |RUNNING |
++------------+-----------+---------+
+```
## 3. Permission Description
diff --git a/src/UserGuide/latest-Table/Reference/System-Tables_timecho.md
b/src/UserGuide/latest-Table/Reference/System-Tables_timecho.md
index 7bb37e58..b9850bb0 100644
--- a/src/UserGuide/latest-Table/Reference/System-Tables_timecho.md
+++ b/src/UserGuide/latest-Table/Reference/System-Tables_timecho.md
@@ -23,6 +23,10 @@
IoTDB has a built-in system database called `INFORMATION_SCHEMA`, which
contains a series of system tables for storing IoTDB runtime information (such
as currently executing SQL statements, etc.). Currently, the
`INFORMATION_SCHEMA` database only supports read operations.
+> 💡 **[V2.0.8.2 Version Update]**<br>
+> 👉 Added onw system tables: **[SERVICES](#_2-21-services)** (service status
management), enhancing cluster maintenance and performance analysis.
+
+
## 1. System Database
* **Name**: `INFORMATION_SCHEMA`
@@ -57,6 +61,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +71,7 @@ IoTDB> show tables from information_schema
## 2. System Tables
-* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES`, `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`
(detailed descriptions in later sections)
+* **Names**: `DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`,
`PIPES`, `PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`,
`FUNCTIONS`, `CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`,
`DATA_NODES`, `CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`,
`SERVICES` (detailed descriptions in later sections)
* **Operations**: Read-only, only supports `SELECT`, `COUNT/SHOW DEVICES`,
`DESC`. Any modifications to table structure or content are not allowed and
will result in an error: `"The database 'information_schema' can only be
queried." `
* **Column Names**: System table column names are all lowercase by default
and separated by underscores (`_`).
@@ -343,7 +348,7 @@ IoTDB> select * from information_schema.topics
+----------+----------------------------------------------------------------+
```
-### 2.10 VIEWS Table
+### 2.10 VIEWS
> This system table is available starting from version V2.0.5.
@@ -369,7 +374,7 @@ IoTDB> select * from information_schema.views
```
-### 2.11 MODELS Table
+### 2.11 MODELS
> This system table is available starting from version V 2.0.5 and has been
> discontinued since version V 2.0.8.
@@ -402,7 +407,7 @@ IoTDB> select * from information_schema.models where
model_type = 'BUILT_IN_FORE
```
-### 2.12 FUNCTIONS Table
+### 2.12 FUNCTIONS
> This system table is available starting from version V2.0.5.
@@ -434,7 +439,7 @@ IoTDB> select * from information_schema.functions where
function_type='built-in
```
-### 2.13 CONFIGURATIONS Table
+### 2.13 CONFIGURATIONS
> This system table is available starting from version V2.0.5.
@@ -473,7 +478,7 @@ IoTDB> select * from information_schema.configurations
```
-### 2.14 KEYWORDS Table
+### 2.14 KEYWORDS
> This system table is available starting from version V2.0.5.
@@ -506,7 +511,7 @@ IoTDB> select * from information_schema.keywords limit 10
```
-### 2.15 NODES Table
+### 2.15 NODES
> This system table is available starting from version V2.0.5.
@@ -538,7 +543,7 @@ IoTDB> select * from information_schema.nodes
```
-### 2.16 CONFIG\_NODES Table
+### 2.16 CONFIG\_NODES
> This system table is available starting from version V2.0.5.
@@ -564,7 +569,7 @@ IoTDB> select * from information_schema.config_nodes
```
-### 2.17 DATA\_NODES Table
+### 2.17 DATA\_NODES
> This system table is available starting from version V2.0.5.
@@ -594,7 +599,7 @@ IoTDB> select * from information_schema.data_nodes
+-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+
```
-### 2.18 CONNECTIONS Table
+### 2.18 CONNECTIONS
> This system table is available starting from version V 2.0.8
@@ -621,7 +626,7 @@ IoTDB> select * from information_schema.connections;
+-----------+-------+----------+---------+-----------------------------+---------+
```
-### 2.19 CURRENT_QUERIES Table
+### 2.19 CURRENT_QUERIES
> This system table is available starting from version V 2.0.8
@@ -652,7 +657,7 @@ IoTDB> select * from information_schema.current_queries;
+-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+
```
-### 2.20 QUERIES_COSTS_HISTOGRAM Table
+### 2.20 QUERIES_COSTS_HISTOGRAM
> This system table is available starting from version V 2.0.8
@@ -686,6 +691,32 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
+------+----+-----------+
```
+### 2.21 SERVICES
+
+> This system table is available starting from version V 2.0.8.2
+
+* Displays services (MQTT service, REST service) on all active DataNodes (with
RUNNING or READ-ONLY status).
+* Table structure:
+
+| Column Name | Data Type | Column Type | Description |
+|---------------|-----------|-------------|---------------------------------|
+| service_name | STRING | TAG | Service Name |
+| datanode_id | INT32 | ATTRIBUTE | DataNode ID where service runs |
+| state | STRING | ATTRIBUTE | Service status: RUNNING/STOPPED |
+
+
+* Query example:
+
+```sql
+IoTDB> SELECT * FROM information_schema.services
++------------+-----------+---------+
+|service_name|datanode_id|state |
++------------+-----------+---------+
+|MQTT |1 |STOPPED |
+|REST |1 |RUNNING |
++------------+-----------+---------+
+```
+
## 3. Permission Description
diff --git
a/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
index 4351cf4f..a91d8285 100644
--- a/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_apache.md
@@ -367,6 +367,34 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> Supported since V2.0.8-beta
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
## 2. Status Setting
diff --git
a/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_timecho.md
b/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_timecho.md
index 02185325..66a7444c 100644
--- a/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_timecho.md
+++ b/src/UserGuide/latest-Table/User-Manual/Maintenance-commands_timecho.md
@@ -367,6 +367,34 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> Supported since V2.0.8.2
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
## 2. Status Setting
diff --git a/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
b/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
index e72ce52f..1ed8b852 100644
--- a/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
+++ b/src/UserGuide/latest/User-Manual/Maintenance-commands_apache.md
@@ -273,6 +273,35 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> This feature is supported starting from v2.0.8-beta.
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
+
## 2. Status Setting
diff --git a/src/UserGuide/latest/User-Manual/Maintenance-commands_timecho.md
b/src/UserGuide/latest/User-Manual/Maintenance-commands_timecho.md
index 78ab71b7..54259334 100644
--- a/src/UserGuide/latest/User-Manual/Maintenance-commands_timecho.md
+++ b/src/UserGuide/latest/User-Manual/Maintenance-commands_timecho.md
@@ -273,6 +273,35 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 View Service Information
+
+**Description**: Returns service information (MQTT service, REST service) on
all active DataNodes (in RUNNING or READ-ONLY state) in the current cluster.
+
+> This feature is supported starting from v2.0.8.2.
+
+#### Syntax:
+```sql
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### Examples:
+```sql
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+Execution result:
+```sql
++--------------+-------------+---------+
+| Service Name | DataNode ID | State |
++--------------+-------------+---------+
+| MQTT | 1 | STOPPED |
+| REST | 1 | RUNNING |
++--------------+-------------+---------+
+```
+
## 2. Status Setting
diff --git
a/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
b/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
index 81ee6fd6..d5e203b4 100644
--- a/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
+++ b/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_apache.md
@@ -1508,12 +1508,12 @@ IoTDB 配置文件位于 IoTDB 安装目录:`conf`文件夹下。
- slow_query_threshold
-| 名字 | slow_query_threshold |
-| ------------ | ------------------------------ |
-| 描述 | 慢查询的时间阈值。单位:毫秒。 |
-| 类型 | long |
-| 默认值 | 10000 |
-| 改后生效方式 | 热加载 |
+| 名字 | slow_query_threshold |
+| ------------ |----------------------|
+| 描述 | 慢查询的时间阈值。单位:毫秒。 |
+| 类型 | long |
+| 默认值 | 3000 |
+| 改后生效方式 | 热加载 |
- query_cost_stat_window
diff --git
a/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
b/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
index 0f40285f..9e13fc7a 100644
--- a/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
+++ b/src/zh/UserGuide/Master/Table/Reference/System-Config-Manual_timecho.md
@@ -1508,12 +1508,12 @@ IoTDB 配置文件位于 IoTDB 安装目录:`conf`文件夹下。
- slow_query_threshold
-| 名字 | slow_query_threshold |
-| ------------ | ------------------------------ |
-| 描述 | 慢查询的时间阈值。单位:毫秒。 |
-| 类型 | long |
-| 默认值 | 10000 |
-| 改后生效方式 | 热加载 |
+| 名字 | slow_query_threshold |
+| ------------ |----------------------|
+| 描述 | 慢查询的时间阈值。单位:毫秒。 |
+| 类型 | long |
+| 默认值 | 3000 |
+| 改后生效方式 | 热加载 |
- query_cost_stat_window
diff --git a/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
b/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
index 418b08f6..44079527 100644
--- a/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
+++ b/src/zh/UserGuide/Master/Table/Reference/System-Tables_apache.md
@@ -57,6 +57,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +67,7 @@ IoTDB> show tables from information_schema
## 2. 系统表
-* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`(详细介绍见后面小节)
+* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`,
`QUERIES_COSTS_HISTOGRAM`、`SERVICES`(详细介绍见后面小节)
* 操作:只读,只支持`SELECT`, `COUNT/SHOW DEVICES`, `DESC`,不支持对于表结构 /
内容的任意修改,如果修改将会报错:`"The database 'information_schema' can only be queried"`
* 列名:系统表的列名均默认为小写,且用`_`分隔
@@ -369,7 +370,7 @@ IoTDB> select * from information_schema.views
### 2.11 MODELS 表
-> 该系统表从 V 2.0.5 版本开始提供,从V 2.0.8 版本开始不再提供
+> 该系统表从 V 2.0.5 版本开始提供,从V 2.0.8-beta 版本开始不再提供
* 包含数据库内所有的模型信息
* 表结构如下表所示:
@@ -589,7 +590,7 @@ IoTDB> select * from information_schema.data_nodes
### 2.18 CONNECTIONS 表
-> 该系统表从 V 2.0.8 版本开始提供
+> 该系统表从 V 2.0.8-beta 版本开始提供
* 包含集群中所有连接。
* 表结构如下表所示:
@@ -616,7 +617,7 @@ IoTDB> select * from information_schema.connections;
### 2.19 CURRENT\_QUERIES 表
-> 该系统表从 V 2.0.8 版本开始提供
+> 该系统表从 V 2.0.8-beta 版本开始提供
* 包含所有执行结束时间在 `[now() - query_cost_stat_window, now())`
范围内的所有查询,也包括当前正在执行的查询。其中`query_cost_stat_window `代表查询耗时统计的窗口,默认值为 0
,可通过配置文件`iotdb-system.properties`进行配置。
* 表结构如下表所示:
@@ -647,7 +648,7 @@ IoTDB> select * from information_schema.current_queries;
### 2.20 QUERIES\_COSTS\_HISTOGRAM 表
-> 该系统表从 V 2.0.8 版本开始提供
+> 该系统表从 V 2.0.8-beta 版本开始提供
* 包含过去 `query_cost_stat_window` 时间内的查询耗时的直方图(仅统计已经执行结束的
SQL),其中`query_cost_stat_window `代表查询耗时统计的窗口,默认值为 0
,可通过配置文件`iotdb-system.properties`进行配置。
* 表结构如下表所示:
@@ -678,6 +679,30 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
|[9,10)| 0| 1|
+------+----+-----------+
```
+### 2.21 SERVICES 表
+
+> 该系统表从 V 2.0.8-beta 版本开始提供
+
+* 可展示所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务(MQTT 服务、REST 服务)。
+* 表结构如下表所示:
+
+| 列名 | 数据类型 | 列类型 | 说明 |
+| --------------- | ---------- | ----------- | ------------------------------ |
+| service\_name | STRING | TAG | 服务名称 |
+| datanode\_id | INT32 | ATTRIBUTE | 所在 DataNode 的 ID |
+| state | STRING | ATTRIBUTE | 服务状态: RUNNING / STOPPED |
+
+* 查询示例:
+
+```SQL
+IoTDB> select * from information_schema.services
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 3. 权限说明
diff --git a/src/zh/UserGuide/Master/Table/Reference/System-Tables_timecho.md
b/src/zh/UserGuide/Master/Table/Reference/System-Tables_timecho.md
index e13fa2c5..1ba09895 100644
--- a/src/zh/UserGuide/Master/Table/Reference/System-Tables_timecho.md
+++ b/src/zh/UserGuide/Master/Table/Reference/System-Tables_timecho.md
@@ -23,6 +23,9 @@
IoTDB 内置系统数据库 `INFORMATION_SCHEMA`,其中包含一系列系统表,用于存储 IoTDB 运行时信息(如当前正在执行的 SQL
语句等)。目前`INFORMATION_SCHEMA`数据库只支持读操作。
+> 💡 **【V2.0.8.2 版本更新】**<br>
+> 👉 新增一张系统表:**[SERVICES](#_2-21-services-表)**(服务状态管理),助力集群运维与性能分析。
+
## 1. 系统库
* 名称:`INFORMATION_SCHEMA`
@@ -57,6 +60,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +70,7 @@ IoTDB> show tables from information_schema
## 2. 系统表
-* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`(详细介绍见后面小节)
+* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`,
`QUERIES_COSTS_HISTOGRAM`、`SERVICES`(详细介绍见后面小节)
* 操作:只读,只支持`SELECT`, `COUNT/SHOW DEVICES`, `DESC`,不支持对于表结构 /
内容的任意修改,如果修改将会报错:`"The database 'information_schema' can only be queried"`
* 列名:系统表的列名均默认为小写,且用`_`分隔
@@ -679,6 +683,30 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
+------+----+-----------+
```
+### 2.21 SERVICES 表
+
+> 该系统表从 V 2.0.8.2 版本开始提供
+
+* 可展示所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务(MQTT 服务、REST 服务)。
+* 表结构如下表所示:
+
+| 列名 | 数据类型 | 列类型 | 说明 |
+| --------------- | ---------- | ----------- | ------------------------------ |
+| service\_name | STRING | TAG | 服务名称 |
+| datanode\_id | INT32 | ATTRIBUTE | 所在 DataNode 的 ID |
+| state | STRING | ATTRIBUTE | 服务状态: RUNNING / STOPPED |
+
+* 查询示例:
+
+```SQL
+IoTDB> select * from information_schema.services
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 3. 权限说明
diff --git
a/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
index 8c74bea3..bcb9f733 100644
--- a/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_apache.md
@@ -340,7 +340,7 @@ IoTDB> SHOW REGIONS
**含义**:返回当前集群所有可用的 DataNode 的 RPC 地址和端口。注意:这里对于“可用”的定义为:处于非 REMOVING 状态的 DN 节点。
-> V2.0.8 起支持该功能
+> V2.0.8-beta 起支持该功能
#### 语法:
@@ -366,6 +366,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8-beta 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_timecho.md
b/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_timecho.md
index aadcb8b2..c7d11194 100644
--- a/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_timecho.md
+++ b/src/zh/UserGuide/Master/Table/User-Manual/Maintenance-statement_timecho.md
@@ -366,6 +366,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8.2 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
index 45b37b01..1cba1564 100644
--- a/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_apache.md
@@ -274,6 +274,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8-beta 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_timecho.md
b/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_timecho.md
index 93259a49..c5b369ca 100644
--- a/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_timecho.md
+++ b/src/zh/UserGuide/Master/Tree/User-Manual/Maintenance-statement_timecho.md
@@ -274,6 +274,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8.2 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
b/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
index 81ee6fd6..d5e203b4 100644
--- a/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
+++ b/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md
@@ -1508,12 +1508,12 @@ IoTDB 配置文件位于 IoTDB 安装目录:`conf`文件夹下。
- slow_query_threshold
-| 名字 | slow_query_threshold |
-| ------------ | ------------------------------ |
-| 描述 | 慢查询的时间阈值。单位:毫秒。 |
-| 类型 | long |
-| 默认值 | 10000 |
-| 改后生效方式 | 热加载 |
+| 名字 | slow_query_threshold |
+| ------------ |----------------------|
+| 描述 | 慢查询的时间阈值。单位:毫秒。 |
+| 类型 | long |
+| 默认值 | 3000 |
+| 改后生效方式 | 热加载 |
- query_cost_stat_window
diff --git
a/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
b/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
index 0f40285f..9e13fc7a 100644
--- a/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
+++ b/src/zh/UserGuide/latest-Table/Reference/System-Config-Manual_timecho.md
@@ -1508,12 +1508,12 @@ IoTDB 配置文件位于 IoTDB 安装目录:`conf`文件夹下。
- slow_query_threshold
-| 名字 | slow_query_threshold |
-| ------------ | ------------------------------ |
-| 描述 | 慢查询的时间阈值。单位:毫秒。 |
-| 类型 | long |
-| 默认值 | 10000 |
-| 改后生效方式 | 热加载 |
+| 名字 | slow_query_threshold |
+| ------------ |----------------------|
+| 描述 | 慢查询的时间阈值。单位:毫秒。 |
+| 类型 | long |
+| 默认值 | 3000 |
+| 改后生效方式 | 热加载 |
- query_cost_stat_window
diff --git a/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
b/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
index 0b8f5de6..44079527 100644
--- a/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
+++ b/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md
@@ -57,6 +57,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +67,7 @@ IoTDB> show tables from information_schema
## 2. 系统表
-* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`(详细介绍见后面小节)
+* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`,
`QUERIES_COSTS_HISTOGRAM`、`SERVICES`(详细介绍见后面小节)
* 操作:只读,只支持`SELECT`, `COUNT/SHOW DEVICES`, `DESC`,不支持对于表结构 /
内容的任意修改,如果修改将会报错:`"The database 'information_schema' can only be queried"`
* 列名:系统表的列名均默认为小写,且用`_`分隔
@@ -678,6 +679,30 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
|[9,10)| 0| 1|
+------+----+-----------+
```
+### 2.21 SERVICES 表
+
+> 该系统表从 V 2.0.8-beta 版本开始提供
+
+* 可展示所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务(MQTT 服务、REST 服务)。
+* 表结构如下表所示:
+
+| 列名 | 数据类型 | 列类型 | 说明 |
+| --------------- | ---------- | ----------- | ------------------------------ |
+| service\_name | STRING | TAG | 服务名称 |
+| datanode\_id | INT32 | ATTRIBUTE | 所在 DataNode 的 ID |
+| state | STRING | ATTRIBUTE | 服务状态: RUNNING / STOPPED |
+
+* 查询示例:
+
+```SQL
+IoTDB> select * from information_schema.services
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 3. 权限说明
diff --git a/src/zh/UserGuide/latest-Table/Reference/System-Tables_timecho.md
b/src/zh/UserGuide/latest-Table/Reference/System-Tables_timecho.md
index e13fa2c5..1ba09895 100644
--- a/src/zh/UserGuide/latest-Table/Reference/System-Tables_timecho.md
+++ b/src/zh/UserGuide/latest-Table/Reference/System-Tables_timecho.md
@@ -23,6 +23,9 @@
IoTDB 内置系统数据库 `INFORMATION_SCHEMA`,其中包含一系列系统表,用于存储 IoTDB 运行时信息(如当前正在执行的 SQL
语句等)。目前`INFORMATION_SCHEMA`数据库只支持读操作。
+> 💡 **【V2.0.8.2 版本更新】**<br>
+> 👉 新增一张系统表:**[SERVICES](#_2-21-services-表)**(服务状态管理),助力集群运维与性能分析。
+
## 1. 系统库
* 名称:`INFORMATION_SCHEMA`
@@ -57,6 +60,7 @@ IoTDB> show tables from information_schema
| queries| INF|
|queries_costs_histogram| INF|
| regions| INF|
+| services| INF|
| subscriptions| INF|
| tables| INF|
| topics| INF|
@@ -66,7 +70,7 @@ IoTDB> show tables from information_schema
## 2. 系统表
-* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`, `QUERIES_COSTS_HISTOGRAM`(详细介绍见后面小节)
+* 名称:`DATABASES`, `TABLES`, `REGIONS`, `QUERIES`, `COLUMNS`, `PIPES`,
`PIPE_PLUGINS`, `SUBSCRIPTION`, `TOPICS`, `VIEWS`, `MODELS`, `FUNCTIONS`,
`CONFIGURATIONS`, `KEYWORDS`, `NODES`, `CONFIG_NODES`, `DATA_NODES`,
`CONNECTIONS`, `CURRENT_QUERIES`,
`QUERIES_COSTS_HISTOGRAM`、`SERVICES`(详细介绍见后面小节)
* 操作:只读,只支持`SELECT`, `COUNT/SHOW DEVICES`, `DESC`,不支持对于表结构 /
内容的任意修改,如果修改将会报错:`"The database 'information_schema' can only be queried"`
* 列名:系统表的列名均默认为小写,且用`_`分隔
@@ -679,6 +683,30 @@ IoTDB> select * from
information_schema.queries_costs_histogram limit 10
+------+----+-----------+
```
+### 2.21 SERVICES 表
+
+> 该系统表从 V 2.0.8.2 版本开始提供
+
+* 可展示所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务(MQTT 服务、REST 服务)。
+* 表结构如下表所示:
+
+| 列名 | 数据类型 | 列类型 | 说明 |
+| --------------- | ---------- | ----------- | ------------------------------ |
+| service\_name | STRING | TAG | 服务名称 |
+| datanode\_id | INT32 | ATTRIBUTE | 所在 DataNode 的 ID |
+| state | STRING | ATTRIBUTE | 服务状态: RUNNING / STOPPED |
+
+* 查询示例:
+
+```SQL
+IoTDB> select * from information_schema.services
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 3. 权限说明
diff --git
a/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
index 15da30a0..bcb9f733 100644
--- a/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_apache.md
@@ -366,6 +366,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8-beta 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_timecho.md
b/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_timecho.md
index aadcb8b2..c7d11194 100644
--- a/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_timecho.md
+++ b/src/zh/UserGuide/latest-Table/User-Manual/Maintenance-statement_timecho.md
@@ -366,6 +366,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.11 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8.2 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
b/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
index 45b37b01..1cba1564 100644
--- a/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
+++ b/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_apache.md
@@ -274,6 +274,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8-beta 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置
diff --git
a/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_timecho.md
b/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_timecho.md
index 93259a49..c5b369ca 100644
--- a/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_timecho.md
+++ b/src/zh/UserGuide/latest/User-Manual/Maintenance-statement_timecho.md
@@ -274,6 +274,37 @@ IoTDB> SHOW AVAILABLE URLS
+----------+-------+
```
+### 1.8 查看服务信息
+
+**含义**:返回当前集群所有正常工作(RUNNING 或 READ-ONLY) DN 上的服务信息(MQTT 服务、REST 服务)。
+
+> V2.0.8.2 起支持该功能
+
+#### 语法:
+
+```SQL
+showServicesStatement
+ : SHOW SERVICES <ON dataNodeId>
+ ;
+```
+
+#### 示例:
+
+```SQL
+IoTDB> SHOW SERVICES
+IoTDB> SHOW SERVICES ON 1
+```
+
+执行结果如下:
+
+```SQL
++------------+-----------+-------+
+|service_name|datanode_id| state|
++------------+-----------+-------+
+| MQTT| 1|STOPPED|
+| REST| 1|RUNNING|
++------------+-----------+-------+
+```
## 2. 状态设置