Another small cache question: what is the CKeyCache for? (or: what the hack is a c key?) ernst
> -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens Rico Jansen > Verzonden: dinsdag 19 oktober 2004 12:40 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: Cache size cofiguration > > > 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 > >
