[Zope] Adjusting ZODB Pool Size

2007-01-25 Thread Brian
Hi!

We have a very busy site that required zserver-threads to be bumped to 10.

My understanding is DB connections (pool_size) is hardwired to 7, no
knob to adjust, and it should match the number of zserver-threads.

We do get warnings in the logs, so I should fix it.

Create a custom_zodb.py and put in your Zope installation directory.

Does that mean the zinstance or zeoinstance?

The root, or the /etc of the zeoinstance/zinstance?

How do I determine the cache_size setting?

Right now the Target number of objects in memory per cache 15000.

TIA




___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )


Re: [Zope] Adjusting ZODB Pool Size

2007-01-25 Thread Patrick Prodöhl
On Jan 25, 2007 12:14 PM, Brian wrote:

Hi!

We have a very busy site that required zserver-threads to be bumped to
10.

My understanding is DB connections (pool_size) is hardwired to 7, no
knob to adjust, and it should match the number of zserver-threads.

We do get warnings in the logs, so I should fix it.

Create a custom_zodb.py and put in your Zope installation directory.

Does that mean the zinstance or zeoinstance?

The root, or the /etc of the zeoinstance/zinstance?

How do I determine the cache_size setting?

Right now the Target number of objects in memory per cache 15000.

TIA



hey brian,

you are able to adjust both (pool- and cache-size) in the zodb_db-part
your zope.conf.
Just see the example in my config:

8--snip-8-
zodb_db temporary
 # Temporary storage database (for sessions)
 temporarystorage
   name temporary storage for sessioning
 /temporarystorage
 mount-point /temp_folder
 pool-size 8
 container-class Products.TemporaryFolder.TemporaryContainer
/zodb_db

zodb_db zeo.root
 mount-point /
 # ZODB cache, in number of objects
 cache-size 5000
 zeoclient
   server localhost:8100
   storage zeo.root
   name zeo.root
   var $INSTANCE/var
   # ZEO client cache, in bytes
   cache-size 20MB
   # Uncomment to have a persistent disk cache
   #client zeo_client0
 /zeoclient
/zodb_db
8--snip-8-

Greets,
Patrick 

___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )