peanut Posted May 29, 2012 Share Posted May 29, 2012 (edited) Hi My hosting provider is hostgator.in (Hostgator India) and for the past 2 days have been shutting my site down citing over use of server / resource load. I recently had a promotionally offer for my site and the traffic grew a little more and since then this is the trouble. Prior to this the site has been extremely slow. I'm on PS1.4.7 and I have opted for the baby croc shared hosting with Hostgator India. They ask me to optimize the MySql database and I use the optimize table function & deleted the ps_connections yet they continue to shut it down. Please help me since this is affecting me. Logs below: Hello, We are sorry for inconvenience but your account causing high loading issues on the server. Due to this affecting all of the other accounts on the system, we had to take immediate action for the health of the server. I will request you to please optimized your databases, script because your database are taken many query execution and increase the load. Unfortunately, we were forced to disable the script /home/domain/public_html/Store/index.php as it was causing high loading issues on the server. Running Processes: domain 16734 2.6 0.2 65312 41468 ? RN 16:19 0:09 /usr/bin/php /home/domain/public_html/Store/index.php domain 16826 2.5 0.2 65056 41088 ? RN 16:19 0:09 /usr/bin/php /home/domain/public_html/Store/index.php domain 19092 2.3 0.2 62752 38628 ? RN 16:20 0:06 /usr/bin/php /home/domain/public_html/Store/ index.php domain 20618 2.0 0.2 60960 37128 ? RN 16:21 0:04 /usr/bin/php /home/domain/public_html/Store/index.php domain 20690 2.0 0.2 60968 37140 ? SN 16:21 0:04 /usr/bin/php /home/domain/public_html/Store/index.php domain 20945 2.1 0.2 60960 36876 ? RN 16:21 0:04 /usr/bin/php /home/domain/public_html/Store/index.php domain 21442 0.0 0.0 36176 12552 ? SN 16:22 0:00 /usr/bin/php /home/domain/public_html/Store/statistics.php domain 25538 1.7 0.1 52724 28672 ? SN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 25549 1.8 0.1 52724 28676 ? SN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 25578 1.8 0.1 52724 28680 ? RN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 25617 1.7 0.1 52468 28412 ? SN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 25735 1.7 0.1 52464 28396 ? RN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 25905 1.8 0.1 52208 28392 ? SN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 25935 1.9 0.1 51076 27048 ? RN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/category.php domain 26165 1.8 0.1 52208 28152 ? RN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 26559 1.8 0.1 42036 17604 ? RN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 26562 1.8 0.1 42032 17328 ? RN 16:24 0:00 /usr/bin/php /home/domain/public_html/Store/cart.php domain 26634 2.5 0.0 35984 12468 ? RN 16:25 0:00 /usr/bin/php /home/domain/public_html/Store/cart.php domain 26712 1 .5 0.0 25564 5652 ? RN 16:25 0:00 /usr/bin/php /home/domain/public_html/Store/product.php domain 26739 2.0 0.0 24272 3144 ? RN 16:25 0:00 /usr/bin/php /home/domain/public_html/Store/prices-drop.php Running Queries: *************************** 1. row *************************** USER: hidden DB: hidden STATE: TIME: 1 COMMAND: Sleep INFO: NULL *************************** 2. row *************************** USER: hidden DB: hidden STATE: TIME: 1 COMMAND: Sleep INFO: NULL *************************** 3. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 4. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 5. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 6. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 7. row *************************** USER: hidden DB: hidden &nbs p; STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 8. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 9. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 10. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 11. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAN D: Sleep INFO: NULL *************************** 12. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 13. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 14. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL *************************** 15. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL ** ************************* 16. row *************************** USER: hidden DB: hidden STATE: TIME: 0 COMMAND: Sleep INFO: NULL Edited May 29, 2012 by peanut (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted May 29, 2012 Share Posted May 29, 2012 How many visitors do you get a day? It may be time to go to a VPS plan Link to comment Share on other sites More sharing options...
peanut Posted May 29, 2012 Author Share Posted May 29, 2012 Hi Tomerg3 I usually don't get too many, it's just that now I've promoted my site it's getting traffic. I'm not sure what VPS plan would suit me and worried I'll be paying a lot more than I probably need. Any hosting provider/plan suggestions? My target market is India. Thanks! Link to comment Share on other sites More sharing options...
tomerg3 Posted May 29, 2012 Share Posted May 29, 2012 Normally a VPS is about $40 a month, I do not know any in India. You didn't answer the question though, how many visitors do you get a month (now) Link to comment Share on other sites More sharing options...
peanut Posted May 29, 2012 Author Share Posted May 29, 2012 Can you suggest a VPS host so I can probably understand what I can find here. As of this month, the number of visits are 6,376 Link to comment Share on other sites More sharing options...
tomerg3 Posted May 29, 2012 Share Posted May 29, 2012 I don't know any hosts in India, and if that is your target audience, your best bet it to find a local host. Maybe there are suggestions in the forum, did you try to search? Link to comment Share on other sites More sharing options...
Scotty501 Posted May 29, 2012 Share Posted May 29, 2012 Try this link (Google is your friend) http://www.webhostingsearch.com/web-hosting/india.php Link to comment Share on other sites More sharing options...
jhnstcks Posted May 29, 2012 Share Posted May 29, 2012 Your only getting 6,300 visitors a month and they suspended your account? Time for a better host. Link to comment Share on other sites More sharing options...
peanut Posted May 30, 2012 Author Share Posted May 30, 2012 Thanks everyone, I'm trying to figure this out but now I have bigger problems! They enable smart caching & I enabled (now disabled) file system caching from the BO, and my site is broken. My homepage contains blocks from product page and any product I click takes me to one particular product only. This is really not helping the promotional activity I had & hence the traffic. Can anyone help? I have asked my host to disable the caching. And they keep telling me its my database that is causing the problem with its complex & long queries. Don't know how to fix that! Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 30, 2012 Share Posted May 30, 2012 Hi peanut, Per the rules of the PrestaShop forums, I would recommend that you consider using an alternate hosting provider, such as one of the ones we recommend at the bottom of the page under "Choose a Hosting" here. As for your other questions, per the rules of the PrestaShop forums, please post each issue as its own individual thread. -Mike Link to comment Share on other sites More sharing options...
Recommended Posts