List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:August 8 2004 12:46am
Subject:Re: Query Cache
View as plain text  
Yes, a query cache is only removed when one of it's tables is updated
or the server is restarted.

-Eric

On Sat, 7 Aug 2004 23:16 +0100 (BST), Terry Riley <moscow@stripped> wrote:
> We have the query cache turned on, and it appears to be working well.
> 
> However, there appears to be no indication in the manual as to the time
> that a cached query remains in memory. In the absence of this information,
> is it safe to assume that a cached query remains there indefinitely,
> unless either (1) one of the tables used in the initial query is modified,
> or (2) the server is re-started?
> 
> We are using ColdFusion MX, which has its own query cache (which is very
> useful for whats called Query-of-query selects), but there the residence
> time is configurable, and the timer is restarted if the cached query is
> called before the timeout.
> 
> Regards
> Terry Riley
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
Thread
Query Cache(Terry Riley)8 Aug
  • Re: Query CacheEric Bergen8 Aug
  • Re: Query CachePaul DuBois8 Aug
    • Re: Query CacheDan Nelson8 Aug
  • Re: Query Cache(Terry Riley)8 Aug