At 19:19 01.12.2002 +0100, Stefan Schleifer wrote:
>Hello Postfix-List,
>
>i've got the following problem: On my setup i fetch almost everything for
>postfix from a MySQL-Database (virtual users, allowed domains). I use
>incoming mailservers (3) which decide whether the mail is accepted (is the
>domain local? does the user exist?) and if so forwards the mail to another
>postfix-server in the backend (2) which looks up for final recipient
>(virtual-user, forwarding to Cyrus-imapd).
>
>on mail-in-x:
>smtpd_recipient_restrictions = check_recipient_access
>mysql:/etc/postfix/mysql-access.cf, reject
>
>on imap-x:
>mydestination = $myhostname, localhost.$mydomain, $mydomain,
>mysql:/etc/postfix/mysql-mydestination.cf
>virtual_maps = mysql:/etc/postfix/virtual.cf
>alias_maps = mysql:/etc/postfix/mysql-aliases.cf
>
>
>When receiving a single mail, this results in 8 Threads connected to the
>MySQL-Database which held open for about 30 seconds to a minute (found out
>via "show status" on mysql-server).
>
>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?
>

Postfix opens the connections per process. That means "smtpd" opens the
connections needed for his maps and held them open until the process ends.
If you have a timeout of 30 sec. the connection is open for 30 sec.
You have to count the max. number per your process limits in "master.cf"
and the maps used by the different processes not by connections per mail.

Regards

--
Andreas Hödle
"Those who give up essential liberties for temporary safety deserve
neither liberty nor safety." - Benjamin Franklin

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]