From: Stefan Schleifer (no email)
Date: Sun Dec 01 2002 - 13:19:48 EST
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?
Thanks in advance,
Stefan
|
|
|