MySQL Clear Query Cache

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

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..