Just wierd things.
-DNS issues with people on the outside all of a sudden not able to get to webmail (i've verified it myself where I can get in remotely but they can't). Fail2Ban isn't blocking them from what I can tell in the logs.
-a LOT of Temporary Lookup Failures when sending emails and the logs show mysql restarting due to some issue.
-website error.log gives: [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request function
- slow mysql access from a website response but the /admin (of the same site) works nice and fast.
Everything seems to point to mysql under medium load. Over the weekend, the response is little better and issues don't exist much (including the mod_fcgid issue), but during the work week when emails starting flooding in and out, I think mysql gets overloaded (totally a guess...).
Hardware is a core2quad 2.66 with 8G Ram and I just up'd mysql to 300 max connections with plenty of mem so we shall see. tuning-primer.sh says everything is cool with mysql.
I was hoping to rectify the isues but gave up since I only see few other have the same issues (but they do). I'm going to migrate to Fedora 13 over the coming days. I'm hoping Till's migration post will work from debian->fedora (thoughts?).
btw, I found dotdeb.org has been releasing updated mysql and php for lenny. But I'm too chicken to attempt things without checking with you or Till.
Last edited by Turbanator; 1st August 2010 at 21:04.