Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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
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
add comment

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.

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
add comment

Your Answer

 
discard

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