MySQL clear query cache
Book page
Written with a loving hand by kitt some time around 23:30 on 11 February 2008
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.