<p>I'm testing the speed of some queries in MySQL. The database is caching these queries making it difficult for me to get reliable results when testing how fast these queries are.</p>

<p>Is there a way to disable caching for a query?</p>

<p>System: MySQL 4 on Linux webhosting, I have access to PHPMyAdmin.</p>

<p>Thanks</p>

Try using the
SQL_NO_CACHE
(MySQL 5.7) option in your query.
(MySQL 5.6 users click
HERE
)
eg.
```
```
SELECT SQL_NO_CACHE * FROM TABLE
```
```
This will stop MySQL caching the results, however be aware that other OS and disk caches may also impact performance. These are harder to get around.