.Ian Posted February 16, 2014 Share Posted February 16, 2014 Hi, According to cPanel 5.1. is now well and truly EOL. The only other option to me at this point via cPanel is 5.5 (unless installing directly) Would you recommend an upgrade or should 5.1.7 be just fine for now? Thanks. Link to comment Share on other sites More sharing options...
stoo2000 Posted February 16, 2014 Share Posted February 16, 2014 Hi, According to cPanel 5.1. is now well and truly EOL. The only other option to me at this point via cPanel is 5.5 (unless installing directly) Would you recommend an upgrade or should 5.1.7 be just fine for now? Thanks. MySQL 5.6 is supported in 11.42, which is in the 'current' tier. I would encourage you to upgrade to 5.5 and then 5.6 when it's available. Link to comment Share on other sites More sharing options...
.Ian Posted February 16, 2014 Author Share Posted February 16, 2014 Hi - thanks - yes, I noticed that on their changelog, however I run the release version (too much a coward to do otherwise LOL ) I asked my server hosts, who did not seem too bothered by 5.1.7! Been having issues with high loads (200+), so have added a SSD for MySQL and reduced the polling on Spy to 10 secs as it only seems to hit me on Saturday afternoons - very frustrating, especially as the last 2 Saturdays I have been in the air! Mind you at least I was able to sort things thanks to free wifi in the plane!! I have to block everyone from my site, wait for a minute for the load to reduce, unblock and then the server seems happy again for another week. So decided to look at MySQL version as well. May just go ahead and upgrade anyway. Link to comment Share on other sites More sharing options...
stoo2000 Posted February 16, 2014 Share Posted February 16, 2014 Hi - thanks - yes, I noticed that on their changelog, however I run the release version (too much a coward to do otherwise LOL ) I asked my server hosts, who did not seem too bothered by 5.1.7! Been having issues with high loads (200+), so have added a SSD for MySQL and reduced the polling on Spy to 10 secs as it only seems to hit me on Saturday afternoons - very frustrating, especially as the last 2 Saturdays I have been in the air! Mind you at least I was able to sort things thanks to free wifi in the plane!! I have to block everyone from my site, wait for a minute for the load to reduce, unblock and then the server seems happy again for another week. So decided to look at MySQL version as well. May just go ahead and upgrade anyway. You should really upgrade to 5.5 for bugfixes, security fixes etc. It does also sound like your MySQL config hasn't even been tuned, or optimised for your server. 5.6 is supposed to bring some performance improvements. Link to comment Share on other sites More sharing options...
.Ian Posted February 16, 2014 Author Share Posted February 16, 2014 Thanks - they 'say' they have. Long time since I optimised MySQL myself to be honest, so tend to leave it to others. I can read 100 sites, and still not be 100% sure that I have it the best. Link to comment Share on other sites More sharing options...
stoo2000 Posted February 16, 2014 Share Posted February 16, 2014 Thanks - they 'say' they have. Long time since I optimised MySQL myself to be honest, so tend to leave it to others. I can read 100 sites, and still not be 100% sure that I have it the best. Running something like this script http://www.day32.com/MySQL/ will give you a guideline of how you're doing. Link to comment Share on other sites More sharing options...
.Ian Posted February 16, 2014 Author Share Posted February 16, 2014 Thanks. I have asked them to upgrade. Takes 2 hours apparently - seems a long time, but c'est la vie. Link to comment Share on other sites More sharing options...
.Ian Posted February 16, 2014 Author Share Posted February 16, 2014 All upgraded - will try those scripts - have run similar in the past. Link to comment Share on other sites More sharing options...
rct2·com Posted February 16, 2014 Share Posted February 16, 2014 The key thing here is EOL. IF you had problems with MySQL 5.1 and needed support, you would not have got it. You made the right decision to upgrade. :) If I were Invision, I would not be testing my forthcoming 4.0 against EOL versions of MySQL either... Link to comment Share on other sites More sharing options...
Rhett Posted February 16, 2014 Share Posted February 16, 2014 The key thing here is EOL. IF you had problems with MySQL 5.1 and needed support, you would not have got it. You made the right decision to upgrade. :smile: If I were Invision, I would not be testing my forthcoming 4.0 against EOL versions of MySQL either... We don't use mysql 5.1 here, so no worries :) however since it's still widely used and only recently EOL, yet still supported under extended Oracle support, we will likely test against it as well. I don't expect any issues however for those still using mysql 5.1. Link to comment Share on other sites More sharing options...
.Ian Posted February 25, 2014 Author Share Posted February 25, 2014 Thanks all :smile: Liquidweb reckon that my issues are all based on my PHP memory limit, which I must admit I have been running at 512mb for the last year or so without any issues at all. Strange as to why it should suddenly cause an issue without any new items added - a few upgrades, but nothing major. So am reducing that back down to 128mb - I must admit that 512mb was probably a bit high, especially with only 16gb of RAM My user processes always hover between 20 and 40 - so when that goes higher then so does the load. Fingers crossed.... Link to comment Share on other sites More sharing options...
rct2·com Posted February 25, 2014 Share Posted February 25, 2014 <snip> So am reducing that back down to 128mb - I must admit that 512mb was probably a bit high, especially with only 16gb of RAM My user processes always hover between 20 and 40 - so when that goes higher then so does the load. Fingers crossed.... What operating system are you running on your server? Link to comment Share on other sites More sharing options...
.Ian Posted February 25, 2014 Author Share Posted February 25, 2014 Centos 5.10 Link to comment Share on other sites More sharing options...
Dmacleo Posted February 25, 2014 Share Posted February 25, 2014 isn't 5.x also eol? thats a pita, iirc no easy 5 to 6 upgrade path Link to comment Share on other sites More sharing options...
rct2·com Posted February 25, 2014 Share Posted February 25, 2014 I've never seen loads >200. How many sites are running, and how many concurrent users? I assume it's dedicated? Link to comment Share on other sites More sharing options...
rct2·com Posted February 25, 2014 Share Posted February 25, 2014 5.10 will get maintenance updates until Q1 2017, and full updates for another 5 weeks. Link to comment Share on other sites More sharing options...
.Ian Posted February 25, 2014 Author Share Posted February 25, 2014 isn't 5.x also eol? thats a pita, iirc no easy 5 to 6 upgrade path Probably LOL My issue is that I used to understand an intel 286, 286 & 486 processors but now, I have no idea! The server is probably 2 or 3 years old and could probably do with replacing - but on say $300 a month I have no idea. I am happy with LW having had a torrid time with some other companies over the years and really need the fully managed approach. Better the devil you know..... Link to comment Share on other sites More sharing options...
Dmacleo Posted February 25, 2014 Share Posted February 25, 2014 5.10 will get maintenance updates until Q1 2017, and full updates for another 5 weeks. DOH !! I got 5.1 and 5.10 mixed up, thanks Link to comment Share on other sites More sharing options...
Makoto Posted March 11, 2014 Share Posted March 11, 2014 I've never seen loads >200. How many sites are running, and how many concurrent users? I assume it's dedicated? When your server load spikes that high, it's usually the result of I/O starvation. Or fork bombs. It can easily happen when your server runs out of memory and resorts to swapping as an example. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.