up vote 0 down vote favorite
share [g+] share [fb]

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

this is for developing purpose only

link|improve this question
1  
...and the operating system's disk cache, and the physical cache on the drive itself... hmm. – Miles Erickson 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
feedback

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard