The tables certainly get updated and therefore those queries should be ejected from the cache, but it's not a memory issue. Does that mean that Qcache_lowmem_prunes is actually the sum of low memory prunes and dirty queries? The manual doesn't seem to suggest this, so it would be cool if someone could clear it up for sure.
http://www.mysql.com/doc/en/Query_Cache_Status_and_Maintenance.html --- Per Andreas Buer <[EMAIL PROTECTED]> wrote: > LS <[EMAIL PROTECTED]> writes: > > > Hi- > > Can anyone tell me why mysql4 would prune queries from the cache if the > > Qcache_free_memory is still very big? I'm confused why we get so many > > Qcache_lowmem_prunes: > > Mysql will prune queries if the tables are updated, maybe this is what you > are experiencing? > -- > Per Andreas Buer > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
