Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

this is for developing purpose only

share|improve this question
...and the operating system's disk cache, and the physical cache on the drive itself... hmm. – Skyhawk Aug 12 '10 at 2: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 2:57
This is getting scary, anybody hanging here reboot each time to run a query though? :D – db2 Aug 12 '10 at 2:59

1 Answer 1

up vote 1 down vote accepted

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.


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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.