Syntax:
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 [HELP
FLUSH].

The RESET statement causes an implicit commit. See
http://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html.

In MySQL 5.7.1, gtid_next must 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 following:

o 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.

o QUERY CACHE

  Removes all query results from the query cache.

o 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.

URL: http://dev.mysql.com/doc/refman/5.7/en/reset.html

