This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 47337af3c8b [fix] fix the docs of command 'show proc '/statistic''
(#161)
47337af3c8b is described below
commit 47337af3c8bf9e66d01b639a38a0ef983efd41fb
Author: Hong Liu <844981...@qq.com>
AuthorDate: Tue Nov 15 15:35:04 2022 +0800
[fix] fix the docs of command 'show proc '/statistic'' (#161)
* fix the docs of command 'show proc '/statistic''
---
docs/faq/install-faq.md | 4 ++--
.../ADMIN-CHECK-TABLET.md | 25 ++++++++++++----------
.../sql-reference/Show-Statements/SHOW-PROC.md | 12 +++++------
.../current/faq/install-faq.md | 4 ++--
.../ADMIN-CHECK-TABLET.md | 2 +-
.../sql-reference/Show-Statements/SHOW-PROC.md | 12 +++++------
6 files changed, 31 insertions(+), 28 deletions(-)
diff --git a/docs/faq/install-faq.md b/docs/faq/install-faq.md
index 93f6bd00582..7d0fd22abf4 100644
--- a/docs/faq/install-faq.md
+++ b/docs/faq/install-faq.md
@@ -35,9 +35,9 @@ This document is mainly used to record the common problems of
operation and main
During the offline process, use show backends to view the tabletNum of the
offline node, and you will observe that the number of tabletNum is decreasing,
indicating that data shards are being migrated from this node. When the number
is reduced to 0, the system will automatically delete the node. But in some
cases, tabletNum will not change after it drops to a certain value. This is
usually possible for two reasons:
1. The tablets belong to the table, partition, or materialized view that was
just dropped. Objects that have just been deleted remain in the recycle bin.
The offline logic will not process these shards. The time an object resides in
the recycle bin can be modified by modifying the FE configuration parameter
catalog_trash_expire_second. These tablets are disposed of when the object is
removed from the recycle bin.
-2. There is a problem with the migration task for these tablets. At this
point, you need to view the errors of specific tasks through show proc
"/cluster_balance".
+2. There is a problem with the migration task for these tablets. At this
point, you need to view the errors of specific tasks through `show proc
"/cluster_balance"`.
-For the above situation, you can first check whether there are unhealthy
shards in the cluster through show proc "/statistic". If it is 0, you can
delete the BE directly through the drop backend statement. Otherwise, you also
need to check the replicas of unhealthy shards in detail.
+For the above situation, you can first check whether there are unhealthy
shards in the cluster through `show proc "/cluster_health/tablet_health";`. If
it is 0, you can delete the BE directly through the drop backend statement.
Otherwise, you also need to check the replicas of unhealthy shards in detail.
### Q2. How should priorty_network be set?
diff --git
a/docs/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
b/docs/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
index 2caf6a144a2..f0a703b0794 100644
---
a/docs/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
+++
b/docs/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
@@ -28,31 +28,34 @@ under the License.
### Name
-ADMIN CLEAN TRASH
+ADMIN CHECK TABLET
### Description
-This statement is used to clean up garbage data in the backend
+This statement is used to perform the specified check operation on a set of
tablets.
grammar:
```sql
-ADMIN CLEAN TRASH [ON ("BackendHost1:BackendHeartBeatPort1",
"BackendHost2:BackendHeartBeatPort2", ...)];
-````
+ADMIN CHECK TABLE (tablet_id1, tablet_id2, ...)
+PROPERTIES("type" = "...");
+```
illustrate:
-1. Use BackendHost:BackendHeartBeatPort to indicate the backend that needs to
be cleaned up, and clean up all backends without adding the on limit.
+1. A list of tablet ids must be specified along with the type property in
PROPERTIES.
+2. Type only supports:
-### Example
-
-1. Clean up the junk data of all be nodes.
+ * consistency: Check the consistency of the replica of the tablet. This
command is an asynchronous command. After sending, Doris will start to execute
the consistency check job of the corresponding tablet. The final result will be
reflected in the InconsistentTabletNum column in the result of `SHOW PROC
"/cluster_health/tablet_health";`.
+
- ADMIN CLEAN TRASH;
+### Example
-2. Clean up the junk data of '192.168.0.1:9050' and '192.168.0.2:9050'.
+1. Perform a replica data consistency check on a specified set of tablets.
- ADMIN CLEAN TRASH ON ("192.168.0.1:9050","192.168.0.2:9050");
+ ```
+ ADMIN CHECK TABLET (10000, 10001) PROPERTIES("type" = "consistency");
+ ```
### Keywords
diff --git a/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
b/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
index 9409d76246f..555ad2d92ed 100644
--- a/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
+++ b/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
@@ -120,12 +120,12 @@ mysql> show proc "/dbs/10002";
```sql
mysql> show proc '/statistic';
-
+-------+----------------------+----------+--------------+----------+-----------+------------+--------------------+-----------------------+------------------+--------------+
- | DbId | DbName | TableNum | PartitionNum | IndexNum |
TabletNum | ReplicaNum | UnhealthyTabletNum | InconsistentTabletNum |
CloningTabletNum | BadTabletNum |
-
+-------+----------------------+----------+--------------+----------+-----------+------------+--------------------+-----------------------+------------------+--------------+
- | 10002 | default_cluster:test | 4 | 12 | 12 | 21
| 21 | 0 | 0 | 0
| 0 |
- | Total | 1 | 4 | 12 | 12 | 21
| 21 | 0 | 0 | 0
| 0 |
-
+-------+----------------------+----------+--------------+----------+-----------+------------+--------------------+-----------------------+------------------+--------------+
+
+-------+----------------------+----------+--------------+----------+-----------+------------+
+ | DbId | DbName | TableNum | PartitionNum | IndexNum |
TabletNum | ReplicaNum |
+
+-------+----------------------+----------+--------------+----------+-----------+------------+
+ | 10005 | default_cluster:test | 3 | 3 | 4 | 40
| 60 |
+ | Total | 1 | 3 | 3 | 4 | 40
| 60 |
+
+-------+----------------------+----------+--------------+----------+-----------+------------+
2 rows in set (0.00 sec)
````
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/install-faq.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/install-faq.md
index bdace4f478b..82eb58bd8f1 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/install-faq.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/install-faq.md
@@ -35,9 +35,9 @@ under the License.
在下线过程中，通过 show backends 查看下线节点的 tabletNum ，会观察到 tabletNum
数量在减少，说明数据分片正在从这个节点迁移走。当数量减到0时，系统会自动删除这个节点。但某些情况下，tabletNum
下降到一定数值后就不变化。这通常可能有以下两种原因：
1. 这些 tablet 属于刚被删除的表、分区或物化视图。而刚被删除的对象会保留在回收站中。而下线逻辑不会处理这些分片。可以通过修改 FE 的配置参数
catalog_trash_expire_second 来修改对象在回收站中驻留的时间。当对象从回收站中被删除后，这些 tablet就会被处理了。
-2. 这些 tablet 的迁移任务出现了问题。此时需要通过 show proc "/cluster_balance" 来查看具体任务的错误了。
+2. 这些 tablet 的迁移任务出现了问题。此时需要通过 `show proc "/cluster_balance"` 来查看具体任务的错误了。
-对于以上情况，可以先通过 show proc "/statistic" 查看集群是否还有 unhealthy 的分片，如果为0，则可以直接通过 drop
backend 语句删除这个 BE 。否则，还需要具体查看不健康分片的副本情况。
+对于以上情况，可以先通过 `show proc "/cluster_health/tablet_health";` 查看集群是否还有 unhealthy
的分片，如果为0，则可以直接通过 drop backend 语句删除这个 BE 。否则，还需要具体查看不健康分片的副本情况。
### Q2. priorty_network 应该如何设置？
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
index 879fa9707c9..edfa4ed3f0f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
@@ -46,7 +46,7 @@ PROPERTIES("type" = "...");
1. 必须指定 tablet id 列表以及 PROPERTIES 中的 type 属性。
2. 目前 type 仅支持：
- * consistency: 对tablet的副本数据一致性进行检查。该命令为异步命令，发送后，Doris 会开始执行对应 tablet
的一致性检查作业。最终的结果，将体现在 `SHOW PROC "/statistic";` 结果中的 InconsistentTabletNum 列。
+ * consistency: 对tablet的副本数据一致性进行检查。该命令为异步命令，发送后，Doris 会开始执行对应 tablet
的一致性检查作业。最终的结果，将体现在 `SHOW PROC "/cluster_health/tablet_health";` 结果中的
InconsistentTabletNum 列。
### Example
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
index 87e094fa11f..127f5967d13 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Show-Statements/SHOW-PROC.md
@@ -120,12 +120,12 @@ mysql> show proc "/dbs/10002";
```sql
mysql> show proc '/statistic';
-
+-------+----------------------+----------+--------------+----------+-----------+------------+--------------------+-----------------------+------------------+--------------+
- | DbId | DbName | TableNum | PartitionNum | IndexNum |
TabletNum | ReplicaNum | UnhealthyTabletNum | InconsistentTabletNum |
CloningTabletNum | BadTabletNum |
-
+-------+----------------------+----------+--------------+----------+-----------+------------+--------------------+-----------------------+------------------+--------------+
- | 10002 | default_cluster:test | 4 | 12 | 12 | 21
| 21 | 0 | 0 | 0
| 0 |
- | Total | 1 | 4 | 12 | 12 | 21
| 21 | 0 | 0 | 0
| 0 |
-
+-------+----------------------+----------+--------------+----------+-----------+------------+--------------------+-----------------------+------------------+--------------+
+
+-------+----------------------+----------+--------------+----------+-----------+------------+
+ | DbId | DbName | TableNum | PartitionNum | IndexNum |
TabletNum | ReplicaNum |
+
+-------+----------------------+----------+--------------+----------+-----------+------------+
+ | 10005 | default_cluster:test | 3 | 3 | 4 | 40
| 60 |
+ | Total | 1 | 3 | 3 | 4 | 40
| 60 |
+
+-------+----------------------+----------+--------------+----------+-----------+------------+
2 rows in set (0.00 sec)
```
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
