RECYCLE_BIN
更新时间 2025-07-10 16:57:28
最近更新时间: 2025-07-10 16:57:28
本文为您介绍DRDS管理命令中的管理回收站(RECYCLE_BIN)的命令。
UDAL RECYCLE_BIN SHOW CONFIG
语法说明
查询recycle_bin配置信息
示例
mysql> UDAL RECYCLE_BIN SHOW CONFIG;
Empty set (0.02 sec)
UDAL RECYCLE_BIN SET CONFIG [RETAIN_NUMBER=?][,RETAIN_TYPE=?][,DELETE_TABLE=?][,DELETE_TIME=?]
语法说明
设置recycle_bin配置
示例
mysql> UDAL RECYCLE_BIN SET CONFIG RETAIN_NUMBER=10;
Query OK, 1 row affected (0.03 sec)
UDAL RECYCLE_BIN RESTORE TABLE WHERE ID = ?
语法说明
通过recycle_bin恢复表
UDAL RECYCLE_BIN PURGE TABLE WHERE ID = ? [WITH PHYSICAL DELETE]
语法说明
清除recycle_bin中的表,其中,
ID = ? [物理删除]
示例
mysql> UDAL RECYCLE_BIN PURGE TABLE WHERE ID = 4;
Query OK, 1 row affected (0.02 sec)
UDAL RECYCLE_BIN SHOW TABLE
语法说明
查看recycle_bin中的表信息
支持的完整语法如下:
UDAL RECYCLE_BIN SHOW TABLE [WHERE [ID = ?] [[AND] SCHEMA_ID = ?] [[AND] {DELETE_STATUS = ? | DELETE_STATUS != ?} ] [[AND] SCHEMA_NAME LIKE ?] [[AND] {OBJ_NAME LIKE ? | OBJ_NAME = ?}] [[AND] GMT_CREATE >= ?] [[AND] GMT_CREATE <= ?] ] [ORDER BY GMT_CREATE [DESC]] [LIMIT [OFFSET,] ROW_COUNT]
示例
mysql> UDAL RECYCLE_BIN SHOW TABLE;
+------+---------------------------------------------+-----------+----------------------------------+----------+-------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------+---------------------+---------------------+---------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------+-------------+--------------+
| Id | Cluster_id | Tenant_id | Prod_inst_id | Obj_type | Schema_name | Obj_name | Table_scripts | Expire_time | Delete_status | Gmt_create | Gmt_modify | Recycle_id | Schema_id | Delete_time | Delete_table |
+------+---------------------------------------------+-----------+----------------------------------+----------+-------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------+---------------------+---------------------+---------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------+-------------+--------------+
| 2 | /dbproxy_cluster/dbproxy_cluster_000001***4 | 6749 | 5e140***********************29f7 | 0 | ggzdb | t1 | CREATE TABLE IF NOT EXISTS `t1` (
`id` int(10) NOT NULL,
`k` int(10) NOT NULL DEFAULT '0',
`c` char(120) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`pad` char(60) COLLATE utf8mb4_bin DEFAULT NULL,
KEY `xid` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | 2025-05-22 10:06:48 | 0 | 2025-05-07 10:06:48 | 2025-05-07 10:06:48 | /dbproxy_cluster/dbproxy_cluster_0000013714/schemas/schema_000001***7/recyclebin/table_0000014161 | /dbproxy_cluster/dbproxy_cluster_000001***4/schemas/schema_000001***7 | 0 | 1 |
| 3 | /dbproxy_cluster/dbproxy_cluster_000001***4 | 6749 | 5e140***********************229f7 | 0 | ggzdb | t2 | CREATE TABLE IF NOT EXISTS `t2` (
`id` int(10) NOT NULL,
`k` int(10) NOT NULL DEFAULT '0',
`c` char(120) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
`pad` char(60) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
KEY `xid` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; | 2025-05-17 10:16:39 | 0 | 2025-05-07 10:16:38 | 2025-05-07 10:16:38 | /dbproxy_cluster/dbproxy_cluster_000001***4/schemas/schema_000001***7/recyclebin/table_000001***3 | /dbproxy_cluster/dbproxy_cluster_000001***4/schemas/schema_000001***7 | 0 | 1 |
+------+---------------------------------------------+-----------+----------------------------------+----------+-------------+----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+---------------+---------------------+---------------------+---------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------+-------------+--------------+
2 rows in set (0.02 sec)