RESET reset_option [, reset_option] ...
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.5.5.2, “FLUSH Syntax”.
reset_option can be any of the
following:
-
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. (Known as FLUSH MASTER
in versions of MySQL before 3.23.26.) See
Section 13.6.1, “SQL Statements for Controlling Master Servers”.
-
QUERY CACHE
Removes all query results from the query cache.
-
SLAVE
Makes the slave forget its replication position in the
master binary logs. Also resets the relay log by deleting
any existing relay log files and beginning a new one.
(Known as FLUSH SLAVE in versions of
MySQL before 3.23.26.) See
Section 13.6.2, “SQL Statements for Controlling Slave Servers”.
