Re: [Exim] MySQL persistant?

Startseite
Nachricht löschen
Nachricht beantworten
Autor: Richard Welty
Datum:  
To: exim-users
Betreff: Re: [Exim] MySQL persistant?
On Thu, 25 Mar 2004 12:35:08 -0500 Dean Brooks <dean@???> wrote:

> Hi,


> We are running Exim 4.30, and are considering using MySQL lookups
> in our Exim config in various spots.


> However, we run a fairly high volume mail server and I am concerned
> that MySQL database connections will have to be rebuilt for each new
> incoming message.


> Does Exim set up the MySQL connection in the parent listener process
> (-bd switch), and then pass on the open connection to all of its
> forked children, or does a new connection have to be built for
> each child that needs to do a query?


> Performance is really the issue here, and am concerned about
> the overhead on our MySQL server of dealing with thousands of
> new connections per minute.


take a look at SQL relay, it can do connection pooling for you.

http://sqlrelay.sourceforge.net/

richard
--
Richard Welty                                         rwelty@???
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security