MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
RESETreset_option
[,reset_option
] ...reset_option
: { MASTER | QUERY CACHE | SLAVE }
The RESET
statement is used to
clear the state of various server operations. You must have the
RELOAD
privilege to execute
RESET
.
RESET
acts as a stronger version
of the FLUSH
statement. See
Section 13.7.6.3, “FLUSH Statement”.
The RESET
statement causes an
implicit commit. See Section 13.3.3, “Statements That Cause an Implicit Commit”.
In MySQL 5.6.11 only, gtid_next
must be set to AUTOMATIC
before issuing this
statement. (Bug #16062608, Bug #16715809, Bug #69045)
The following list describes the permitted
RESET
statement
reset_option
values:
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.
RESET QUERY CACHE
Removes all query results from the query cache.
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.