This is an automated email from the ASF dual-hosted git repository.
diwu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 0664186efe fix doc (#16769)
0664186efe is described below
commit 0664186efe11a2c75ddfb4a7456a7cfd77b02f5e
Author: Liqf <109049295+lemonlit...@users.noreply.github.com>
AuthorDate: Wed Feb 15 13:25:31 2023 +0800
fix doc (#16769)
---
.../sql-reference/Show-Statements/SHOW-PROCESSLIST.md | 13 +++++++++++--
.../sql-reference/Show-Statements/SHOW-PROCESSLIST.md | 14 +++++++++++---
2 files changed, 22 insertions(+), 5 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
b/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
index 8f4fc67c79..c2800b4975 100644
--- a/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
+++ b/docs/en/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
@@ -47,11 +47,20 @@ illustrate:
- Host: Records the IP and port number of the client sending the request.
Through this information, when troubleshooting the problem, we can locate which
client and which process sent the request.
- Cluster: Cluster name
- DB: which database the currently executed command is on. If no database is
specified, the value is NULL .
-- Command: refers to the command that the thread is executing at the moment.
This is very complicated, and is explained separately below
+- Command: refers to the command that the thread is executing at the moment.
- Time: Indicates the time the thread is in the current state.
-- State: The state of the thread, corresponding to Command, explained
separately below.
+- State: The state of the thread, corresponding to Command.
- Info: Generally recorded is the statement executed by the thread. By
default, only the first 100 characters are displayed, that is, the statement
you see may be truncated. To see all the information, you need to use show full
processlist.
+Common Command types are as follows：
+
+- Query: The thread is executing a statement
+- Sleep: is waiting for a client to send it an execute statement
+- Quit: the thread is exiting
+- Kill : The kill statement is being executed to kill the specified thread
+
+Other types can refer to [MySQL official website for
explanation](https://dev.mysql.com/doc/refman/5.6/en/thread-commands.html)
+
### Example
1. View the threads running by the current user
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
index 1f9d3ed506..474e742b85 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Show-Statements/SHOW-PROCESSLIST.md
@@ -47,15 +47,23 @@ SHOW [FULL] PROCESSLIST
- Host: 记录了发送请求的客户端的 IP 和 端口号。通过这些信息在排查问题的时候，我们可以定位到是哪个客户端的哪个进程发送的请求。
- Cluster：集群名称
- DB: 当前执行的命令是在哪一个数据库上。如果没有指定数据库，则该值为 NULL 。
-- Command: 是指此刻该线程正在执行的命令。这个很复杂，下面单独解释
+- Command: 是指此刻该线程正在执行的命令。
- Time: 表示该线程处于当前状态的时间。
-- State: 线程的状态，和 Command 对应，下面单独解释。
+- State: 线程的状态，和 Command 对应。
- Info: 一般记录的是线程执行的语句。默认只显示前100个字符，也就是你看到的语句可能是截断了的，要看全部信息，需要使用 show full
processlist。
+常见的 Command 类型如下：
+
+- Query: 该线程正在执行一个语句
+- Sleep: 正在等待客户端向它发送执行语句
+- Quit: 该线程正在退出
+- Kill : 正在执行 kill 语句，杀死指定线程
+
+其他类型可以参考 [MySQL
官网解释](https://dev.mysql.com/doc/refman/5.6/en/thread-commands.html)
+
### Example
1. 查看当前用户尽在运行的线程
-
```SQL
SHOW PROCESSLIST
```
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
