The SET_SYSTEM_DEFAULT procedure sets the default values of refresh statistics parameters.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
PROCEDURE set_system_default(
IN parameter_name VARCHAR(65535),
IN value VARCHAR(65535));
Parameters
| Parameter |
Description |
| parameter_name |
The parameter name. Valid values:
COLLECTION_LEVEL: the statistics collection level. The default value is TYPICAL.
RETENTION_PERIOD: the retention period (in days) of statistics. The default value is 31 days. |
| value |
When parameter_name is COLLECTION_LEVEL, the parameter value indicates the collection level. Valid values:
NONE: specifies not to collect statistics.
TYPICAL: specifies to collect basic refresh statistics.
ADVANCED: specifies to collect detailed refresh statistics.
NULL: specifies to use the default value, that is, TYPICAL. When parameter_name is RETENTION_PERIOD, the parameter value indicates the retention period (in days) of statistics, which ranges from 1 to 365,000 days.
NULL: specifies to use the default value.
-1: specifies to permanently retain statistics.
|
