MySQL Empty cache flush

Empty cache Primary Execute flush command, must have reload permission

Flush hosts empties the host cache table. If the host changes IP, or receives an error host...is blocked, empty the host table. When connecting to a MySQL server, a specified host is connected to the database more than Max_connect_errors, MySQL will block the host's corresponding IP connection request for security purposes. You need to empty the host cache before attempting to connect.

Flush privileges The permissions from the database authorization table to the cache. When a new user is empowered, the command is executed and immediately takes effect.

Flush tables Mostly closes all open tables, and the operation empties the contents of the query cache.

Flush tables With read lock closes all open tables and adds a read lock to the tables in all databases until unlock tables is executed. This operation is commonly used for data backup

Flush status Reset Show status variable to 0

Flush Query Cache resets query caching to eliminate fragmentation and improve performance. This does not affect the existing data in the query cache, which is not the same as flush tables and reset query cache (which empties the contents of the query buffer).

Flush slave reset master and slave, let the database forget the primary data copy location, while deleting the downloaded relay log, not recommended, instead of reset slave

MySQL Empty cache flush