In the last episode (Mar 09), Mauricio Pellegrini said: > Thanks, this the result of show status like "qcache%" > > +-------------------------+----------+ > | Variable_name | Value | > +-------------------------+----------+ > | Qcache_free_blocks | 3330 | > | Qcache_free_memory | 13372320 | > | Qcache_hits | 11119149 | > | Qcache_inserts | 1942009 | > | Qcache_lowmem_prunes | 372898 | > | Qcache_not_cached | 508528 | > | Qcache_queries_in_cache | 3160 | > | Qcache_total_blocks | 9711 | > +-------------------------+----------+ > > Am I right at saying that the value (16Mb)is ok ? > > Qcache_not_cached means the number of query results that didn't get > into the cache because of a space limitation ? If so, perhaps adding > few more Mb would improve that number , isn't it?
Yes; qcache_lowmem_prunes is a good indicator that raising query_cache_size may help. It counts the number if times the cache had to be aged to free up space to cache a new resultset. See the documentation at http://dev.mysql.com/doc/mysql/en/query-cache.html for more tuning ideas. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
