spirits999 Posted March 6, 2013 Share Posted March 6, 2013 I have a 4gh hosting on Godaddy and our site rationhut dot com has been running perfectly fine from the last 4 months, until recently we did some local advertising and saw a decent spike of 1k users and dropped back to about 300-400 visitors a day. Post that, the site has been behaving extremely weird. Sometimes slow, sometimes fast and sometimes it throws a 500 internal server error. We spoke to the godaddy folks and they recommended to go for a dedicated server. The reason they told us that the system processes being generated are very high and which is why the site goes slow. I have few questions based on their priority 1. Is there any quick temporary solution that I can do to have my site quickly running back to normal atleast for a few hours and after it goes slow again, perform the same action (something like a refresh server) 2. Is 300-400 visitors really bad for a 4GH hosting? I mean thats barely anything. 3. Why is the site randomly slow even when there are no users? 4. If we have to move to a Dedicated server, what is your recommendation on which prestashop will perform best on. Link to comment Share on other sites More sharing options...
spirits999 Posted March 6, 2013 Author Share Posted March 6, 2013 After about 4 days of research This looks like a DB problem. I put up a static page and it takes less than 0.4 seconds to load. People recommend to clear up Guest carts and also clear up stats(clean automatically) What is your take on it? Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 This thing is still not solved. The server guys set FastCGI to off and it worked pretty well for about 2-3 hours. VEry fast. However, the site has gone slow again and I'm really in need of some help. Link to comment Share on other sites More sharing options...
tomerg3 Posted March 7, 2013 Share Posted March 7, 2013 You lost me at GoDaddy, one of the worst hosting companies in the world. Switch Switch Switch! If for some reason you do not want to change, you can try to turn on dev mode in PS and look at the massive printout at the bottom of the page. It has stats about every single sql query, as well as other load times, it should help you identify what is taking so long. Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 7, 2013 Share Posted March 7, 2013 I agree, I do not think you should switch to a dedicated server with GoDaddy. You should switch, there are many hosting companies that people have better results with. PrestaShop is partners with A2Hosting and BlueHost. Link to comment Share on other sites More sharing options...
Dh42 Posted March 7, 2013 Share Posted March 7, 2013 A godaddy dedicated server is false advertising in my opinion. When I think dedicated server, I think everything on one machine unless you are in an enterprise class and you are running dedicated sql servers, but that is a whole other class. Godaddy still farms its sql out when you are on a dedicated. Just about every instance I have seen with a customer and a godaddy problem, it is database latency. So getting a dedicated machine, but using shared sql hosting is a joke. Plus look at the processor specs on those things, my laptop uses a better processor. Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 Guys, Thank you so much! I really appreciate some reply at least and some hope. We are startups struggling really hard to make this a success and no replies really meant we were going no where. I agree to the fact that it must be Godaddy, however I would still want to know what exactly is the root cause. Mainly, because we barely have about 300-400 visitors a day with about 4-5 concurrent users. The system fails badly even when there are 2-3 concurrent users. I realized that I had made some 1500+ 500 vouchers for a local advertising campaign. and it was working fine, until everyone started pointing that their vouchers werent working. So we saw that the categories werent selected and are only option was to update and select all the categories manually. We started seeing this slowdown. What is your opinion. Next step is that if not Godaddy, then who's the best, reliable and also cheap as we cannot afford it that easily. Link to comment Share on other sites More sharing options...
Dh42 Posted March 7, 2013 Share Posted March 7, 2013 I use webhosting buzz, they are like $10 a month for the account I recommend to my clients. Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 Thanks DH42. I will definitely start analyzing on this and move soon if nothing works out. Can you tell me what Toberg is trying to say. "If for some reason you do not want to change, you can try to turn on dev mode in PS and look at the massive printout at the bottom of the page. It has stats about every single sql query, as well as other load times, it should help you identify what is taking so long. " I tried doing the following Put the site on maintenance mode, added my IP, edited the defines.inc.php file, changed dev mode to true. I was expecting the site to load up with the errors/stats of every single sql query, but it did not show me anything different. Help please. Link to comment Share on other sites More sharing options...
Dh42 Posted March 7, 2013 Share Posted March 7, 2013 In the file /config/defines.inc.php file you can turn dev mode on and it will display times for all of your sql queries and time it takes to build the template. If you go to http://thesocialfont.com/index.php scroll down the page, that is what dev mode prints out Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 Hey! I tried doing the same thing but it would just not show something like that on the frontend or backend. Do I have to set display erros on or off? Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 7, 2013 Share Posted March 7, 2013 Hello, if you could Turn Display Errors on and Dev Mode to True, and it should work. Is it not? Link to comment Share on other sites More sharing options...
Dh42 Posted March 7, 2013 Share Posted March 7, 2013 This is what the setting look like on that site, http://screencast.com/t/Vz9LWoMjB Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 I did the following changes In Config File Changed Display errors to on Changed PS_debug_sql to true In Defines.inc.php file changed ps_modedev to true changed ps_mode_demo to true But it did not show me any stats like the example stated Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 Thanks for the screenshot Just so that we are on the same page. I'm on 1.4.7.0. Can I add the line Debug profiling separately? Link to comment Share on other sites More sharing options...
Dh42 Posted March 7, 2013 Share Posted March 7, 2013 Oh, sorry, I thought you were on 1.5.. that only works with 1.5 Link to comment Share on other sites More sharing options...
spirits999 Posted March 7, 2013 Author Share Posted March 7, 2013 (( Now???????? Any other suggestions? What do you guys have to say about the vouchers thingy? Link to comment Share on other sites More sharing options...
spirits999 Posted March 8, 2013 Author Share Posted March 8, 2013 Guys! Please! Sommmmmmmmmmmeeeone! Link to comment Share on other sites More sharing options...
Okidoki Posted March 8, 2013 Share Posted March 8, 2013 I have the same issue. I´m changing to a VPS now. Dont know if the problem will be solved. Link to comment Share on other sites More sharing options...
spirits999 Posted March 8, 2013 Author Share Posted March 8, 2013 Let me know. Also let me know which one did you move on to. Link to comment Share on other sites More sharing options...
spirits999 Posted March 9, 2013 Author Share Posted March 9, 2013 Quick Update. Now i'm reaching closer to the problem 2 strong observations 1. I had a backup of the database from the month of September. I imported it to a new database, pointed prestashop to that database and bingo! It started working perfectly fine. 2. I tried exporting the current database, imported it to another database and it threw an error. <!Doctype not recognized by SQL. Read somewhere that one should not feed HTML to the SQL engine. This makes me wonder, that I had a HTML box module installed on my site. Although when I installed it, there were no performance difference. What's your take on it? Can anyone help me sorting out the import database error? Link to comment Share on other sites More sharing options...
spirits999 Posted March 12, 2013 Author Share Posted March 12, 2013 OK! Now the doctype error was because the tables were not exported completely. With no solution in hand, the only thing that worked for me is I took a backup of the db, restored it in a new db and pointed my site to the new db. It seems it is working fine now, but I will have to keep observing. Appreciate everyone's contribution towards this. Link to comment Share on other sites More sharing options...
Matt Serralta Posted March 12, 2013 Share Posted March 12, 2013 Hello, Feel free to give me a call at 888 947 6543, I would love to help you figure out how to best configure you servers to run optimally with PrestaShop... We have a hard time with GoDaddy and their dedicated server is not really dedicated... Give me a call and I will share ideas with you. Link to comment Share on other sites More sharing options...
spirits999 Posted March 13, 2013 Author Share Posted March 13, 2013 I will call at your country day time. If this is true, I appreciate you extending your help in the most personal way. This will be highly appreciated with every prestashop and the whole world outside if this kind of support is readily available. 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts