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]