Hi there

Thanks for the speedy responses!

> How big is your database?  How are you talking to the ZEO server?
> TCP or unix domain sockets. Given that they're on the same machine,
> I'd recommend the later, in which case, you may not get that much benefit
> from the caches. You might try using smaller caches.

The database is 600MB (packed).

I realised I needed larger than the default 20MB from reading 
http://wiki.zope.org/zope2/ZEOCache, and I got the 300MB from the ZEO 
setup section of this document on Plone.org  - http://is.gd/8Jl48 
Nothing more scientific than that, I'm afraid!

I wondered if we would be getting much from the caches.  If I moved to 
sockets could I reduce the cache size right back down to the default?

>> While under this configuration the site failed due to cache corruption.
>>  This caused us to remove the persistent cache option, again as
>> recommended in various mailing list posts.
> 
> Note that the latest versions of ZODB (3.8 and 3.9) have fixed
> most or all (not quite sure :) of the cache corruption issues.

We're Plone 2.5, Zope 2.9, ZODB 3.6.  I've not tried upgrading, and 
wouldn't want to unless it was a) easy and b) guaranteed to fix 
something that was properly broken.

> ZEO uses the tempfile module for transient caches, which
> honors several environment variables to control where
> temporary files go. You can also control this by setting a tempfile
> module attribute from Python. See the tempfile documentation.

Perfect, thank you!

> (I'd be happy to accept a patch/checkin with test to make this
>  configurable from the ZEO configuration.)

Having spent my day trying and failing to work out how it worked I may 
not be the person for the task!

I'll see how I get on

Thank you again for your help

Cheers

Andy
-- 
Isotoma, Open Source Software Consulting - http://www.isotoma.com
Tel: 01904 567349, Mobile: 07725 269250, Fax: 020 79006980
Postal Address: Tower House, Fishergate, York, YO10 4UA, UK

Registered in England.  Company No 5171172.  VAT GB843570325.
Registered Office: 3&4 Park Court, Riccall Road, Escrick, York, YO19 6ED
_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to