Re: Connections to MySQL hold open too long

From: Roelof Osinga (no email)
Date: Sun Dec 01 2002 - 14:41:59 EST


Stefan Schleifer wrote:

> ...
>
> For my system receives around 10-15 Mails per second continously this
> results in running out of mysql-connectivity rapidly (mysql-server is
> setup to handle 1000 max_open_connections).
>
> How can i force postfix to close the connections quickly or is there a
> general option to force postfix or is there a general misconfiguration
> on my sites?

That I do not know. However, it would be more efficient to generate
either simple textfiles to be postmapped or feed an LDAP database. Thus
separating the (TP) management from the query side of things.

In fact, the latter is the recommended procedure in "Understanding and
Deploying LDAP Directory Service".

Roelof

-- 
_______________________________________________________________________
EBOAź                                               est. 1982
http://www.EBOA.com/                                tel. +31-58-2123014
mailto:?subject=Information_request







Hosted Email Solutions

Invaluement Anti-Spam DNSBLs



Powered By FreeBSD   Powered By FreeBSD