<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>Hallo
zusammen,</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>wir haben schon
immer das Problem, daß in dieser Kombination sich regelmäßig "slow queries" bis
hin zum Stillstand der Datenbank ansammeln.</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>In Zahlen heißt das,
das alle zwei Tage sich duetlich über 100 slow queries angesammelt haben, die
ich dann kille.</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>Meine Vermutung geht
dahin, daß der smtpd-Prozess nicht die Verbindungen schließt und es deswegen zu
diesem Problem kommen kann.</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>Dazu Jemand eine
zündende Idee?</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>Grüße,
Florian</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>PS:
</FONT></SPAN><SPAN class=609063609-01062007><FONT face=Arial size=2>Die
Configs:</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>----- Postfix
main.cf
-----------------------------------------------------------------------</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007><FONT face=Arial
size=2>default_process_limit = 20<BR>max_idle =
10s<BR>smtp-filter_destination_concurrency_limit =
20<BR>lmtp-filter_destination_concurrency_limit = 20<BR>in_flow_delay =
1s<BR>ipc_idle = 60s</FONT></SPAN></DIV><SPAN class=609063609-01062007>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>delay_warning_time = 4h<BR>maximal_queue_lifetime =
5d<BR>bounce_queue_lifetime = 0<BR>queue_run_delay = 120<BR>minimal_backoff_time
= 240s<BR>maximal_backoff_time = 8000s</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>smtp_sasl_auth_enable =
yes<BR>broken_sasl_auth_clients = yes<BR>smtp_helo_timeout = 30s</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># server-side<BR>smtpd_timeout =
100s<BR>smtpd_recipient_limit = 10<BR>smtpd_soft_error_limit =
3<BR>smtpd_hard_error_limit = 12<BR></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=609063609-01062007>#
</SPAN>"my"-options<BR>myhostname = <SPAN
class=609063609-01062007>...</SPAN><BR>mydomain = <SPAN
class=609063609-01062007>...</SPAN><BR>myorigin = $mydomain<BR>mynetworks
= <SPAN class=609063609-01062007>...</SPAN><BR>mydestination
=<BR> $mynetworks<BR>
mysql:/etc/postfix/mysql/defaultdomains.cf<BR>
mysql:/etc/postfix/mysql/userdomains.cf</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># (SPAM-)Restricitons<BR>smtpd_client_restrictions
=<BR> permit_mynetworks<BR>
reject_unauth_destination</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>smtpd_sender_restrictions =<BR>
hash:/etc/postfix/files/BLOCKED<BR>
permit_mynetworks<BR>
reject_non_fqdn_sender<BR>
reject_unknown_sender_domain<BR>
reject_unauth_pipelining</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>smtpd_client_restrictions = reject_rbl_client
sbl.spamhaus.org</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>smtpd_recipient_restrictions
=<BR> hash:/etc/postfix/files/BLOCKED<BR>
permit_mynetworks<BR>
reject_unauth_pipelining<BR>
reject_non_fqdn_recipient<BR>
reject_unknown_recipient_domain<BR>
reject_unauth_destination</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2># The new Cyrus-way<BR>mailbox_transport =
lmtp:unix:/var/lib/imap/socket/lmtp</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2># Using MySQL and files<BR>proxy_read_maps
=<BR>
proxy:mysql:/etc/postfix/mysql/mailboxes.cf<BR>
proxy:mysql:/etc/postfix/mysql/forwarders.cf<BR>
proxy:mysql:/etc/postfix/mysql/prusmado_users.cf<BR>
proxy:mysql:/etc/postfix/mysql/sasl.cf<BR>
proxy:mysql:/etc/postfix/mysql/aliases.cf<BR>local_recipient_maps
=<BR>
proxy:mysql:/etc/postfix/mysql/mailboxes.cf<BR>
hash:/etc/postfix/files/relay<BR>virtual_alias_maps =<BR>
proxy:mysql:/etc/postfix/mysql/forwarders.cf<BR>
proxy:mysql:/etc/postfix/mysql/prusmado_users.cf<BR>
hash:/etc/postfix/files/virtual<BR>sender_canonical_maps =
hash:/etc/postfix/files/canonical<BR>smtp_sasl_password_maps =
proxy:mysql:/etc/postfix/mysql/sasl.cf<BR>alias_maps =
hash:/etc/postfix/files/aliases<BR>transport_maps =
hash:/etc/postfix/files/transport<BR><SPAN
class=609063609-01062007>---------------------------------------------------------------------------------------</SPAN></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN
class=609063609-01062007></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2><SPAN class=609063609-01062007>
<DIV><SPAN class=609063609-01062007><FONT face=Arial size=2>----- Mysql
my.conf -----------------------------------------------------------------------</FONT></SPAN></DIV>
<DIV><SPAN class=609063609-01062007>[mysqld]<BR>...</SPAN></DIV>
<DIV><SPAN
class=609063609-01062007>skip-locking<BR>key_buffer
=
16M<BR>max_allowed_packet
=
1M<BR>table_cache
=
64<BR>sort_buffer_size
=
512K<BR>net_buffer_length
=
8K<BR>read_buffer_size
=
256K<BR>read_rnd_buffer_size
=
512K<BR>myisam_sort_buffer_size
= 8M<BR></SPAN><SPAN class=609063609-01062007><BR>innodb_buffer_pool_size =
16M<BR>innodb_additional_mem_pool_size = 2M<BR>innodb_data_file_path =
ibdata1:10M:autoextend:max:128M<BR>innodb_log_file_size =
5M<BR>innodb_log_buffer_size = 8M<BR>set-variable =
innodb_log_files_in_group=2<BR>innodb_flush_log_at_trx_commit =
1<BR>innodb_lock_wait_timeout = 50</DIV>
<DIV> </DIV>
<DIV>[mysqldump]<BR>quick<BR>max_allowed_packet
= 16M</DIV>
<DIV> </DIV>
<DIV>[mysql]</DIV>
<DIV> </DIV>
<DIV>[isamchk]<BR>key_buffer
=
20M<BR>sort_buffer_size
=
20M<BR>read_buffer
=
2M<BR>write_buffer
= 2M</DIV>
<DIV> </DIV>
<DIV>[myisamchk]<BR>key_buffer
=
20M<BR>sort_buffer_size
=
20M<BR>read_buffer
=
2M<BR>write_buffer
= 2M</DIV>
<DIV></SPAN> </DIV></SPAN></FONT></FONT></SPAN></DIV>
<HR><Font face=arial size=2 color=black><I>
IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the
named recipient(s) only.<BR>
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.<BR>
</I><B>*** eSafe scanned this email for viruses, vandals, and malicious content. ***</B>
</font><HR>
</BODY></HTML>