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

Satya Prakash

VOIP Expert: More than 8 years of experience in Asterisk Development and Call Center operation Management. Unique Combination of Skill Set as IT, Analytics and operation management.

Leave a Reply