Pascal Mayer wrote:
Hi,
this week I installed Midgard 1.5 on a development box with RedHat 9 and MySQL 4.0.13.
Today I enabled the query cache in MySQL. I set the query_cache_size to only 4 MB and used Asgard for a while. Do I miss something or is the cache hit-rate pretty nice using Midgard?
| Questions | 8591 | | Qcache_queries_in_cache | 340 | | Qcache_inserts | 463 | | Qcache_hits | 7944 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 1 | | Qcache_free_memory | 3500432 | | Qcache_free_blocks | 60 | | Qcache_total_blocks | 755 |
I did not make any performance/load tests. If the cache hit-rate is good, does/could it bring significant performance improvement to midgard?
Pascal
You need to do some benchmarks and tell us, this is an exciting development because aegir repeats many queries. Does your app "feel" any faster at all?
-- I don't know why he saved my life. Maybe in those last moments he loved life more than he ever had before. Not just his life, anybody's life, my life. -Blade Runner (Theatrical Release)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
