[Zope] Re: Zope hangs when database takes too long to respond

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sinang, Danny wrote:
> 
>> It is a "known" limitation of Zope, which has a set number of "worker
> threads" available to service user requests.  If a worker thread blocks
> (e.g., waiting for MySQL), it is not able to do any work for other
> pending requests.
> 
>> You can tweak the number of threads in your zope.conf file, via the
> 'zserver-threads' directive (the default value is 4).  If you do
> increase this value, you also need to increase the number of database
> connections avialble (via 'pool-size') which will increase the RAM
> required by your appserver.
> 
> 
> Thanks Tres.
> 
> I found 'zserver-threads' in zope.conf, but couldn't find 'pool-size'.
> Am using Zope 2.7.6.
> 
> Is this something available on higher versions of Zope ?

'pool-size' is an attribute of the database configuration stanza, e.g.:

 <zodb_db main>
  <filestorage>
    path $INSTANCE_HOME/var/Data.fs
  </filestorage>
  mount-point                    /
  cache-size                     5000
  pool-size                      7
  version-pool-size              3
  version-cache-size             100
 </zodb_db>



Tres.
- --
===================================================================
Tres Seaver          +1 202-558-7113          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFAFhB+gerLs4ltQ4RAvAwAKDbZ3An6fQlX5v4BHrLhOBfqwru9QCeLT7l
IpJ42XCh6NBh6auRjMNh7F0=
=rmp6
-----END PGP SIGNATURE-----