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]

Reply via email to