Movatterモバイル変換

MySQL 9.1 Reference Manual

15.7.8.7 RESET PERSIST Statement

RESET PERSIST [[IF EXISTS]system_var_name]

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

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

For dynamic system variables, this statement requires theSYSTEM_VARIABLES_ADMIN privilege (or the deprecatedSUPER privilege).
For read-only system variables, this statement requires theSYSTEM_VARIABLES_ADMIN andPERSIST_RO_VARIABLES_ADMIN privileges.

SeeSection 7.1.9.1, “System Variable Privileges”.

Depending on whether the variable name andIF EXISTS clauses are present, theRESET PERSIST statement has these forms:

To remove all persisted variables frommysqld-auto.cnf, useRESET PERSIST without naming any system variable:
```
RESET PERSIST;
```
You must have privileges for removing both dynamic and read-only system variables ifmysqld-auto.cnf contains both kinds of variables.
To remove a specific persisted variable frommysqld-auto.cnf, name it in the statement:
```
RESET PERSISTsystem_var_name;
```
This includes plugin system variables, even if the plugin is not currently installed. If the variable is not present in the file, an error occurs.
To remove a specific persisted variable frommysqld-auto.cnf, but produce a warning rather than an error if the variable is not present in the file, add anIF EXISTS clause to the previous syntax:
```
RESET PERSIST IF EXISTSsystem_var_name;
```

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

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

For information aboutRESET statement variants that clear the state of other server operations, seeSection 15.7.8.6, “RESET Statement”.

PREV HOME UP NEXT