[Postfixbuch-users] Probleme mit Postfix/SASL/Cyrus/MySQL und "slow queries"

[Rustedt, Florian]

Hallo zusammen,
 
wir haben schon immer das Problem, daß in dieser Kombination sich regelmäßig
"slow queries" bis hin zum Stillstand der Datenbank ansammeln.
 
Ich verwende Proxy-Maps und habe relativ kurze Timeouts eingerichtet.
Nichtsdestotrotz bin ich gezwungen, alle X Tage den MySQL-Server neu zu
starten, bevor er sich ganz aufhängt.
 
In Zahlen heißt das, das alle zwei Tage sich duetlich über 100 slow queries
angesammelt haben, die ich dann kille.
Meine Vermutung geht dahin, daß der smtpd-Prozess nicht die Verbindungen
schließt und es deswegen zu diesem Problem kommen kann.
 
Dazu Jemand eine zündende Idee?
 
Grüße, Florian
 
PS: Die Configs:
 
----- Postfix main.cf
-----------------------------------------------------------------------
...
default_process_limit = 20
max_idle = 10s
smtp-filter_destination_concurrency_limit = 20
lmtp-filter_destination_concurrency_limit = 20
in_flow_delay = 1s
ipc_idle = 60s
 
delay_warning_time = 4h
maximal_queue_lifetime = 5d
bounce_queue_lifetime = 0
queue_run_delay = 120
minimal_backoff_time = 240s
maximal_backoff_time = 8000s
 
smtp_sasl_auth_enable = yes
broken_sasl_auth_clients = yes
smtp_helo_timeout = 30s
 
# server-side
smtpd_timeout = 100s
smtpd_recipient_limit = 10
smtpd_soft_error_limit = 3
smtpd_hard_error_limit = 12

# "my"-options
myhostname = ...
mydomain = ...
myorigin = $mydomain
mynetworks = ...
mydestination =
    $mynetworks
    mysql:/etc/postfix/mysql/defaultdomains.cf
    mysql:/etc/postfix/mysql/userdomains.cf
 
# (SPAM-)Restricitons
smtpd_client_restrictions =
    permit_mynetworks
    reject_unauth_destination
 
smtpd_sender_restrictions =
    hash:/etc/postfix/files/BLOCKED
    permit_mynetworks
    reject_non_fqdn_sender
    reject_unknown_sender_domain
    reject_unauth_pipelining
 
smtpd_client_restrictions = reject_rbl_client sbl.spamhaus.org
 
smtpd_recipient_restrictions =
    hash:/etc/postfix/files/BLOCKED
    permit_mynetworks
    reject_unauth_pipelining
    reject_non_fqdn_recipient
    reject_unknown_recipient_domain
    reject_unauth_destination
 
# The new Cyrus-way
mailbox_transport = lmtp:unix:/var/lib/imap/socket/lmtp
 
# Using MySQL and files
proxy_read_maps =
    proxy:mysql:/etc/postfix/mysql/mailboxes.cf
    proxy:mysql:/etc/postfix/mysql/forwarders.cf
    proxy:mysql:/etc/postfix/mysql/prusmado_users.cf
    proxy:mysql:/etc/postfix/mysql/sasl.cf
    proxy:mysql:/etc/postfix/mysql/aliases.cf
local_recipient_maps =
    proxy:mysql:/etc/postfix/mysql/mailboxes.cf
    hash:/etc/postfix/files/relay
virtual_alias_maps =
    proxy:mysql:/etc/postfix/mysql/forwarders.cf
    proxy:mysql:/etc/postfix/mysql/prusmado_users.cf
    hash:/etc/postfix/files/virtual
sender_canonical_maps = hash:/etc/postfix/files/canonical
smtp_sasl_password_maps = proxy:mysql:/etc/postfix/mysql/sasl.cf
alias_maps = hash:/etc/postfix/files/aliases
transport_maps = hash:/etc/postfix/files/transport
----------------------------------------------------------------------------
-----------
 
----- Mysql my.conf
-----------------------------------------------------------------------
[mysqld]
...
skip-locking
key_buffer                                      = 16M
max_allowed_packet                      = 1M
table_cache                             = 64
sort_buffer_size                        = 512K
net_buffer_length                       = 8K
read_buffer_size                        = 256K
read_rnd_buffer_size            = 512K
myisam_sort_buffer_size         = 8M

innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
set-variable = innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
 
[mysqldump]
quick
max_allowed_packet                      = 16M
 
[mysql]
 
[isamchk]
key_buffer                                      = 20M
sort_buffer_size                        = 20M
read_buffer                             = 2M
write_buffer                            = 2M
 
[myisamchk]
key_buffer                                      = 20M
sort_buffer_size                        = 20M
read_buffer                             = 2M
write_buffer                            = 2M
 
**********************************************************************************************
IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the 
named recipient(s) only.
If you have received this email in error, please notify the system manager or the sender immediately and do 
not disclose the contents to anyone or make copies thereof.
*** eSafe scanned this email for viruses, vandals, and malicious content. ***
**********************************************************************************************
-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <https://listi.jpberlin.de/pipermail/postfixbuch-users/attachments/20070601/0ea6f67a/attachment.html>