schema_history_expire_time specifies the time range of the historical metadata to be retained or the delay after which a tenant is deleted if the DROP TENANT statement has been executed for the tenant.
Note
In OceanBase Database V4.0.0 and later, the default value is changed from 30d to 7d, and the value range is changed from [1m,365d] to [1m,30d].
| Property | Description |
|---|---|
| Type | INTERVAL |
| Default value | 7d, indicating seven days |
| Value range | [1m,30d] |
| Effective upon OBServer node restart | No |
For example, if this parameter is set to 5d, all the historical metadata generated in the last five days is retained, and only earlier historical metadata can be recycled by the historical metadata recycling service. For more information about the historical metadata recycling service, see schema_history_recycle_interval.