RESETreset_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:
-
MASTERDeletes 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 MASTERin versions of MySQL before 3.23.26.) See Section 13.6.1, “SQL Statements for Controlling Master Servers”. -
QUERY CACHERemoves all query results from the query cache.
-
SLAVEMakes 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 SLAVEin versions of MySQL before 3.23.26.) See Section 13.6.2, “SQL Statements for Controlling Slave Servers”.
User Comments
Add your own comment.