How to disable MySQL's cache?

Question

So that the same queries will take similar amount of time each time,

this is for developing purpose only

...and the operating system's disk cache, and the physical cache on the drive itself... hmm. — Skyhawk, Aug 12 '10 at 02:55
The only real way to get absolute consistency is to reboot and perform exactly the same steps each time. — John Gardeniers, Aug 12 '10 at 02:57
This is getting scary, anybody hanging here reboot each time to run a query though? :D — , Aug 12 '10 at 02:59

score 1 · Accepted Answer · edited Jun 11 '20 at 10:02

See the MySQL Query Cache Configuration page:

To set the size of the query cache, set the query_cache_size system variable. Setting it to 0 disables the query cache. The default size is 0, so the query cache is disabled by default.

and

If the query cache size is greater than 0, the query_cache_type variable influences how it works. This variable can be set to the following values:

A value of 0 or OFF prevents caching or retrieval of cached results.

But as others have pointed out, MySQL isn't the only thing doing caching.

How to disable MySQL's cache?

1 Answers1