…_memory/ || /lowmem_prunes/’ Thu Oct 20 03:42:03 EDT 2011 | Qcache_free_blocks | 117773 | | Qcache_free_memory | 147256440 | | Qcache_lowmem_prunes | 1849687 | root@server [~]# date;mysqladmin ext|awk ‘/Qcache/ && /free_blocks/ || /free_memory/ || /lowmem_prunes/’ Thu Oct 20 03…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… and watch Qcache_free_memory and Qcache_lowmem_prunes – If you’re not getting much of lowmem_prunes and free_memory stays high you… Qcache_lowmem_prunes – This one is used to identify if you have enough memory for query cache. Note however due to fragmentation lowmem_prunes…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_definitionsblogpercona.commanual Opened_tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual …_hitsblogpercona.commanual Qcache_insertsblogpercona.commanual Qcache_lowmem_prunesblogpercona.commanual Qcache_not_cachedblogpercona.commanual …
Comment: MySQL Query Cache
November 2, 2011 By 70 Comments
…_free_memory, 536834160 Qcache_hits, 0 Qcache_inserts, 2 Qcache_lowmem_prunes, 0 Qcache_not_cached, 15 Qcache_queries_in_cache, 2…
Comment: MySQL Query Cache
July 20, 2011 By 70 Comments
…_free_memory 53059640 Qcache_hits 984929059 Qcache_inserts 36451881 Qcache_lowmem_prunes 1198358 Qcache_not_cached 244851098 Qcache_queries_in_cache 32379…
Comment: MySQL Query Cache
January 10, 2011 By 70 Comments
… query cache fragmentation (large Qcache_free_blocks) – leading to many lowmem prunes. Raising the query cache size didn’t really help. Well…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_free_memory’, ’10272736′ ‘Qcache_hits’, ’14774371′ ‘Qcache_inserts’, ’83902401′ ‘Qcache_lowmem_prunes‘, ’4314′ ‘Qcache_not_cached’, ’294363493′ ‘Qcache_queries_in_cache’, ’177…
Comment: Using MyISAM in production
July 6, 2006 By 36 Comments
…_free_memory | 486708416 | | Qcache_hits | 2845741 | | Qcache_inserts | 2623234 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 2638244 | | Qcache_queries_in_cache | 26168…
