RESET statement causes an
implicit commit. See Section 14.3.3, “Statements That Cause an Implicit Commit”.
In MySQL 5.7.1,
be set to
AUTOMATIC before issuing this
statement. This restriction does not apply in MySQL 5.7.2 or
later. (Bug #16062608, Bug #16715809, Bug #69045)
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.
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.