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)