(mysql.info) reset

Info Catalog

(mysql.info) load-index

(mysql.info) other-administrative-sql

 
 13.5.5.5 `RESET' 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 
 flush.
 
 RESET_OPTION can be any of the following:
 
    * `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. (Known as `FLUSH MASTER' in versions of MySQL before
      3.23.26.) See  replication-master-sql.
 
    * `QUERY CACHE'
 
      Removes all query results from the query cache.
 
    * `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.  (Known as `FLUSH SLAVE'
      in versions of MySQL before 3.23.26.) See 
      replication-slave-sql.
 

Info Catalog

(mysql.info) load-index

(mysql.info) other-administrative-sql