caching - Clear MySQL query cache without restarting server

Question

Is there any way to clear mysql query cache without restarting mySQL server?

Answer 1

I believe you can use...

RESET QUERY CACHE;

...if the user you're running as has reload rights. Alternatively, you can defragment the query cache via...

FLUSH QUERY CACHE;

See the Query Cache Status and Maintenance section of the MySQL manual for more information.