Ernst Bunders wrote:
Hello
We have a website running on mmbase 1.6.5, and watching the cach stats I
see the nodecache is not very efficient. 62%
Allso in the sql log a lot of queries like:
Most of the times this means the cache is too small as most
people easily get hitratios in the 90's.
[SQL querytimer measures 148 mSec for query: SELECT otype FROM
v15_object WHERE number=411908]
Those queries are caught by the types cache, this cache takes
relatively little space so you can bump it up to 10000 easily
(we run it at 500000, but then again we run the VM at 1.5G).
show up, and allso a lot of queries for the same nodenumbers. The size
of the cache is 4096 (is that the nuber of entries?) , and not growing.
I guess these queries should be captured by the nodecach. If this is so,
the nodecache must be allowed to grow larger.
How can I make this happen???
You can configure the different caches in the caches.xml in the config
directory. You can bump both the nodecache and the types cache. That
will have the most effect. Take care with growing the multilevel cache,
that one eats memory for breakfast.
As a side note, also take care of indexes on the most import fields
in the databases (number , snumber and dnumber). This will boost
performance as well.
--
Rico Jansen ([EMAIL PROTECTED])
"You call it untidy, I call it LRU ordered" -- Daniel Barlow
