Paco Martinez Rodriguez wrote:
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.
This is 20 Mega Bits. I suppose you meant to mean 20 MegaBytes (20MB),
or even 20 Mibibytes (20MiB).
I have two questions.
1.- Is there any way to see which queries are being stored ??
About this I don't know. Does anyone?
2.- How can I delay "qcache_lowmen_pruenes" ?? In three day values of it
is 64421 Is it too ??
By increasing Query_cache_size, you get qcache_lowmen_pruenes lower
after a while. THis may be because of the Qcache_free_blocks value,
beeing the free mem ammount about half total mem (Qcache_free_memory =~
10MB)
+-------------------------+----------+
| 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 !!!
--
Nuno Pereira
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
