[Zope] Re: MySQL thread connection question

[Dieter Maurer]

Allen Schmidt wrote at 2004-8-16 09:21 -0400:
> ...
>We have multiple MySQL databases for the various things we run on our site(s). It is my understanding that if we have a Real Estate database with 30  tables then there is one connection. An Automotive database with many tables, there is another DA. Classified Ads takes another and so on... we have about 10 different databases all holding different types of things.

You cannot pool connections to different databases.

Chris' connection pool may however give you more control
over the time period an unused connection stays in the pool.

>If I refresh a page that references a specific database connection only a few of the 11 connections refresh....older ones stay sleeping.

Refreshing a page has little to do with connections.
When you want to flush the connections in the ZODB pool,
you must press "Minimize" in "Control_Panel --> Database Management --> Cache".

When the connections do not disappear, then there is probably
a problem in your network:

  We see occational hanging connections to our Postgres database
  server. It is caused by a malfunctioning firewall: it drops
  connections after sufficiently long inactivity in a way
  that the endpoints are not informed about the droppage.
  Consequence: the server waits indefinitely for incoming requests.

  There is a "keep alive" mechanism that should prevent this.

-- 
Dieter