List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 8 2004 3:08am
Subject:Re: Query Cache
View as plain text  
In the last episode (Aug 07), Paul DuBois said:
> At 23:16 +0100 8/7/04, Terry Riley wrote:
> > 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?
> 
> Yes.  Why would you remove a result from the cache if it's still current?
> 
> Actually, there is another condition:
> 
> (3) you issue a RESET QUERY CACHE statement, which clears the entire
> cache.

There's another one: (4) the data in the cache exceeds
query_cache_size, in which case old cached results will get purged to
make room for new ones.

-- 
	Dan Nelson
	dnelson@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