RE: [Exim] Exim MySQL Problems

Góra strony
Delete this message
Reply to this message
Autor: Florian Schicker [Nessus Office]
Data:  
Dla: 'Lists'
CC: exim-users
Temat: RE: [Exim] Exim MySQL Problems
Hi Steve!

My smtp_accept_max is set on 100.

all my timeout settings:

queue_only_load = 10
deliver_queue_load_max = 12
remote_max_parallel = 50
smtp_accept_max = 100
smtp_accept_queue = 150
smtp_accept_max_per_host = 40

rfc1413_query_timeout = 0s
delay_warning = 4h:8h:24h:3d
accept_8bitmime
auto_thaw = 8h
ignore_bounce_errors_after = 10h
timeout_frozen_after = 5d

i think that must be enough.

maybe ist a bug that on higher traffic exims doesnt close open mysql
connections...
it's very strange.

greetings,

Florian

> -----Original Message-----
> From: Lists [mailto:sfulton-lists@esoteric.ca]
> Sent: Thursday, April 22, 2004 9:38 PM
> To: Florian Schicker [Nessus Office]
> Subject: Re: [Exim] Exim MySQL Problems
>
>
> Florian Schicker [Nessus Office] wrote:
>
> Exim needs to access the DB for account information, so the number of
> MySQL queries varies proportionately to the number of Exim processes
> requiring information from such queries. The issue is likely
> with Exim,
> so I suggest setting smtp_accept_max in your exim.cfg file to
> something
> like 50 and seeing if that helps.
>
> -- Steve
>
> > that doesnt help anything...
> >
> > i raised it to 500, with now sense.
> > it reaches is limit beacause mysql blocks.
> > i dont think that exim needs more than 250 mysql conns....
> >
> > greetings,
> >
> > Florian
> >
> >
> >>-----Original Message-----
> >>From: Lists [mailto:sfulton-lists@esoteric.ca]
> >>Sent: Thursday, April 22, 2004 9:05 PM
> >>To: Florian Schicker [Nessus Office]
> >>Subject: Re: [Exim] Exim MySQL Problems
> >>
> >>
> >>Florian Schicker [Nessus Office] wrote:
> >>
> >>Increase your max_connections, implement some inbound restrictions
> >>within Exim and you should be fine.
> >>
> >>-- Steve
> >>
> >>
> >>>Hi there!
> >>>
> >>>I have a strange problem with exim 4.32 and mysql 4.0.18.
> >>>Im running exim as manualrouter only to send throu and
> >>
> >>filter (spam, av,
> >>
> >>>dnsbl) for some domains.
> >>>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.
> >>>i have to restart mysql and exim to "kill" the sleeping processes.
> >>>
> >>>the aftereffect is fatal, exim reaches it's max_connections
> >>
> >>limit too and
> >>
> >>>fails after that:
> >>>
> >>>2004-04-22 19:02:46 SMTP connection from [194.25.134.82]
> >>
> >>(TCP/IP connection
> >>
> >>>count = 98)
> >>>2004-04-22 19:02:46 SMTP connection from [194.25.134.20]
> >>
> >>(TCP/IP connection
> >>
> >>>count = 99)
> >>>2004-04-22 19:02:47 SMTP connection from [194.25.134.82]
> >>
> >>(TCP/IP connection
> >>
> >>>count = 100)
> >>>2004-04-22 19:02:47 Connection from 194.25.134.80 refused: too many
> >>>connections
> >>>2004-04-22 19:02:47 Connection from 141.35.1.23 refused: too many
> >>>connections
> >>>2004-04-22 19:02:47 Connection from 194.25.134.19 refused: too many
> >>>connections
> >>>
> >>>and so on.
> >>>
> >>>my exim conf: (mysql stuff)
> >>>
> >>>hide mysql_servers = localhost/db/user/password
> >>>
> >>>BLOCKEDDOMAINS = ${lookup mysql{SELECT blockeddomains FROM exim}}
> >>>WHITEDOMAINS = ${lookup mysql{SELECT whitedomains FROM exim}}
> >>>RELAY_TO_DOMAINS = ${lookup mysql{SELECT relaydomain FROM
> >>
> >>exim_hub where
> >>
> >>>relaydomain='$domain'}{$value}}
> >>>RELAY_FROM_HOSTS = ${lookup mysql{SELECT relay_from_hosts
> >>
> >>FROM exim}}
> >>
> >>>smart_route:
> >>>    driver = manualroute
> >>>    domains = +relay_to_domains
> >>>    transport = remote_smtp
> >>>    condition = ${lookup mysql {select relaydomain from exim_hub \
> >>>                  where relaydomain='$domain'}{$value}}
> >>>    route_list = * "${lookup mysql {select smarthost from
> exim_hub \
> >>>                      where relaydomain='$domain'}{$value}}"

> >>>
> >>>------ snap -------
> >>>
> >>>
> >>>greetings,
> >>>
> >>>Florian Schicker
> >>>
> >>>
> >>>--
> >>>
> >>>## List details at
> >>
> >>http://www.exim.org/mailman/listinfo/exim-users Exim details
> >>at http://www.exim.org/ ##
> >>
> >
>