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
