[Zope-DB] mysql / zope db connection issue

[Jamie O'Keefe]

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.

Jamie