List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 8 2004 1:07am
Subject:Re: Query Cache
View as plain text  
At 23:16 +0100 8/7/04, Terry Riley 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?

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.


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


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
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