[Zope-DB] mysql / zope db connection issue
jokeefe at jamesokeefe.org
Wed Apr 5 13:54:28 EDT 2006
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
More information about the Zope-DB