Wednesday, January 26, 2011

How to disable MySQL's cache?

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

this is for developing purpose only

  • 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.

    From Andrew

0 comments:

Post a Comment