PhpMyAdmin, is there something you can add to sql to disable caching for this query?

Question

I am trying to test / improve the SQL query for speed, however caching does not show me the true speed.

Is there something I can add to sql to disable this query?

Also, if not, how else can I check and find the true speed?

Answer 1

You can add SQL_NO_CACHE in your queries to request that MySQL execute the query and not return the cached result:

SELECT SQL_NO_CACHE * FROM myTable; 

Edit:

There is another way to use dong if you have access to configurations

 setting query_cache_type = 0 or query_cache_type = OFF in MySQL conf 

Answer 2

You can use MySQL:

• Query Provider
• or Jet Profiler for MySQL . (Paid)