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

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

this is for developing purpose only

share|improve this question
1  
...and the operating system's disk cache, and the physical cache on the drive itself... hmm. – Skyhawk Aug 12 '10 at 2:55
1  
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
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.

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.

share|improve this answer

Your Answer

 
discard

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