This is an automated email from the ASF dual-hosted git repository.
tuichenchuxin pushed a commit to branch revert-21494-zc1011-showprocess-doc
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
commit cb219cb3c31bf19a1c233d9dce6372f60fc99fac
Author: Chuxin Chen <ch...@qq.com>
AuthorDate: Tue Oct 11 16:38:24 2022 +0800
Revert "Add show processlist document (#21494)"
This reverts commit 2d6581563acd01179b7df0b05d8e57398fa7585e.
---
.../show-processlist/_index.cn.md | 38 ----------------------
.../show-processlist/_index.en.md | 37 ---------------------
2 files changed, 75 deletions(-)
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/show-processlist/_index.cn.md b/docs/document/content/user-manual/shardingsphere-proxy/show-processlist/_index.cn.md
deleted file mode 100644
index 853959c3cc2..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/show-processlist/_index.cn.md
+++ /dev/null
@@ -1,38 +0,0 @@
-+++
-title = "会话管理"
-weight = 5
-+++
-
-ShardingSphere 支持会话管理，可通过原生数据库的 SQL 查看当前会话或杀掉会话。目前此功能仅限于存储节点为 MySQL 的情况，支持 MySQL `SHOW PROCESSLIST` 命令和 `KILL` 命令。
-
-## 相关操作
-
-### 查看会话
-
-针对不同关联数据库支持不同的查看会话方法，关联 MySQL 数据库可使用 `SHOW PROCESSLIST` 命令查看会话。ShardingSphere 会自动生成唯一的 UUID 标识作为 ID，并将 SQL 执行信息存储在各个实例中。当执行此命令时，ShardingSphere 会通过治理中心收集并同步各个计算节点的 SQL 执行信息，然后汇总返回给用户。
-
-```
-mysql> show processlist;
-+----------------------------------+------+-----------+-------------+---------+------+---------------+------------------+
-| Id | User | Host | db | Command | Time | State | Info |
-+----------------------------------+------+-----------+-------------+---------+------+---------------+------------------+
-| 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select sleep(10) |
-| f9e5c97431567415fe10badc5fa46378 | root | 127.0.0.1 | sharding_db | Sleep | 690 | | |
-+----------------------------------+------+-----------+-------------+---------+------+---------------+------------------+
-```
-
-- 输出说明
-
-模拟原生 MySQL 的输出，但 `Id` 字段较为特殊为随机字符串。
-
-### 杀掉会话
-
-用户根据 `SHOW PROCESSLIST` 返回的结果，判断是否需要执行 `KILL` 语句，ShardingSphere 会根据 `KILL` 语句中的 ID 取消正在执行中的 SQL。
-
-```
-mysql> kill 05ede3bd584fd4a429dcaac382be2973;
-Query OK, 0 rows affected (0.04 sec)
-
-mysql> show processlist;
-Empty set (0.02 sec)
-```
diff --git a/docs/document/content/user-manual/shardingsphere-proxy/show-processlist/_index.en.md b/docs/document/content/user-manual/shardingsphere-proxy/show-processlist/_index.en.md
deleted file mode 100644
index b9d42b3e40c..00000000000
--- a/docs/document/content/user-manual/shardingsphere-proxy/show-processlist/_index.en.md
+++ /dev/null
@@ -1,37 +0,0 @@
-+++
-title = "Session Management"
-weight = 5
-+++
-
-ShardingSphere supports session management. You can view the current session or kill the session through the SQL of the native database. At present, this function is only available when the storage node is MySQL. MySQL `SHOW PROCESSLIST` and `KILL` commands are supported.
-
-## Usage
-### View Session
-
-Different methods of viewing sessions are supported for different associated databases. The `SHOW PROCESSLIST` command can be used to view sessions for associated MySQL databases. ShardingSphere will automatically generate a unique UUID ID as the ID, and store the SQL execution information in each instance. When this command is executed, ShardingSphere will collect and synchronize the SQL execution information of each computing node through the governance center, and then summarize and r [...]
-
-```
-mysql> show processlist;
-+----------------------------------+------+-----------+-------------+---------+------+---------------+------------------+
-| Id | User | Host | db | Command | Time | State | Info |
-+----------------------------------+------+-----------+-------------+---------+------+---------------+------------------+
-| 05ede3bd584fd4a429dcaac382be2973 | root | 127.0.0.1 | sharding_db | Execute | 2 | Executing 0/1 | select sleep(10) |
-| f9e5c97431567415fe10badc5fa46378 | root | 127.0.0.1 | sharding_db | Sleep | 690 | | |
-+----------------------------------+------+-----------+-------------+---------+------+---------------+------------------+
-```
-
-- Output Description
-
-Simulates the output of native MySQL, but the `Id` field is a special random string.
-
-### Kill Session
-
-The user determines whether the `KILL` statement needs to be executed according to the results returned by `SHOW PROCESSLIST`. ShardingSphere cancels the SQL being executed according to the ID in the `KILL` statement.
-
-```
-mysql> kill 05ede3bd584fd4a429dcaac382be2973;
-Query OK, 0 rows affected (0.04 sec)
-
-mysql> show processlist;
-Empty set (0.02 sec)
-```