masterunix Posted March 1, 2014 Share Posted March 1, 2014 Hello All, I have run Cubecart on my dedicated hosting for a long time now without many problems. However starting from today i have a huge problem. All my websites connected with SQL will have a problem ... saying max connections limit blabla. However ... we conacted the hosting and they changed it from max connection 25 to the limit 100. This helped for 1 hour and then it didnt work anymore ... same problem. I contacted my hosting company again and they found out the the username from one of my cubecart website is causing this problem to rerule the max connections to set as limit 10. This is causing the whole server to colapse. So after a long talk with hosting ... they same i need to talk with my "programmer" about this issue ... Can anyone help me to let cubecart optimize the cubecart site to get well with max connection usages? See attachment of the converstation i had with my hosting company. Please do not recommand me to get another hosting (yet) i already changed MANY times in MANY years and we have HUGE websites! I just want a solution to fix this ... if i am stuck in the end i will sell all websites, because after many years i am done with it and i need more rest then stressful headaches running webshops and websites. Thank you for your support and reading this. hosting.txt Quote Link to comment Share on other sites More sharing options...
masterunix Posted March 1, 2014 Author Share Posted March 1, 2014 ps: i forgot to mention i have more websites running on opencart and i must say i never had any problem with those ... so it all makes it complicated. If i turn down the cubecart websites everything is running fine ... Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 1, 2014 Share Posted March 1, 2014 Hi CubeCart in common with many / most applications doesnt close database connections but having max_connections set to 25 on a dedicated server running in your words "multiple large CubeCart websites would never work. That parameter can and should be increased but by itself it could cause problems as by the sound of it your server and my.cnf has never been configured and tuned for high MySQL throughput websites. Your hosting company should have been able to provide more information about this by examining server logs but by the sound of the conversation you dont have managed support and they arent being overly proactive to help. You need an expert in tuning the Linux side of the server and also my.cnf based on your server hardware spec (assuming the server is up to the job). Thanks Ian Quote Link to comment Share on other sites More sharing options...
masterunix Posted March 1, 2014 Author Share Posted March 1, 2014 @havenswift Are you able to do the job? Tweaking it to get it right? If so please pm me for the price. Also tell me if its possible to fix it ... if not i need to get rid of some websites. Please get back to me asap, Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 1, 2014 Share Posted March 1, 2014 Would you try either of these experiments? And are all your CubeCart installations at v5? In admin, Server Info (PHP Info), scroll to MySQL. Is it 'mysql' or mysqli'? In your php.ini file, enable the MYSQLI extension. CubeCart will use PHP's MySQLi method of connecting to the database server in favor of the MySQL method. MySQLi may have better user management -- I don't know if that's true. Don't disable the MySQL extension becasue it might be the case that other non-CubeCart applications may only want to use MySQL. Or, try this -- both the mysql.class.php and mysqli.class.php have their close() methods, but as best I can tell, CubeCart doesn't use them. (However, this command may be in the encoded files.) If that's the case, CubeCart relies on PHP that, when PHP is shutting down, PHP will properly terminate the connections to the database. Let's assume that relying on PHP is a mistake. In the file /class/db/database.class.php, near line 81, edit:Was: public function __destruct() { } Now: public function __destruct() { $this->close(); } I haven't tried this because I do not have the same environment as your server, so any test on my part wouldn't reveal anything. Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 1, 2014 Share Posted March 1, 2014 How do you determine your traffic levels? From a chart in your hosting control panel? Does the traffic graph include web-crawlers (Google, et al)? Quote Link to comment Share on other sites More sharing options...
masterunix Posted March 1, 2014 Author Share Posted March 1, 2014 I am pretty sure the problem is that i have a dedicated server and ofcourse it is unmanaged ... and i am not a linux administrator (however i am a skilled linux user, but i never worked for a hosting company or played with serious settings and stuff). I think i need someone who need to check out the dedicated server settings and set them up in the correct way. If there is someone reading this and feeling he can help me out, then please drop a message with your price to help me out. I am looking for a linux administrator with dedicated server experiences. @bsmither i will look at your solutions later ... i think the serious problem is the settings of the dedicated server in general ... after this has been fixed i can tweak up cubecart to make it better. Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 1, 2014 Share Posted March 1, 2014 I am pretty sure the problem is that i have a dedicated server and ofcourse it is unmanaged I think i need someone who need to check out the dedicated server settings and set them up in the correct way. If there is someone reading this and feeling he can help me out, then please drop a message with your price to help me out. I am looking for a linux administrator with dedicated server experiences. I will drop you a pm - we have experience of tuning dedicated servers for some VERY large CubeCart websites plus also for our range of shared hosting servers running mainly CubeCart sites (It is what we specialise in !) but to be honest whether it is possible depends on the hardware spec of your server and it is also impossible to give a fixed priced quote without knowing the state of your server and setup Thanks Ian Quote Link to comment Share on other sites More sharing options...
masterunix Posted March 3, 2014 Author Share Posted March 3, 2014 @havenswift-hosting Thank you for your answers and posting. I didn't know my server was unmanaged and that caused many problems. Now i hired a freelancer for a fixed price from Canada to fix it and i was lucky it was an expert on his word. Everything is running faster then before and no downtimes anymore! However ... IF there is a problem like this before i would like to be your customer (havenswift-hosting). Please send me a nice deal you have for a dedicated hosting WITH managed support. Since you focus on cubecart ... will opencart websites run smoothly as well on your server? We have more websites and not everything is in cubecart. Thanks all for your support! Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 7, 2014 Share Posted March 7, 2014 Hi Glad you got that problem fixed but running an unmanaged server (whether dedicated or a vps) unless you are an experienced linux administrator will leave you open to these types of things but worse still a huge number of security risks. While we are CubeCart specialists, Opencart is not that different at a server configuration and database tuning level and we have quite a few hosting clients running it so there would be no problem at all. More than happy to have a chat with you about a suitable server and managed hosting package but would need a lot more information about your current server, websites and server setup / load etc. If you are considering moving hosting then it is always better to do it when there are no problems rather than when in panic mode when there is a problem. We would build the server and then move a few sites across at a time to ensure no issues. If you are interested in exploring options then can you contact me via our website where we can discuss via live chat or better still support ticket. Thanks Ian Quote Link to comment Share on other sites More sharing options...
masterunix Posted May 4, 2014 Author Share Posted May 4, 2014 @havenswift I would like to migrate to your servers ... please see pm Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted May 5, 2014 Share Posted May 5, 2014 Hi PM and ticket answered last night and will continue to discuss via the ticket Thanks Ian Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.