We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Hostgator Suspend My Script | Forum

Jelena
Jelena Sep 28 '11
Ok it hapens on hostgator shared hosting.
This is their email:
I apologize, but I was forced to suspend the script "/home/mladen/public_html/
index.php" as it was causing a high load on the server, and due to it affecting all of the other accounts on the system, I forced to take immediate action for the health of the server.

Unfortunately I do not have any specific recommendations for Oxwall Common script, however, in general, adding some sort of caching mechanism, where the script does not need to generate a new page with every request, helps to lower the over load that a script will cause. Likely the original author or support group of the software that you are using will be able to help you to understand how to add something of this nature.



Running Processes:
mladen 416 1.7 0.1 43204 22596 ? SN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 447 2.1 0.1 43204 22584 ? SN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 452 2.2 0.1 41124 20368 ? SN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 548 4.4 0.1 41372 20484 ? SN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 601 5.5 0.1 36212 15040 ? RN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 614 7.5 0.1 35072 14164 ? DN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 615 6.5 0.1 35072 14164 ? DN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 622 13.0 0.1 35072 14164 ? DN 16:29 0:00 /usr/bin/php /home/mladen/public_html/index.php
mladen 32662 0.9 0.1 43208 22604 ? SN 16:28 0:00 /usr/bin/php /home/mladen/public_html/index.php

Running Queries:
*************************** 1. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 1
COMMAND: Query
INFO: SELECT * FROM ow_base_user WHERE `id` = 201
*************************** 2. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 1
COMMAND: Query
INFO: SELECT * FROM ow_base_user WHERE `id` = 1823
*************************** 3. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 1
COMMAND: Query
INFO: SELECT * FROM ow_base_user WHERE `id` = 281
*************************** 4. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 0
COMMAND: Query
INFO: SELECT * FROM ow_base_user_online WHERE `userId` = 321 LIMIT 0, 1
*************************** 5. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 0
COMMAND: Query
INFO: SELECT * FROM ow_base_user_online WHERE `userId` = 371 LIMIT 0, 1
*************************** 6. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 2
COMMAND: Query
INFO: SELECT * FROM ow_base_user WHERE `id` = 1422
*************************** 7. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: closing tables
TIME: 2
COMMAND: Query
INFO: SELECT `p`.*, `t`.`title` FROM `ow_forum_post` AS `p`
INNER JOIN `ow_forum_topic` AS `t` ON(`p`.`topicId`=`t`.`id`)
WHERE `t`.`groupId` = '3'
ORDER BY `p`.`createStamp` DESC LIMIT 1
*************************** 8. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 1
COMMAND: Query
INFO: SELECT `entityId` AS `id`, COUNT(*) as `ratesCount`, AVG(`score`) as `avgScore`
FROM ow_base_rate
WHERE `entityType` = 'photo_rates' AND `active` = 1
GROUP BY `entityId`
ORDER BY `avgScore` DESC
LIMIT 0, 8
*************************** 9. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: Opening tables
TIME: 1
COMMAND: Query
INFO: SELECT `entityId` AS `id`, COUNT(*) as `ratesCount`, AVG(`score`) as `avgScore`
FROM ow_base_rate
WHERE `entityType` = 'photo_rates' AND `active` = 1
GROUP BY `entityId`
ORDER BY `avgScore` DESC
LIMIT 0, 8
*************************** 10. row ***************************
USER: mladen
DB: mladen_didonetwork
STATE: closing tables
TIME: 2
COMMAND: Query
INFO: SELECT `p`.*, `a`.`userId`
FROM `ow_photo` AS `p`
LEFT JOIN `ow_photo_album` AS `a` ON ( `p`.`albumId` = `a`.`id` )
LEFT JOIN `ow_photo_featured` AS `f` ON (`f`.`photoId`=`p`.`id`)
WHERE `p`.`status` = 'approved' AND `p`.`privacy` = 'everybody' AND `f`.`id` IS NOT NULL
ORDER BY `p`.`id` DESC
LIMIT 0, 8 



I have no expirience in programing something like that caching script. plugin or what do we need to optimaze the script.
But without that you can not have 90 users online in same time.
Does Oxwall working something in that way to optimaze the script because good shared hosting is much lover price then bad vps.
Can someone recomend me some good and cheap VPS hosting to hold my site?
The Forum post is edited by Jelena Sep 28 '11
Den Team
Den Oct 5 '11
The best is to migrate to VPS or dedicated server for now. Only with VPS or dedicated server, you will be able to setup optimization server software for better performance.
david frost
david frost Oct 14 '15
Agreed. Being on shared hosting is too much of a hassle. It feels like everything else is limited. Financially, it's worth it to upgrade. 
The Forum post is edited by david frost Oct 14 '15
Tammy
Tammy Oct 15 '15

Quote from Den The best is to migrate to VPS or dedicated server for now. Only with VPS or dedicated server, you will be able to setup optimization server software for better performance.
moving to a vps or dedicated just hides the problems
ross Team
ross Oct 15 '15
What problems?