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”]