RE: Zope hangs when database takes too long to respond
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 ? Regards, Danny
-----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@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-----
participants (2)
-
Sinang, Danny -
Tres Seaver