Has anybody been observing the same thing? For a couple of weeks now I have a website running build with Django. I was looking for way to improve the performance. One way of improving the performance is turning on the Query Cache for MySQL. By default this is activated. It also was on my MySQL installation.
However the number of Query cache hits (an indication of how well the cache is used) is always zero! And this while the number Qcache_queries_in_cache increases while I am browsing my website. So, none of the queries from django are being fetched from the MySQL Query cache! Why not? mysql> SHOW STATUS LIKE '%qcache%'; +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_queries_in_cache | 661 | | Qcache_inserts | 474382 | | Qcache_hits | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 1080657 | | Qcache_free_memory | 18609912 | | Qcache_free_blocks | 1 | | Qcache_total_blocks | 1333 | +-------------------------+----------+ 8 rows in set (0.00 sec) When I manually type in a query on the MySQL command line and execute it several times, the Qcache_hits indeed increases. So, the cache functionality is working. Thanks very much for your help. Berry --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
