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?
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?
