[Zope-DB] mysql concurrency
mkur at poczta.gazeta.pl
Tue Jun 15 11:22:24 EDT 2004
I've got problems with my zope app that is highly depended on a mysql
The application is two-tier with mysql connections over
GE. Performance is OK but it seems it has problems with concurrency.
ZMySQLDA is not able to maintain more then 2 connections at the same
time. With increasing load each request is effectively waiting for it's
connection and responses become really slow ...
I know it's a known problem. I'm sure all components are thread-safe
(checked it manually). I also run zope with 10 threads and mysql server
with 10 threads too. But it does not help much.
Does anyone know how it can be improved ?
Is it possible zope connection object instances number could have
influence in here ?
And please do not ask me to move to Postgres ... No, I'm not after
flamewar in here ;-)
ZMySQLDA: 2.0.9 (with Chris Withers patch applied)
Mysql server: 3.23.58 on Linux 2.4.26
Mysql client: 4.0.18 on Solaris9 (64-bit)
<mkur at poczta.gazeta.pl>
More information about the Zope-DB