What is the usage of ‘flush’ in MySQL?

2 years ago
Liam
1 minute

In MySQL, the FLUSH command is used to refresh various caches in MySQL, making them take effect immediately.

There are various ways to use the FLUSH command, here are some common examples:

  1. FLUSH TABLES – Refresh all open tables to take immediate effect. This will reload all cached table structures and index information, but will not clear any data.
  2. Reload the specified table to take effect immediately.
  3. RELOAD PRIVILEGES – Reload the authorization table to make new authorization rules take immediate effect.
  4. RESTART LOGS – Close and reopen all log files to immediately activate changes. This is particularly useful when log files become too large and need to be split.
  5. RESET SERVER STATUS – Refreshes server status information immediately.
  6. Clear all blocked hosts to immediately restore access permissions.
  7. Flush query cache – clear the query cache to take effect immediately. This will result in the next query being re-executed instead of using the cache.
bannerAds