MySQL clear query cache

MySQL clears the query cache after any changes to the tables used in a cache query. Any of INSERT, UPDATE, DELETE, TRUNCATE, ALTER, DROP TABLE or DROP DATABASE potentially remove queries from the cache.

You can manually clear the query cache with RESET QUERY CACHE.