[ZODB-Dev] ZODB + ZEO performances problem

2008-07-16 Thread Thierry Florac
Hi,

I'm currently trying to migrate an old Zope-2.6.1 application to
Zope-2.9.9.
The new application platform is a Sun Sparc Solaris 10 server (dual
processors).

Application setup includes a ZEO server managing two databases (a main
one for common data and a catalog to store catalog), and two Zope
clients (one as main frontend and another one for uncommon
administration tasks, both with standard threads count of 4).
Database sizes (when packed) are of 280 and 400 MB ; Zope clients caches
are of 300 and 500 MB, for 4 and 8 objects.

All data are stored on two mirrored (via RAID 1) Hitachi SAN with quite
good writing speed.

I actually have two problems with this configuration :
 - storing an object into ZODB is VERY slow ; it can take more than 30
seconds when the object wasn't saved recently, event under light load. I
actually suspect that it's the catalog full-text search index which is
long to load, update and store. The old application under Zope-2.6.1
didn't have this problem (but also didn't use ZEO !). Is there a
specific way to handle catalogs with ZEO, should I avoid this kind of
configuration ?
 - sometimes (but most often under quite heavy load) the Zope clients
completely hang and stop responding, without any access or error log,
and without any disk or CPU activity. I suppose it's a kind of deadlock,
how can I detect the source of the problem ?

Many thanks for any help or advise, as the resolution of these problems
is quite urgent...

  Thierry


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

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


Re: [ZODB-Dev] ZODB + ZEO performances problem

2008-07-16 Thread Alan Runyan
 - sometimes (but most often under quite heavy load) the Zope clients
 completely hang and stop responding, without any access or error log, and
 without any disk or CPU activity. I suppose it's a kind of deadlock, how can
 I detect the source of the problem ?

this isnt a zodb specific question.  you will probably get more help moving
this to the zope mailing list.  check out DeadlockDebugger:
http://highspeedrails.com/Support/Howto/deadlockDebuggerHowto

cheers
-- 
Alan Runyan
Enfold Systems, Inc.
http://www.enfoldsystems.com/
phone: +1.713.942.2377x111
fax: +1.832.201.8856
___
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

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