MySQL Pocket Reference: SQL Functions and Utilities by Reese George

MySQL Pocket Reference: SQL Functions and Utilities by Reese George

Author:Reese, George [Reese, George]
Language: eng
Format: azw3
Tags: COMPUTERS / Data Processing
ISBN: 9780596102913
Publisher: O'Reilly Media
Published: 2009-02-08T16:00:00+00:00


FLUSH

FLUSH option[, option...]

Flushes or resets various internal processes depending on the options given. You must have RELOAD privileges to execute this statement. The option can be any of the following:

DES_KEY_FILE

Reloads the DES keys from the file originally specified with the --des-key-file option.

HOSTS

Empties the cache table that stores hostname information for clients. This should be used if a client changes IP addresses, or if there are errors related to connecting to the host.

LOGS

Closes all the logfiles and reopens them. This can be used if a logfile has changed its inode number. If no specific extension has been given to the binary log, a new binary log will be opened with the extension incremented by one.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.