RESET statement is used to clear the
state of various server operations. You must have the
RELOAD privilege to execute
RESET acts as a stronger version of the
FLUSH statement. See
Section 126.96.36.199, “
reset_option can be any of the
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
in versions of MySQL before 3.23.26.) See
Section 13.6.1, “SQL Statements for Controlling Master Servers”.
Removes all query results from the query cache.
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.
FLUSH SLAVE in versions of
MySQL before 3.23.26.) See
Section 13.6.2, “SQL Statements for Controlling Slave Servers”.