Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st August 2010, 01:44
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default deb lenny 64 isp3 mysql upgrade??

I seem to have issues related to mysql on my perfect server so...

Does anyone know if there is an updated mysql version for debian lenny x64?

And, if so, how would I update it and would it kill anything on an isp3 setup from the Perfect debian lenny isp3 howto?

current install: Server version: 5.0.51a-24+lenny4 (Debian)

TIA
Reply With Quote
Sponsored Links
  #2  
Old 1st August 2010, 18:20
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

According to http://packages.debian.org/search?su...keywords=mysql , this is the latest version.
What problems do you have?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 1st August 2010, 20:18
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default

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.
Reply With Quote
  #4  
Old 2nd August 2010, 14:08
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

I think it's a matter of tuinig MySQL parameters in your my.cnf.
do you have munin installed? That might help you identify the problem (might also be a slow hard drive).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 2nd August 2010, 21:16
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default

I think you're right with the mysql tuning. I made changes and incrwased max connections to 300. Things seems to be better. We get tons of spam so I wonder if the anti-spam and email processes are using most of my mysqlsql resources.

Will install munin now.
thank you
Reply With Quote
  #6  
Old 2nd August 2010, 21:58
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,372
Thanks: 833
Thanked 5,478 Times in 4,313 Posts
Default

If you have a lot of email traffic, I recommend to set max_connections and max_user_connections both to 500. Additionally, tune the mysql db with mysltuner:

http://www.faqforge.com/linux/optimi...th-mysqltuner/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 2nd August 2010, 22:03
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
 
Default

Thanx Till. just made the change and will analyze with mysqltuner, tuning-primer and munin.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Howto upgrade from Debian 4 (Etch) to Debian 5 (Lenny) Hans Tips/Tricks/Mods 2 1st December 2008 23:40
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
LAMP System Fedora Core 6 MySQL start error gavino HOWTO-Related Questions 13 21st November 2007 19:13
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 11:07.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.