Note
- For OceanBase Database V4.3.x, this variable was introduced in OceanBase Database V4.3.2.
- For OceanBase Database V4.2.x, this variable was introduced in OceanBase Database V4.2.3.
Description
innodb_stats_persistent specifies whether to persist InnoDB index statistics to the disk.
Applicability
- This variable is applicable to only OceanBase Database in MySQL mode.
- This variable is used only for compatibility with ecosystem tools and does not affect the features of OceanBase Database.
Limitations
Query the variable
In the
systenant or a user tenant, you can execute theSHOW VARIABLESstatement to query the variable at the global level or query theinformation_schema.GLOBAL_VARIABLESview (in MySQL mode) for the variable at the global level.Modify the variable
The variable is for compatibility only. It has no practical effect and does not take effect.
Attributes
| Attribute | Description |
|---|---|
| Type | ENUM |
| Default value | 1 |
| Value range |
|
| Effective scope | Global |
| Modifiable | Yes. You can use the SET statement to modify the variable. |
