[Zope-DB] mysql / zope db connection issue

Jamie O'Keefe jokeefe at jamesokeefe.org
Wed Apr 5 13:54:28 EDT 2006

Hi Dieter,

On 4/5/06, Dieter Maurer <dieter at handshake.de> wrote:
> Jamie O'Keefe wrote at 2006-4-5 01:32 -0400:
> >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?
> We are using MySQL and Zope (via "ZMySQLDB") and do not see this problem.
> Apparently, Zope handles connections in principle correctly...

What version of MySQL are you using?

One thing I just noticed is that if I connect in via the unix shell
client, quit and login again, the number of connections goes up.  Not
unusual.  In a slow period i will need to see if the number goes down
as well.


More information about the Zope-DB mailing list