Clear query cache without restarting server : MySQL

Clear Memory Cache on Linux centos


RESET QUERY CACHE will clear out the query cache, but needs RELOAD privileges.

RESET QUERY CACHE;

or 

FLUSH QUERY CACHE does NOT clear out the query cache, 
it simply defrags it leaving the cached query results in place.
FLUSH QUERY CACHE;
 

 

 

[xyz-ihs snippet=”Discuss”]

Leave a Comment