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

I'm trying to test / improve an sql query for sp开发者_高级运维eed 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 ?

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

You can use MySQL's:

• Query Profiler
• or Jet Profiler for MySQL. (paid)