[Zope-DB] mysql / zope db connection issue

Charlie Clark charlie at egenix.com
Wed Apr 5 05:12:14 EDT 2006

On 2006-04-05 at 07:32:46 [+0200], Jamie O'Keefe <jokeefe at jamesokeefe.org> 
> Hi,
> I have written a series of zope pages for a person to update their
> record in our mysql database.   They use a zpt->python->db sql->db
> driver->db flow and work pretty well.
> Unfortunately, if enough people use it, the number of open db
> connections grows until it hits a limit and the db stops accepting
> connections.  I have seen that there is a connection issue with zope
> and mysql, but have not been able to find a solution.  Is there one?

How many concurrent users do you have? I suspect this is not a Zope issue. 
Is it possible for you to use our mxODBCZopeDA which gives fine-grained 
control over connection pools?

I think you will get further by running Zope in debug mode and seeing 
exactly where the problem is, ie. why the connection is being dropped.

Charlie Clark

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/
2005-10-17: Released mxODBC.Zope.DA 1.0.9        http://zope.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the Zope-DB mailing list