Thread: Postfix + MySQL
View Single Post
Old 17th March 2009, 16:21
bl4ckb1rd bl4ckb1rd is offline
Join Date: Feb 2009
Posts: 36
Thanks: 2
Thanked 6 Times in 4 Posts
Default Postfix + MySQL

Hello !

Is there any way i can set wait_timeout = 30 in my.cnf and avoiding getting MySQL gone away statement by Postfix ? Problem is, mysql connections are sleeping for very long time, if many ip's are connecting to mail server, which makes new connections frozen. This actually means mysql server stops working as it's waiting for sleeping processes to die, and whole server doesn't work as it should. Webpages, dns, postfix etc... The problem is if i set wait_timeout = 30, everything is fine, but postfix's connection gets dropped saying "Mysql server has gone away". how to tell postfix to try reconnecting to mysql instead of thinking it's already connected ? That would solve the issue, and block the "attackers" that are sending email to one of the domains hosted on webserver. Any tip would be greatly apriciated.
Reply With Quote
Sponsored Links