Hi Philip!
Ok, that would mean that each smtp connection would only need 1 mysql
connection.
I conclude that the max_connections of mysql must be at least the
smtp_accept_max value?
that would sound logical but in my case i raised the max_connections value
of mysql to 250 at a value of
100 at the smtp_accept_max value.
could it be that exim opens one connection for every lookup?
greetings,
Florian
> -----Original Message-----
> From: exim-users-admin@???
> [mailto:exim-users-admin@exim.org] On Behalf Of Philip Hazel
> Sent: Friday, April 23, 2004 11:34 AM
> To: Florian Schicker [Nessus Office]
> Cc: exim-users@???
> Subject: Re: [Exim] Exim MySQL Problems
>
>
> On Thu, 22 Apr 2004, Florian Schicker [Nessus Office] wrote:
>
> > On one domain i get some more mail traffic (ap. 10
> mails/sec) once per day
> > for about 1hour.
> >
> > Everytime this happens, exim takes one mysql connection per
> incoming mail
> > (normally i only have 1 conn)
> > and doesnt disconnect them after the selects (they keep in
> "sleep state" at
> > SHOW PROCESSLIST).
> > so, after some minutes mysql gets max_connections (250 in
> my case) and
> > blocks new connections.
>
> Each incoming connection is a separate process. It is likely to hold
> onto the MySQL connection while it operates. However, once it has
> received the message, the process exits. This should close down
> everything, including the MySQL connection. So, the question
> is, are you
> seeing a lot of long-running Exim reception processes?
>
> A thought has just struck me: have you set smtp_accept_max_per_host to
> something that does a MySQL lookup? There seems to be a bug that could
> cause this effect if you have.
>
>
> --
> Philip Hazel University of Cambridge Computing Service,
> ph10@??? Cambridge, England. Phone: +44 1223 334714.
> Get the Exim 4 book: http://www.uit.co.uk/exim-book
>
> --
>
> ## List details at
> http://www.exim.org/mailman/listinfo/exim-users Exim details
> at http://www.exim.org/ ##
>
