phpMyAdmin, is there a something you can add to sql to turn off caching for that query?

Question

I'm trying to test / improve an sql query for speed however caching is not showing me the true speed.

Is there something I can add to sql to turn it off for that query ?

Also, if there isn't how else can I test and find the true speed ?

Answer 1

You can add a SQL_NO_CACHE clause to your queries to request that MySQL run the query rather than return a cached result:

SELECT SQL_NO_CACHE * FROM myTable;

Edit:

There is another way of dong this if you have access to configurations

setting query_cache_type = 0 or query_cache_type = OFF in MySQL's conf