Топ-100
 

RESET

RDBMS Type: MySQL
Topic

Syntax:
RESET reset_option [, reset_option] ...

reset_option: {
MASTER
| SLAVE
}

The RESET statement is used to clear the state of various server
operations. You must have the RELOAD privilege to execute RESET.

For information about the RESET PERSIST statement that removes
persisted global system variables, see [HELP RESET PERSIST].

RESET acts as a stronger version of the FLUSH statement. See [HELP
FLUSH].

The RESET statement causes an implicit commit. See
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html.

The following list describes the permitted RESET statement reset_option
values:

o RESET MASTER

Deletes all binary logs listed in the index file, resets the binary
log index file to be empty, and creates a new binary log file.

o RESET SLAVE

Makes the replica forget its replication position in the source
binary logs. Also resets the relay log by deleting any existing relay
log files and beginning a new one.

URL: https://dev.mysql.com/doc/refman/8.0/en/reset.html

Example