MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0 RESET PERSIST Statement

RESET PERSIST [[IF EXISTS] system_var_name]

RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a persisted system variable causes the variable no longer to be initialized from mysqld-auto.cnf at server startup. For more information about persisting system variables and the mysqld-auto.cnf file, see Section, “Persisted System Variables”.

Prior to MySQL 8.0.32, this statement did not work with variables whose name contained a dot character (.), such as MyISAM multiple key cache variables and variables registered by components. (Bug #33417357)

The privileges required for RESET PERSIST depend on the type of system variable to be removed:

See Section, “System Variable Privileges”.

Depending on whether the variable name and IF EXISTS clauses are present, the RESET PERSIST statement has these forms:

RESET PERSIST is not affected by the value of the persisted_globals_load system variable.

RESET PERSIST affects the contents of the Performance Schema persisted_variables table because the table contents correspond to the contents of the mysqld-auto.cnf file. On the other hand, because RESET PERSIST does not change variable values, it has no effect on the contents of the Performance Schema variables_info table until the server is restarted.

For information about RESET statement variants that clear the state of other server operations, see Section, “RESET Statement”.