You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2022/04/14 01:02:39 UTC
[incubator-doris] branch master updated: [refactor][Doc] Database admin sql help (#9009)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 4cfb372387 [refactor][Doc] Database admin sql help (#9009)
4cfb372387 is described below
commit 4cfb372387024f2da87177d02927ff36ed53aded
Author: jiafeng.zhang <zh...@gmail.com>
AuthorDate: Thu Apr 14 09:02:33 2022 +0800
[refactor][Doc] Database admin sql help (#9009)
* Add SQL function Chinese documentation
Add SQL function Chinese documentation
* Add database management SQL help documentation
Add database management SQL help documentation
---
.../ADMIN-CANCEL-REPAIR.md | 22 +++++++++
.../ADMIN-CHECK-TABLET.md | 24 ++++++++++
...ADMIN-CANCEL-REPAIR.md => ADMIN-CLEAN-TRASH.md} | 31 ++++++++++---
.../ADMIN-REPAIR-TABLE.md | 25 +++++++++++
.../ADMIN-SET-CONFIG.md | 17 +++++++
.../ADMIN-SET-REPLICA-STATUS.md | 41 +++++++++++++++++
.../ADMIN-SHOW-CONFIG.md | 39 ++++++++++++++++
.../ADMIN-SHOW-REPLICA-DISTRIBUTION.md | 28 ++++++++++++
.../ADMIN-SHOW-REPLICA-STATUS.md | 45 +++++++++++++++++++
.../INSTALL-PLUGIN.md | 42 +++++++++++++++++
.../Database-Administration-Statements/KILL.md | 14 ++++++
.../Database-Administration-Statements/RECOVER.md | 52 ++++++++++++++++++++++
.../SET-VARIABLE.md | 52 ++++++++++++++++++++++
.../UNINSTALL-PLUGIN.md | 22 +++++++++
.../ADMIN-CANCEL-REPAIR.md | 22 +++++++++
.../ADMIN-CHECK-TABLET.md | 26 +++++++++++
...ADMIN-CANCEL-REPAIR.md => ADMIN-CLEAN-TRASH.md} | 31 +++++++++++--
.../ADMIN-REPAIR-TABLE.md | 25 +++++++++++
.../ADMIN-SET-CONFIG.md | 17 +++++++
.../ADMIN-SET-REPLICA-STATUS.md | 41 +++++++++++++++++
.../ADMIN-SHOW-CONFIG.md | 39 ++++++++++++++++
.../ADMIN-SHOW-REPLICA-DISTRIBUTION.md | 28 ++++++++++++
.../ADMIN-SHOW-REPLICA-STATUS.md | 45 +++++++++++++++++++
.../INSTALL-PLUGIN.md | 42 +++++++++++++++++
.../Database-Administration-Statements/KILL.md | 14 ++++++
.../Database-Administration-Statements/RECOVER.md | 49 ++++++++++++++++++++
.../SET-VARIABLE.md | 52 ++++++++++++++++++++++
.../UNINSTALL-PLUGIN.md | 22 +++++++++
28 files changed, 899 insertions(+), 8 deletions(-)
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
index 33eaed0cce..ab7e1f77aa 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
@@ -26,10 +26,32 @@ under the License.
## ADMIN-CANCEL-REPAIR
+### Name
+
+ADMIN CANCEL REPAIR
+
### Description
+This statement is used to cancel the repair of the specified table or partition with high priority
+
+grammar:
+
+```sql
+ADMIN CANCEL REPAIR TABLE table_name[ PARTITION (p1,...)];
+````
+
+illustrate:
+
+1. This statement simply means that the system will no longer repair shard copies of the specified table or partition with high priority. Replicas are still repaired with the default schedule.
+
### Example
+ 1. Cancel high priority repair
+
+ ```sql
+ ADMIN CANCEL REPAIR TABLE tbl PARTITION(p1);
+ ````
+
### Keywords
ADMIN, CANCEL, REPAIR
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
index 97aaa56b51..2caf6a144a 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
@@ -26,10 +26,34 @@ under the License.
## ADMIN-CHECK-TABLET
+### Name
+
+ADMIN CLEAN TRASH
+
### Description
+This statement is used to clean up garbage data in the backend
+
+grammar:
+
+```sql
+ADMIN CLEAN TRASH [ON ("BackendHost1:BackendHeartBeatPort1", "BackendHost2:BackendHeartBeatPort2", ...)];
+````
+
+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.
+
### Example
+1. Clean up the junk data of all be nodes.
+
+ ADMIN CLEAN TRASH;
+
+2. Clean up the junk data of '192.168.0.1:9050' and '192.168.0.2:9050'.
+
+ ADMIN CLEAN TRASH ON ("192.168.0.1:9050","192.168.0.2:9050");
+
### Keywords
ADMIN, CHECK, TABLET
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CLEAN-TRASH.md
similarity index 55%
copy from new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
copy to new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CLEAN-TRASH.md
index 33eaed0cce..d16094b63a 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CLEAN-TRASH.md
@@ -1,8 +1,10 @@
---
{
- "title": "ADMIN-CANCEL-REPAIR",
+ "title": "ADMIN-CLEAN-TRASH",
"language": "en"
}
+
+
---
<!--
@@ -24,15 +26,34 @@ specific language governing permissions and limitations
under the License.
-->
-## ADMIN-CANCEL-REPAIR
+## ADMIN-CLEAN-TRASH
+
+### Name
+
+ADMIN CLEAN TRASH
### Description
+This statement is used to clean up garbage data in the backend
+
+grammar:
+
+```sql
+ADMIN CLEAN TRASH [ON ("BackendHost1:BackendHeartBeatPort1", "BackendHost2:BackendHeartBeatPort2", ...)];
+````
+
+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.
+
### Example
-### Keywords
+1. Clean up the junk data of all be nodes.
+
+ ADMIN CLEAN TRASH;
- ADMIN, CANCEL, REPAIR
+2. Clean up the junk data of '192.168.0.1:9050' and '192.168.0.2:9050'.
-### Best Practice
+ ADMIN CLEAN TRASH ON ("192.168.0.1:9050","192.168.0.2:9050");
+### Keywords
\ No newline at end of file
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md
index 532befbc0e..4b5cdad0cd 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md
@@ -26,10 +26,35 @@ under the License.
## ADMIN-REPAIR-TABLE
+### Name
+
+ADMIN REPAIR TABLE
+
### Description
+statement used to attempt to preferentially repair the specified table or partition
+
+grammar:
+
+```sql
+ADMIN REPAIR TABLE table_name[ PARTITION (p1,...)]
+````
+
+illustrate:
+
+1. This statement only means to let the system try to repair the shard copy of the specified table or partition with high priority, and does not guarantee that the repair can be successful. Users can view the repair status through the ADMIN SHOW REPLICA STATUS command.
+2. The default timeout is 14400 seconds (4 hours). A timeout means that the system will no longer repair shard copies of the specified table or partition with high priority. Need to re-use this command to set
+
### Example
+1. Attempt to repair the specified table
+
+ ADMIN REPAIR TABLE tbl1;
+
+2. Try to repair the specified partition
+
+ ADMIN REPAIR TABLE tbl1 PARTITION (p1, p2);
+
### Keywords
ADMIN, REPAIR, TABLE
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md
index abf9b768f7..0b4728f965 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md
@@ -26,10 +26,27 @@ under the License.
## ADMIN-SET-CONFIG
+### Name
+
+ADMIN SET CONFIG
+
### Description
+This statement is used to set the configuration items of the cluster (currently only the configuration items of FE are supported).
+The settable configuration items can be viewed through the ADMIN SHOW FRONTEND CONFIG; command.
+
+grammar:
+
+```sql
+ ADMIN SET FRONTEND CONFIG ("key" = "value");
+````
+
### Example
+1. Set 'disable_balance' to true
+
+ ADMIN SET FRONTEND CONFIG ("disable_balance" = "true");
+
### Keywords
ADMIN, SET, CONFIG
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md
index eb6a7ad75a..4b6f1371ff 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md
@@ -26,10 +26,51 @@ under the License.
## ADMIN-SET-REPLICA-STATUS
+### Name
+
+ADMIN SET REPLICA STATUS
+
### Description
+This statement is used to set the state of the specified replica.
+
+This command is currently only used to manually set the status of certain replicas to BAD or OK, allowing the system to automatically repair these replicas
+
+grammar:
+
+```sql
+ADMIN SET REPLICA STATUS
+ PROPERTIES ("key" = "value", ...);
+````
+
+ The following properties are currently supported:
+
+ "tablet_id": Required. Specify a Tablet Id.
+
+ "backend_id": Required. Specify Backend Id.
+
+ "status": Required. Specifies the state. Currently only "bad" or "ok" are supported
+
+If the specified replica does not exist, or the status is already bad, it will be ignored.
+
+> Note:
+>
+> The copy set to Bad status may be deleted immediately, please proceed with caution.
+
### Example
+ 1. Set the replica status of tablet 10003 on BE 10001 to bad.
+
+ ```sql
+ ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "bad");
+ ````
+
+2. Set the replica status of tablet 10003 on BE 10001 to ok.
+
+ ```sql
+ ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "ok");
+ ````
+
### Keywords
ADMIN, SET, REPLICA, STATUS
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md
index 56aac70c96..6fb19f7f36 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md
@@ -26,10 +26,49 @@ under the License.
## ADMIN-SHOW-CONFIG
+### Name
+
+ADMIN SHOW CONFIG
+
### Description
+This statement is used to display the configuration of the current cluster (currently only the configuration items of FE are supported)
+
+grammar:
+
+```sql
+ ADMIN SHOW FRONTEND CONFIG [LIKE "pattern"];
+````
+
+The columns in the results have the following meanings:
+
+1. Key: Configuration item name
+2. Value: Configuration item value
+3. Type: Configuration item type
+4. IsMutable: Whether it can be set by ADMIN SET CONFIG command
+5. MasterOnly: Is it only applicable to Master FE
+6. Comment: Configuration item description
+
### Example
+ 1. View the configuration of the current FE node
+
+ ```sql
+ ADMIN SHOW FRONTEND CONFIG;
+ ```
+
+2. Use the like predicate to search the configuration of the current Fe node
+
+ ````
+ mysql> ADMIN SHOW FRONTEND CONFIG LIKE '%check_java_version%';
+ +--------------------+-------+---------+---------- -+------------+---------+
+ | Key | Value | Type | IsMutable | MasterOnly | Comment |
+ +--------------------+-------+---------+---------- -+------------+---------+
+ | check_java_version | true | boolean | false | false | |
+ +--------------------+-------+---------+---------- -+------------+---------+
+ 1 row in set (0.01 sec)
+ ````
+
### Keywords
ADMIN, SHOW, CONFIG
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md
index 0312d5dd01..4d1eeea5ee 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md
@@ -26,10 +26,38 @@ under the License.
## ADMIN-SHOW-REPLICA-DISTRIBUTION
+### Name
+
+ADMIN SHOW REPLICA DISTRIBUTION
+
### Description
+This statement is used to display the distribution status of a table or partition replica
+
+grammar:
+
+```sql
+ADMIN SHOW REPLICA DISTRIBUTION FROM [db_name.]tbl_name [PARTITION (p1, ...)];
+````
+
+illustrate:
+
+1. The Graph column in the result shows the replica distribution ratio in the form of a graph
+
### Example
+1. View the replica distribution of the table
+
+ ```sql
+ ADMIN SHOW REPLICA DISTRIBUTION FROM tbl1;
+ ````
+
+ 2. View the replica distribution of the partitions of the table
+
+ ```sql
+ ADMIN SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);
+ ````
+
### Keywords
ADMIN, SHOW, REPLICA, DISTRIBUTION
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md
index 17366282da..dc7d20076f 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md
@@ -26,10 +26,55 @@ under the License.
## ADMIN-SHOW-REPLICA-STATUS
+### Name
+
+ADMIN SHOW REPLICA STATUS
+
### Description
+This statement is used to display replica status information for a table or partition.
+
+grammar:
+
+```sql
+ ADMIN SHOW REPLICA STATUS FROM [db_name.]tbl_name [PARTITION (p1, ...)]
+[where_clause];
+````
+
+illustrate
+
+1. where_clause:
+ WHERE STATUS [!]= "replica_status"
+
+2. replica_status:
+ OK: replica is healthy
+ DEAD: The Backend where the replica is located is unavailable
+ VERSION_ERROR: replica data version is missing
+ SCHEMA_ERROR: The schema hash of the replica is incorrect
+ MISSING: replica does not exist
+
### Example
+1. View the status of all replicas of the table
+
+ ```sql
+ ADMIN SHOW REPLICA STATUS FROM db1.tbl1;
+ ````
+
+2. View a copy of a table with a partition status of VERSION_ERROR
+
+ ```sql
+ ADMIN SHOW REPLICA STATUS FROM tbl1 PARTITION (p1, p2)
+ WHERE STATUS = "VERSION_ERROR";
+ ````
+
+3. View all unhealthy replicas of the table
+
+ ```sql
+ ADMIN SHOW REPLICA STATUS FROM tbl1
+ WHERE STATUS != "OK";
+ ````
+
### Keywords
ADMIN, SHOW, REPLICA, STATUS
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md
index a7b5d49a91..beaf2aca67 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md
@@ -26,10 +26,52 @@ under the License.
## INSTALL-PLUGIN
+### Name
+
+INSTALL PLUGIN
+
### Description
+This statement is used to install a plugin.
+
+grammar:
+
+```sql
+INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+````
+
+source supports three types:
+
+1. An absolute path to a zip file.
+2. An absolute path to a plugin directory.
+3. Point to a zip file download path with http or https protocol
+
### Example
+1. Install a local zip file plugin:
+
+ ```sql
+ INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
+ ````
+
+2. Install the plugin in a local directory:
+
+ ```sql
+ INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
+ ````
+
+3. Download and install a plugin:
+
+ ```sql
+ INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
+ ````
+
+4. Download and install a plugin, and set the md5sum value of the zip file at the same time:
+
+ ```sql
+ INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum" = "73877f6029216f4314d712086a146570");
+ ````
+
### Keywords
INSTALL, PLUGIN
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md
index fe93c90be8..04106a48f1 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md
@@ -26,8 +26,22 @@ under the License.
## KILL
+### Name
+
+KILL
+
### Description
+Each Doris connection runs in a separate thread. You can kill a thread with the KILL processlist_id statement.
+
+The thread process list identifier can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of the SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema thread table.
+
+grammar:
+
+```sql
+KILL [CONNECTION | QUERY] processlist_id
+````
+
### Example
### Keywords
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md
index ccfe365973..c7b3e7d85e 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md
@@ -26,10 +26,62 @@ under the License.
## RECOVER
+### Name
+
+RECOVER
+
### Description
+This statement is used to restore a previously deleted database, table or partition.
+
+grammar:
+
+1. Restore the database
+
+
+ ```sql
+ RECOVER DATABASE db_name;
+ ````
+
+1. Restore the table
+
+
+ ```sql
+ RECOVER TABLE [db_name.]table_name;
+ ````
+
+1. restore partition
+
+
+ ```sql
+ RECOVER PARTITION partition_name FROM [db_name.]table_name;
+ ````
+
+illustrate:
+
+1. This operation can only restore meta information that was deleted within a certain period of time. Default is 1 day. (Configurable through the `catalog_trash_expire_second` parameter in fe.conf)
+2. If a new meta information with the same name and type is created after the meta information is deleted, the previously deleted meta information cannot be recovered.
+
### Example
+1. Restore the database named example_db;
+
+ ```sql
+ RECOVER DATABASE example_db;
+ ````
+
+2. Restore the table named example_tbl
+
+ ```sql
+ RECOVER TABLE example_db.example_tbl;
+ ````
+
+3. Restore the partition named p1 in table example_tbl
+
+ ```sql
+ RECOVER PARTITION p1 FROM example_tbl;
+ ````
+
### Keywords
RECOVER
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md
index 4c59725a02..4467c4aaff 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md
@@ -26,10 +26,62 @@ under the License.
## SET-VARIABLE
+### Name
+
+SET VARIABLE
+
### Description
+This statement is mainly used to modify Doris system variables. These system variables can be modified at the global and session level, and some can also be modified dynamically. You can also view these system variables with `SHOW VARIABLE`.
+
+grammar:
+
+```sql
+SET variable_assignment [, variable_assignment] ...
+````
+
+illustrate:
+
+1. variable_assignment:
+ user_var_name = expr
+ | [GLOBAL | SESSION] system_var_name = expr
+
+> Note:
+>
+> 1. Only ADMIN users can set variables to take effect globally
+> 2. The globally effective variable does not affect the variable value of the current session, but only affects the variable in the new session.
+
+Variables that support both the current session and the global effect include:
+
+- `time_zone`
+- `wait_timeout`
+- `sql_mode`
+- `enable_profile`
+- `query_timeout`
+- `exec_mem_limit`
+- `batch_size`
+- `allow_partition_column_nullable`
+- `insert_visible_timeout_ms`
+- `enable_fold_constant_by_be`
+
+Variables that only support global effects include:
+
+- `default_rowset_type`
+
### Example
+1. Set the time zone to Dongba District
+
+ ````
+ SET time_zone = "Asia/Shanghai";
+ ````
+
+2. Set the global execution memory size
+
+ ````
+ SET GLOBAL exec_mem_limit = 137438953472
+ ````
+
### Keywords
SET, VARIABLE
diff --git a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md
index ab482e4661..1756d89adc 100644
--- a/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md
+++ b/new-docs/en/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md
@@ -26,10 +26,32 @@ under the License.
## UNINSTALL-PLUGIN
+### Name
+
+UNINSTALL PLUGIN
+
### Description
+This statement is used to uninstall a plugin.
+
+grammar:
+
+```sql
+UNINSTALL PLUGIN plugin_name;
+````
+
+ plugin_name can be viewed with the `SHOW PLUGINS;` command.
+
+Only non-builtin plugins can be uninstalled.
+
### Example
+1. Uninstall a plugin:
+
+ ```sql
+ UNINSTALL PLUGIN auditdemo;
+ ````
+
### Keywords
UNINSTALL, PLUGIN
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
index 6f232ed10a..e548aa8483 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
@@ -26,10 +26,32 @@ under the License.
## ADMIN-CANCEL-REPAIR
+### Name
+
+ADMIN CANCEL REPAIR
+
### Description
+该语句用于取消以高优先级修复指定表或分区
+
+语法：
+
+```sql
+ADMIN CANCEL REPAIR TABLE table_name[ PARTITION (p1,...)];
+```
+
+说明：
+
+1. 该语句仅表示系统不再以高优先级修复指定表或分区的分片副本。系统仍会以默认调度方式修复副本。
+
### Example
+ 1. 取消高优先级修复
+
+ ```sql
+ ADMIN CANCEL REPAIR TABLE tbl PARTITION(p1);
+ ```
+
### Keywords
ADMIN, CANCEL, REPAIR
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
index 18872cca47..879fa9707c 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CHECK-TABLET.md
@@ -26,10 +26,36 @@ under the License.
## ADMIN-CHECK-TABLET
+### Name
+
+ADMIN CHECK TABLET
+
### Description
+该语句用于对一组 tablet 执行指定的检查操作
+
+语法：
+
+```sql
+ADMIN CHECK TABLE (tablet_id1, tablet_id2, ...)
+PROPERTIES("type" = "...");
+```
+
+说明：
+
+1. 必须指定 tablet id 列表以及 PROPERTIES 中的 type 属性。
+2. 目前 type 仅支持：
+
+ * consistency: 对tablet的副本数据一致性进行检查。该命令为异步命令，发送后，Doris 会开始执行对应 tablet 的一致性检查作业。最终的结果，将体现在 `SHOW PROC "/statistic";` 结果中的 InconsistentTabletNum 列。
+
### Example
+1. 对指定的一组 tablet 进行副本数据一致性检查
+
+ ```
+ ADMIN CHECK TABLET (10000, 10001)
+ PROPERTIES("type" = "consistency");
+
### Keywords
ADMIN, CHECK, TABLET
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CLEAN-TRASH.md
similarity index 57%
copy from new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
copy to new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CLEAN-TRASH.md
index 6f232ed10a..2e2e4437d7 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CANCEL-REPAIR.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-CLEAN-TRASH.md
@@ -1,8 +1,9 @@
---
{
- "title": "ADMIN-CANCEL-REPAIR",
+ "title": "ADMIN-CLEAN-TRASH",
"language": "zh-CN"
}
+
---
<!--
@@ -24,15 +25,39 @@ specific language governing permissions and limitations
under the License.
-->
-## ADMIN-CANCEL-REPAIR
+## ADMIN-CLEAN-TRASH
+
+### Name
+
+ADMIN CLEAN TRASH
### Description
+该语句用于清理 backend 内的垃圾数据
+
+语法：
+
+```sql
+ADMIN CLEAN TRASH [ON ("BackendHost1:BackendHeartBeatPort1", "BackendHost2:BackendHeartBeatPort2", ...)];
+```
+
+说明：
+
+1. 以 BackendHost:BackendHeartBeatPort 表示需要清理的 backend ，不添加on限定则清理所有 backend 。
+
### Example
+1. 清理所有be节点的垃圾数据。
+
+ ADMIN CLEAN TRASH;
+
+2. 清理'192.168.0.1:9050'和'192.168.0.2:9050'的垃圾数据。
+
+ ADMIN CLEAN TRASH ON ("192.168.0.1:9050","192.168.0.2:9050");
+
### Keywords
- ADMIN, CANCEL, REPAIR
+ ADMIN, CLEAN, TRASH
### Best Practice
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md
index cb39d0cd7d..36fdc619be 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-REPAIR-TABLE.md
@@ -26,10 +26,35 @@ under the License.
## ADMIN-REPAIR-TABLE
+### Name
+
+ADMIN REPAIR TABLE
+
### Description
+语句用于尝试优先修复指定的表或分区
+
+语法：
+
+```sql
+ADMIN REPAIR TABLE table_name[ PARTITION (p1,...)]
+```
+
+说明：
+
+1. 该语句仅表示让系统尝试以高优先级修复指定表或分区的分片副本，并不保证能够修复成功。用户可以通过 ADMIN SHOW REPLICA STATUS 命令查看修复情况。
+2. 默认的 timeout 是 14400 秒(4小时)。超时意味着系统将不再以高优先级修复指定表或分区的分片副本。需要重新使用该命令设置
+
### Example
+1. 尝试修复指定表
+
+ ADMIN REPAIR TABLE tbl1;
+
+2. 尝试修复指定分区
+
+ ADMIN REPAIR TABLE tbl1 PARTITION (p1, p2);
+
### Keywords
ADMIN, REPAIR, TABLE
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md
index 369a81a0f0..ca012b3b4c 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-CONFIG.md
@@ -26,10 +26,27 @@ under the License.
## ADMIN-SET-CONFIG
+### Name
+
+ADMIN SET CONFIG
+
### Description
+该语句用于设置集群的配置项（当前仅支持设置FE的配置项）。
+可设置的配置项，可以通过 ADMIN SHOW FRONTEND CONFIG; 命令查看。
+
+语法：
+
+```sql
+ ADMIN SET FRONTEND CONFIG ("key" = "value");
+```
+
### Example
+1. 设置 'disable_balance' 为 true
+
+ ADMIN SET FRONTEND CONFIG ("disable_balance" = "true");
+
### Keywords
ADMIN, SET, CONFIG
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md
index 4f7a4fefad..5d3da58702 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SET-REPLICA-STATUS.md
@@ -26,10 +26,51 @@ under the License.
## ADMIN-SET-REPLICA-STATUS
+### Name
+
+ADMIN SET REPLICA STATUS
+
### Description
+该语句用于设置指定副本的状态。
+
+该命令目前仅用于手动将某些副本状态设置为 BAD 或 OK，从而使得系统能够自动修复这些副本
+
+语法：
+
+```sql
+ADMIN SET REPLICA STATUS
+ PROPERTIES ("key" = "value", ...);
+```
+
+ 目前支持如下属性：
+
+ "tablet_id"：必需。指定一个 Tablet Id.
+
+ "backend_id"：必需。指定 Backend Id.
+
+ "status"：必需。指定状态。当前仅支持 "bad" 或 "ok"
+
+如果指定的副本不存在，或状态已经是 bad，则会被忽略。
+
+> 注意：
+>
+> 设置为 Bad 状态的副本可能立刻被删除，请谨慎操作。
+
### Example
+ 1. 设置 tablet 10003 在 BE 10001 上的副本状态为 bad。
+
+ ```sql
+ ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "bad");
+ ```
+
+2. 设置 tablet 10003 在 BE 10001 上的副本状态为 ok。
+
+ ```sql
+ ADMIN SET REPLICA STATUS PROPERTIES("tablet_id" = "10003", "backend_id" = "10001", "status" = "ok");
+ ```
+
### Keywords
ADMIN, SET, REPLICA, STATUS
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md
index 57a7ce40f2..35c6e115d9 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-CONFIG.md
@@ -26,10 +26,49 @@ under the License.
## ADMIN-SHOW-CONFIG
+### Name
+
+ADMIN SHOW CONFIG
+
### Description
+该语句用于展示当前集群的配置（当前仅支持展示 FE 的配置项）
+
+语法：
+
+```sql
+ ADMIN SHOW FRONTEND CONFIG [LIKE "pattern"];
+```
+
+结果中的各列含义如下：
+
+1. Key： 配置项名称
+2. Value： 配置项值
+3. Type： 配置项类型
+4. IsMutable： 是否可以通过 ADMIN SET CONFIG 命令设置
+5. MasterOnly： 是否仅适用于 Master FE
+6. Comment： 配置项说明
+
### Example
+ 1. 查看当前FE节点的配置
+
+ ```sql
+ ADMIN SHOW FRONTEND CONFIG;
+ ```
+
+2. 使用like谓词搜索当前Fe节点的配置
+
+ ```
+ mysql> ADMIN SHOW FRONTEND CONFIG LIKE '%check_java_version%';
+ +--------------------+-------+---------+-----------+------------+---------+
+ | Key | Value | Type | IsMutable | MasterOnly | Comment |
+ +--------------------+-------+---------+-----------+------------+---------+
+ | check_java_version | true | boolean | false | false | |
+ +--------------------+-------+---------+-----------+------------+---------+
+ 1 row in set (0.01 sec)
+ ```
+
### Keywords
ADMIN, SHOW, CONFIG
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md
index 684c4d9307..44f2079921 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-DISTRIBUTION.md
@@ -26,10 +26,38 @@ under the License.
## ADMIN-SHOW-REPLICA-DISTRIBUTION
+### Name
+
+ADMIN SHOW REPLICA DISTRIBUTION
+
### Description
+该语句用于展示一个表或分区副本分布状态
+
+语法：
+
+```sql
+ADMIN SHOW REPLICA DISTRIBUTION FROM [db_name.]tbl_name [PARTITION (p1, ...)];
+```
+
+说明：
+
+1. 结果中的 Graph 列以图形的形式展示副本分布比例
+
### Example
+1. 查看表的副本分布
+
+ ```sql
+ ADMIN SHOW REPLICA DISTRIBUTION FROM tbl1;
+ ```
+
+ 2. 查看表的分区的副本分布
+
+ ```sql
+ ADMIN SHOW REPLICA DISTRIBUTION FROM db1.tbl1 PARTITION(p1, p2);
+ ```
+
### Keywords
ADMIN, SHOW, REPLICA, DISTRIBUTION
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md
index 69b40e2159..891c242af7 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS.md
@@ -26,10 +26,55 @@ under the License.
## ADMIN-SHOW-REPLICA-STATUS
+### Name
+
+ADMIN SHOW REPLICA STATUS
+
### Description
+该语句用于展示一个表或分区的副本状态信息。
+
+语法：
+
+```sql
+ ADMIN SHOW REPLICA STATUS FROM [db_name.]tbl_name [PARTITION (p1, ...)]
+[where_clause];
+```
+
+说明
+
+1. where_clause:
+ WHERE STATUS [!]= "replica_status"
+
+2. replica_status:
+ OK: replica 处于健康状态
+ DEAD: replica 所在 Backend 不可用
+ VERSION_ERROR: replica 数据版本有缺失
+ SCHEMA_ERROR: replica 的 schema hash 不正确
+ MISSING: replica 不存在
+
### Example
+1. 查看表全部的副本状态
+
+ ```sql
+ ADMIN SHOW REPLICA STATUS FROM db1.tbl1;
+ ```
+
+2. 查看表某个分区状态为 VERSION_ERROR 的副本
+
+ ```sql
+ ADMIN SHOW REPLICA STATUS FROM tbl1 PARTITION (p1, p2)
+ WHERE STATUS = "VERSION_ERROR";
+ ```
+
+3. 查看表所有状态不健康的副本
+
+ ```sql
+ ADMIN SHOW REPLICA STATUS FROM tbl1
+ WHERE STATUS != "OK";
+ ```
+
### Keywords
ADMIN, SHOW, REPLICA, STATUS
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md
index 5c8db00138..c610c75214 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/INSTALL-PLUGIN.md
@@ -26,10 +26,52 @@ under the License.
## INSTALL-PLUGIN
+### Name
+
+INSTALL PLUGIN
+
### Description
+该语句用于安装一个插件。
+
+语法：
+
+```sql
+INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]
+```
+
+source 支持三种类型：
+
+1. 指向一个 zip 文件的绝对路径。
+2. 指向一个插件目录的绝对路径。
+3. 指向一个 http 或 https 协议的 zip 文件下载路径
+
### Example
+1. 安装一个本地 zip 文件插件：
+
+ ```sql
+ INSTALL PLUGIN FROM "/home/users/doris/auditdemo.zip";
+ ```
+
+2. 安装一个本地目录中的插件：
+
+ ```sql
+ INSTALL PLUGIN FROM "/home/users/doris/auditdemo/";
+ ```
+
+3. 下载并安装一个插件：
+
+ ```sql
+ INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip";
+ ```
+
+4. 下载并安装一个插件,同时设置了zip文件的md5sum的值：
+
+ ```sql
+ INSTALL PLUGIN FROM "http://mywebsite.com/plugin.zip" PROPERTIES("md5sum" = "73877f6029216f4314d712086a146570");
+ ```
+
### Keywords
INSTALL, PLUGIN
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md
index 60dc6bffeb..c671abcc5e 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/KILL.md
@@ -26,8 +26,22 @@ under the License.
## KILL
+### Name
+
+KILL
+
### Description
+每个 Doris 的连接都在一个单独的线程中运行。 您可以使用 KILL processlist_id 语句终止线程。
+
+线程进程列表标识符可以从 INFORMATION_SCHEMA PROCESSLIST 表的 ID 列、SHOW PROCESSLIST 输出的 Id 列和性能模式线程表的 PROCESSLIST_ID 列确定。
+
+语法：
+
+```sql
+KILL [CONNECTION | QUERY] processlist_id
+```
+
### Example
### Keywords
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md
index 3057951ab6..e5312d5fa7 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/RECOVER.md
@@ -26,10 +26,59 @@ under the License.
## RECOVER
+### Name
+
+RECOVER
+
### Description
+该语句用于恢复之前删除的 database、table 或者 partition。
+
+语法：
+
+1) 恢复 database
+
+ ```sql
+ RECOVER DATABASE db_name;
+ ```
+
+1) 恢复 table
+
+ ```sql
+ RECOVER TABLE [db_name.]table_name;
+ ```
+
+1) 恢复 partition
+
+ ```sql
+ RECOVER PARTITION partition_name FROM [db_name.]table_name;
+ ```
+
+说明：
+
+1. 该操作仅能恢复之前一段时间内删除的元信息。默认为 1 天。（可通过fe.conf中`catalog_trash_expire_second`参数配置）
+2. 如果删除元信息后新建立了同名同类型的元信息，则之前删除的元信息不能被恢复
+
### Example
+1. 恢复名为 example_db 的 database；
+
+ ```sql
+ RECOVER DATABASE example_db;
+ ```
+
+1. 恢复名为 example_tbl 的 table
+
+ ```sql
+ RECOVER TABLE example_db.example_tbl;
+ ```
+
+1. 恢复表 example_tbl 中名为 p1 的 partition
+
+ ```sql
+ RECOVER PARTITION p1 FROM example_tbl;
+ ```
+
### Keywords
RECOVER
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md
index 1df8b4c33e..796ecf6660 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/SET-VARIABLE.md
@@ -26,10 +26,62 @@ under the License.
## SET-VARIABLE
+### Name
+
+SET VARIABLE
+
### Description
+该语句主要是用来修改 Doris 系统变量，这些系统变量可以分为全局以及会话级别层面来修改，有些也可以进行动态修改。你也可以通过 `SHOW VARIABLE` 来查看这些系统变量。
+
+语法：
+
+```sql
+SET variable_assignment [, variable_assignment] ...
+```
+
+说明：
+
+1. variable_assignment:
+ user_var_name = expr
+ | [GLOBAL | SESSION] system_var_name = expr
+
+> 注意：
+>
+> 1. 只有 ADMIN 用户可以设置变量的全局生效
+> 2. 全局生效的变量不影响当前会话的变量值，仅影响新的会话中的变量。
+
+既支持当前会话生效又支持全局生效的变量包括：
+
+- `time_zone`
+- `wait_timeout`
+- `sql_mode`
+- `enable_profile`
+- `query_timeout`
+- `exec_mem_limit`
+- `batch_size`
+- `allow_partition_column_nullable`
+- `insert_visible_timeout_ms`
+- `enable_fold_constant_by_be`
+
+只支持全局生效的变量包括：
+
+- `default_rowset_type`
+
### Example
+1. 设置时区为东八区
+
+ ```
+ SET time_zone = "Asia/Shanghai";
+ ```
+
+2. 设置全局的执行内存大小
+
+ ```
+ SET GLOBAL exec_mem_limit = 137438953472
+ ```
+
### Keywords
SET, VARIABLE
diff --git a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md
index 7508345891..91c677c0d4 100644
--- a/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md
+++ b/new-docs/zh-CN/sql-manual/sql-reference-v2/Database-Administration-Statements/UNINSTALL-PLUGIN.md
@@ -26,10 +26,32 @@ under the License.
## UNINSTALL-PLUGIN
+### Name
+
+UNINSTALL PLUGIN
+
### Description
+该语句用于卸载一个插件。
+
+语法：
+
+```sql
+UNINSTALL PLUGIN plugin_name;
+```
+
+ plugin_name 可以通过 `SHOW PLUGINS;` 命令查看。
+
+只能卸载非 builtin 的插件。
+
### Example
+1. 卸载一个插件：
+
+ ```sql
+ UNINSTALL PLUGIN auditdemo;
+ ```
+
### Keywords
UNINSTALL, PLUGIN
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org