Clear MySQL query cache without restarting server

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.

Leave a Comment