Note
- This variable is available starting with OceanBase Database V4.3.2 in the V4.3.x series.
- This variable is available starting with OceanBase Database V4.2.3 in the V4.2.x series.
Description
The innodb_stats_persistent variable specifies whether to persist InnoDB index statistics to disk.
Applicability
- This variable applies only to OceanBase Database in MySQL-compatible mode.
- This variable is only for compatibility with ecosystem tools and does not affect the functionality of OceanBase Database.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of a Global system variable.Modify variables
This variable is only for compatibility. The parameter configuration has no practical effect and does not take effect.
Attributes
| Attribute | Description |
|---|---|
| Type | Enum |
| Default value | 1 |
| Value range |
|
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |