The Flush Wizard provides graphical interface for executing all
types of the FLUSH command. To run the wizard select Tools | Administrations
Tools | Flush.
The first step of the wizard allows you to select the flush operations to
perform.
Check options to execute the corresponding operations. You should select
at least one operation to proceed to the next step.
|
Hosts
|
Empties the host cache tables. You should flush the host tables
if some of your hosts change IP number or if you get the error message
Host ... is blocked. When more than max_connect_errors errors occur
in a row for a given host while connection to the MySQL server, MySQL
assumes something is wrong and blocks the host from further connection
requests. Flushing the host tables allows the host to attempt to connect
again.
|
|
Logs
|
Closes and reopens all log files. If you have specified an update
log file or a binary log file without an extension, the extension
number of the log file will be incremented by one relative to the
previous file. If you have used an extension in the file name, MySQL
will close and reopen the update log file.
|
|
Privileges
|
Reloads the privileges from the grant tables in the mysql database.
|
|
Tables
|
Closes all open tables and force all tables in use to be closed.
This also flushes the query cache.
|
|
Status
|
Resets most status variables to zero. This is something one should
only use when debugging a query.
|
|
Tables With Read Lock
|
Closes all open tables and locks all tables for all databases with
a read lock until you execute UNLOCK TABLES. This is very convenient
way to get backups if you have a filesystem, like Veritas, that can
take snapshots in time.
|
|
Des Keys
|
Reloads the DES keys from the file that was specified with the
--des-key-file option at server startup time.
|
|
Query Cache
|
Defragment the query cache to better utilise its memory. This command
will not remove any queries from the cache, unlike RESET QUERY CACHE.
|
|
User Resources
|
Resets all user resources to zero. This will enable blocked users
to login again.
|
The final step of the wizard displays the log of executing the operations.
Click Finish to start executing the selected commands.
©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.
