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
        [EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to