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 12.4.6.3, “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.
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.