[Zope-DB] mysql concurrency
charlie at egenix.com
Wed Jun 16 04:06:15 EDT 2004
Would it be possible to use ODBC? In which case our mxODBCZopeDA should
solve your problem - it is very easy to control the number of connections.
On 2004-06-15 at 17:22:24 [+0200], Michal Kurowski <mkur at poczta.gazeta.pl>
> 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 ;-)
> Versions info:
> Python: 2.3.3
> Zope: 2.7.0
> MySQLdb: 0.9.2
> 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)
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
More information about the Zope-DB