innodb_stats_persistent

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 sys tenant or a user tenant, you can execute the SHOW VARIABLES statement to query the variable at the global level or query the information_schema.GLOBAL_VARIABLES view (in MySQL mode) for the variable at the global level.

• Modify the variable

  • In the sys tenant, you can directly change the value of the variable at the global level.

  • In a MySQL user tenant, you must have the SUPER or ALTER SYSTEM privilege to change the value of the variable at the global level.

Attributes

Considerations

This variable is used only for compatibility, and its setting does not take effect.

Examples

Configure to persist InnoDB index statistics to the disk.

obclient> SET GLOBAL innodb_stats_persistent=ON;