Could you post an example of a query you are expecting to be cached? On Wed, 2006-08-30 at 11:43 -0500, Mazur Worden, Kathy wrote: > Hi, > > > > I just turned on the query cache by modifying its size and limit and > restarting the server. However queries aren't being stored to it: > > > > Variable_name > > Value > > Qcache_free_blocks > > 1 > > Qcache_free_memory > > 10477008 > > Qcache_hits > > 0 > > Qcache_inserts > > 0 > > Qcache_lowmem_prunes > > 0 > > Qcache_not_cached > > 3759 > > Qcache_queries_in_cache > > 0 > > Qcache_total_blocks > > 1 > > > > > > I've found > http://dev.mysql.com/tech-resources/articles/mysql-query-cache.html > which says the qcache_not_cached variable is the number of queries which > were either not SELECT's or have SQL_NO_CACHE specified so I ran several > selects (selected records in a few tables using Query Browser and > refreshed a few web pages hitting the db). None of the queries have the > no cache option specified. > > > > What else would prevent queries from getting into the cache? > > > > Kathy Mazur Worden > > Prairie Area Library System > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
