Hi.. I'm using "cache queries" with MySQL 4.0.13 during three days and I get a little better speed.
Value of Query_cache_size = 20 Mb. I have two questions. 1.- Is there any way to see which queries are being stored ?? 2.- How can I delay "qcache_lowmen_pruenes" ?? In three day values of it is 64421 Is it too ?? +-------------------------+----------+ | Variable_name | Value | +-------------------------+----------+ | Qcache_queries_in_cache | 3106 | | Qcache_inserts | 447577 | | Qcache_hits | 2697410 | | Qcache_lowmem_prunes | 64421 | | Qcache_not_cached | 1421991 | | Qcache_free_memory | 10226504 | | Qcache_free_blocks | 418 | | Qcache_total_blocks | 6997 | | Threads_cached | 0 | +-------------------------+----------+ Thank you !!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]