MySQueaL Resources

resources for mysql admins and developers who are squealing for help

More Resources

Main Doc Pages
Privileges Required
  • RELOAD
Comments
MySQL columns: everywhere I look are tables and columns; life is filled with databases of information to be ordered and grouped. (Ca'Grande, Milan, Italy)

RESET Statement

Use this MySQL statement to reset certain server settings and files. It's similar to the FLUSH statement, but more powerful for its specific uses.

hits past month: 20 ;  last updated: may 4, 2009 - 2:34am ;  parent: MySQL Table & Server Administration Statements

Syntax

RESET {MASTER|SLAVE|QUERY CACHE}[,  . . . ]

Explanation

Use this MySQL statement to reset certain MySQL server settings and files. It's similar to the FLUSH statement, but more powerful for its specific uses. The RELOAD privilege is required to use it. Multiple options may be given in a a comma-separated list. Currently, you can reset the MASTER, QUERY CACHE, and SLAVE options. See the RESET MASTER statement and the RESET SLAVE statement in our MySQL documentation for detailed explanations of each option. The QUERY CACHE option clears the cache containing SQL query results.

Examples

Below is an example of this MySQL statement in which the query cache is reset:

RESET QUERY CACHE;
Query OK, 0 rows affected (0.00 sec)

As you can see, there isn't much to this statement.

Return to MySQL Table & Server Administration Statements page of our MySQL Documentation