[Zope] Re: MySQL thread connection question

[Allen Schmidt]

We use about 10 total database connections. We have 2 public clients and one 'admin' client. The 2 public clients use 7 zope threads and the admin one uses 4. So (10 x 7) x 2 plus (10 x 4) total mysql connections each time the whole thing starts up. Then if we kill off a dead client it leaves the old ones sleeping and connects new ones all over.  We do that several times and our da connections of mostly all sleeping is a few hundred.

The numbers may be off a bit but pretty close. This is what we are seeing.

Allen


Dieter Maurer wrote:

> Chris Withers wrote at 2004-8-13 10:41 +0200:
> 
>>...
>>*sigh*
>>
>>I'm starting to feel like I should see about migrating the changes I 
>>made for ZOracleDA into the ZOpe core and have all DA's use that way of 
>>doing things...
>>
>>What do people think?
> 
> 
> I never felt that the current way is wrong in any way.
> 
> You may get a few extra connections but unless you litter
> your site with redundant DA instances, that should not
> make a big problem.
>