When testing complex queries it's a good idea to clear your cache so that you aren't fooled into better performance than you actually have. To do this, there's a simple command:
RESET QUERY CACHE;
Some notes:
- You need the RELOAD privilege to execute this command.
- Don't do this on servers that are relying on caching for their performance. IE: don't do this on your production servers during peak time.
Comments
Anonymous (not verified)
Thu, 12/30/2010 - 03:39
Permalink
RESET QUERY CACHE
Hi Adam , I did run this command . it says Query Ok , 0 rows affeceted (0.00 sec)
but the history is still there ..
Pls help .
How can I delete cache..
is there any command for this..