SMF Support > Server Performance and Configuration

Forum Loading on Database

(1/2) > >>

Firstly I am so much worried about my site url : [nofollow] this is a forum of stories . My forum has proximately 3000 something visitors per day . The problem is that In start I had uploaded my forum on godaddy share hosting but this usually this serrver remains down so I decided to transfer my data on host gator but when I had transferred my whole data from my previous hosting to host gator then Now I am facing the same problem which was on godaddy I was facing . Now I have recently received a mail from host gator which is below

This message is to advise you of a temporary block placed on your account. This account was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case.

Requests to this scripts under this account may become degraded by limiting the abilty for scripts to run for a limited amount of time, or if the issue persists, we may be forced to restrict how fast processes can be spawned until the issue has been resolved.

We recommend taking steps to reduce the overall CPU usage for the account, which may be as simple as generating a flat HTML page for popular content, or enabling caching that is available through many popular scripts, or disabling high CPU usage features such as searches or Ajax refreshes. Although we may not be able to help in all cases, we would be more than happy to assist if you are unable to determine any cause, or if you need help interpreting any of the information.

CPU seconds used in the past hour: 2860.83000000009, 80% CPU

Wed Aug 15 13:01:09 CDT 2012
Running Processes:
mudaber 21694 1.3 0.0 0 0 ? ZN 13:00 0:00 [php] <defunct>
mudaber 22064 9.0 0.0 0 0 ? ZN 13:01 0:00 [php] <defunct>
mudaber 22066 8.5 0.2 285676 23884 ? RN 13:01 0:00 /usr/bin/php /home/mudaber/public_html/how-to-romance/index.php
mudaber 22085 15.0 0.0 0 0 ? RN 13:01 0:00 [php]

Running Queries:
*************************** 1. row ***************************
USER: mudaber_smfn1
DB: mudaber_smfn1

Open connections

Current Site Requests:   /favicon.ico   /favicon.ico   /index.php/board,5.18/wap2.html   /index.php/board,5.18/wap2.html   /Themes/5th_RC2/images/ip.gif   /Themes/5th_RC2/images/ip.gif   /Themes/5th_RC2/images/post/xx.gif   /Themes/5th_RC2/images/post/xx.gif   /Themes/5th_RC2/images/topic/normal_post.gif   /Themes/5th_RC2/images/topic/normal_post.gif   /index.php?topic=420.0   /index.php?topic=420.0   /Themes/default/scripts/script.js?rc2   /Themes/default/scripts/script.js?rc2   /Themes/default/scripts/script.js?rc2   /Themes/default/scripts/script.js?rc2   /index.php/board,14.0.html?PHPSESSID=58271ea477f5b0751b8406   /index.php/board,14.0.html?PHPSESSID=58271ea477f5b0751b8406   /index.php/board,5.207/wap2.html?PHPSESSID=a65e54015e8ca2d4   /index.php/board,5.207/wap2.html?PHPSESSID=a65e54015e8ca2d4   /sex_problems/play.htm   /Themes/5th_RC2/images/upshrink2.png   /Themes/5th_RC2/images/upshrink2.png   /   /   /index.php/favicon.ico   /index.php/favicon.ico   /islam/madina_wallpapers.jpg   /islam/wallpaper_islam.jpg   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/5th_RC2/scripts/theme.js?rc2   /index.php/board,7.0/wap2.html   /index.php/board,7.0/wap2.html   /index.php/topic,114.0/nowap.html   /index.php/topic,114.0/nowap.html   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/5th_RC2/scripts/theme.js?rc2   /   /   /index.php   /index.php   /images/chat.jpg   /Themes/5th_RC2/images/tl.png   /Themes/5th_RC2/images/tl.png   /index.php?action=dlattach;attach=4;type=avatar   /index.php?action=dlattach;attach=4;type=avatar   /index.php/topic,208.0/wap2.html?PHPSESSID=0e47410c90501e08   /index.php/topic,208.0/wap2.html?PHPSESSID=0e47410c90501e08   /index.php?action=dlattach;attach=4;type=avatar   /index.php?action=dlattach;attach=4;type=avatar   /   /   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/default/css/print.css?rc2   /Themes/default/css/print.css?rc2   /Themes/5th_RC2/images/br.png   /Themes/5th_RC2/images/br.png   /Themes/5th_RC2/images/tl2.png   /Themes/5th_RC2/images/tl2.png   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /   /Themes/5th_RC2/images/upshrink.png   /Themes/5th_RC2/images/upshrink.png   /Themes/default/scripts/sha1.js   /Themes/default/scripts/sha1.js   /favicon.ico   /favicon.ico   /friends/wp-cron.php?doing_wp_cron=1345053438.136034965515   /   /   /   /   /index.php/favicon.ico   /index.php/favicon.ico   /   /   /images/logo.jpg   /   /   /   /   /Themes/5th_RC2/images/tr.png   /Themes/5th_RC2/images/tr.png   /sex_problems/images/centre.gif   /sex_problems/play.htm   /   /   /   /   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/default/css/print.css?rc2   /Themes/default/css/print.css?rc2   /animated_favicon.gif   /animated_favicon.gif   /favicon.ico   /favicon.ico   /   /   /index.php/board,8.0.html   /index.php/board,8.0.html   /Themes/5th_RC2/css/index.css?rc2   /Themes/5th_RC2/css/index.css?rc2   /Themes/default/css/webkit.css   /Themes/default/css/webkit.css   /index.php?board=35.0   /index.php?board=35.0   /Themes/5th_RC2/images/catbg.png   /Themes/5th_RC2/images/catbg.png   /Themes/5th_RC2/images/tl.png   /Themes/5th_RC2/images/tl.png   /index.php?topic=368.0;wap2   /index.php?topic=368.0;wap2   /favicon.ico   /favicon.ico   /   /   /favicon.ico   /favicon.ico   /index.php/board,11.0/wap2.html   /index.php/board,11.0/wap2.html   /index.php/board,11.0/wap2.html   /index.php/board,11.0/wap2.html   /Themes/default/css/wireless.css   /Themes/default/css/wireless.css   /index.php?topic=247.0;wap2   /index.php?topic=247.0;wap2   /favicon.ico   /favicon.ico   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/5th_RC2/scripts/theme.js?rc2   /super-slugger/feed/http:/   /super-slugger/feed/http:/   /Themes/5th_RC2/images/br.png   /Themes/5th_RC2/images/br.png   /Themes/default/css/wireless.css   /Themes/default/css/wireless.css   /Themes/5th_RC2/images/br2.png   /Themes/5th_RC2/images/br2.png   /Themes/5th_RC2/images/br3.png   /Themes/5th_RC2/images/br3.png   /Themes/5th_RC2/images/theme/menu_gfx.png   /Themes/5th_RC2/images/theme/menu_gfx.png   /Themes/5th_RC2/images/theme/submit_bg.png   /Themes/5th_RC2/images/theme/submit_bg.png   /Themes/default/css/print.css?rc2   /Themes/default/css/print.css?rc2   /Themes/default/css/wireless.css   /Themes/default/css/wireless.css   /   /   /   /   /index.php?action=dlattach;attach=4;type=avatar   /index.php?action=dlattach;attach=4;type=avatar   /   /   /favicon.ico   /images/ad.swf   /images/alphattack1.swf   /images/racead.swf   /images/search.swf   /404.htm   /   /   /   /   /Themes/5th_RC2/images/br3.png   /Themes/5th_RC2/images/br3.png   /Themes/5th_RC2/images/catbg.png   /Themes/5th_RC2/images/catbg.png   /Themes/5th_RC2/images/theme/submit_bg.png   /Themes/5th_RC2/images/theme/submit_bg.png   /Themes/5th_RC2/images/tr2.png   /Themes/5th_RC2/images/tr2.png   /index.php?board=6.0;wap2   /index.php?board=6.0;wap2   /Themes/default/scripts/script.js?rc2   /Themes/default/scripts/script.js?rc2   /index.php?nowap   /index.php?nowap   /   /   /index.php%3Ftopic%3D355.0   /index.php%3Ftopic%3D355.0   /favicon.ico   /favicon.ico   /index.php/board,5.126/wap.html?PHPSESSID=e618fd2fe9c2dc48a   /index.php/board,5.126/wap.html?PHPSESSID=e618fd2fe9c2dc48a   /index.php/board,5.207/wap.html?PHPSESSID=e618fd2fe9c2dc48a   /index.php/board,5.207/wap.html?PHPSESSID=e618fd2fe9c2dc48a   /Themes/5th_RC2/images/bl2.png   /Themes/5th_RC2/images/bl2.png   /Themes/5th_RC2/images/tr3.png   /Themes/5th_RC2/images/tr3.png   /favicon.ico   /favicon.ico   /index.php/board,13.0/nowap.html?PHPSESSID=d29cf96aa1290df9   /index.php/board,13.0/nowap.html?PHPSESSID=d29cf96aa1290df9   /index.php/board,13.0/wap.html?PHPSESSID=d29cf96aa1290df9d8   /index.php/board,13.0/wap.html?PHPSESSID=d29cf96aa1290df9d8   /index.php?topic=253.0;wap   /index.php?topic=253.0;wap   /   /   /favicon.ico   /favicon.ico   /   /   /   /   /   /   /index.php/topic,387.0/wap.html?PHPSESSID=4d854a0b1217fa5f6   /index.php/topic,387.0/wap.html?PHPSESSID=4d854a0b1217fa5f6   /favicon.ico   /favicon.ico   /favicon.ico   /news/jang.htm   /news/magazine/1akhbarejehan.htm   /sex_problems/play.htm   /favicon.ico   /favicon.ico   /Themes/5th_RC2/images/theme/submit_bg.png   /Themes/5th_RC2/images/theme/submit_bg.png   /   /   /index.php?board=11.0   /index.php?board=11.0   /Themes/default/scripts/script.js?fin20   /Themes/default/scripts/script.js?fin20   /   /   /Themes/5th_RC2/scripts/theme.js?rc2   /Themes/5th_RC2/scripts/theme.js?rc2   /favicon.ico   /favicon.ico   /   /   /   /   /robots.txt   /robots.txt   /index.php?board=29.0   /index.php?board=29.0   /   /   /images/ad.swf   /images/home.jpg   /images/music.jpg   /Themes/5th_RC2/images/new_none.png   /Themes/5th_RC2/images/new_none.png   /Themes/5th_RC2/images/br3.png   /Themes/5th_RC2/images/br3.png   /Themes/5th_RC2/images/catbg.png   /Themes/5th_RC2/images/catbg.png   /Themes/5th_RC2/images/collapse.gif   /Themes/5th_RC2/images/collapse.gif

The hostgator teams says to me that its problem of your forum script and you should consult with your script developers . Even I have already adopt instructions below ...

Change the avatars' upload folder.
The reason for this solution to decrease the overall server load generated by your forum is that SMF considers the avatars uploaded in the default folder as attachments and every loading of an avatar image invokes the index.php file. Moving them in a separate folder allows SMF to handle them as regular images.

To complete the specific optimization open the SMF admin area->Attachments and Avatars->Avatar Settings->Uploadable avatars. Pick the Specific directory... option from the Upload avatars to... drop-down menu.

Specify the Upload directory. For example you can put /home/user/public_html/forum/avt. You should create the new folder under your account. If you are using web hosting services from SiteGround you can create a new folder through cPanel->File Manager.

The Upload URL: value will be [nofollow]

The existing avatars can be moved using an FTP client. Also, you should execute the following MySQL query in the database:

UPDATE `smf_attachments` SET `attachmentType` = '1' WHERE `smf_attachments`.`ID_MEMBER` != 0

The query can be executed through cPanel->PhpMyAdmin.

Disable the RDNS (Reverse DNS) look-up.
The procedure can be completed from your SMF admin area->Configuration->Features and Options->Layout and Options. Make sure that the Disable hostname lookups? option is turned off. In this way reverse DNS queries will not be executed once a forum page is accessed.

Search method.
If you have enabled the Search option for your forum and it has grown quite big it is recommended to set a search index. Such a solution will increase the disk space used by your forum, but it will significantly improve the speed of the search queries. For large forums use the Custom search index. It can be set from the SMF admin area->Forum->Search->Search method.

Disable the recent posts functionality on the forum index.
This feature can be disabled by entering 0 in the SMF admin area->Configuration->Current Theme->Themes and Settings->Number of recent posts to display on board index field. This will improve the server performance since the compilation of the list can be a quite resource consuming process if there are many groups with posts.

Disable the SMF calendar.
If you do not need this feature on the forum, it is recommended to disable it. The reason is that the calendar functionality looks for an event on every thread load. The option can be disabled from the SMF admin area->Forum->Calendar->Calendar Settings.

Enable SMF caching.
This solution is suitable for large forums that usually run on a dedicated hosting solution. It requires the presence of one of the following accelerators: eAccelerator, Memcache, APC and more. It can be enabled from the SMF admin area->Configuration->Server Settings->Caching.

Now what should I do Please Please Please Help Me

青山 素子:
Hostgator is a large overseller. Not nearly as bad as GoDaddy, but still bad. If you find a better host, you'll likely have much less trouble. You also may have gone past the resources of what shared hosting can provide in general. What are the general resource needs of your site?

Firstly Please advice me a and and cheap host secondly I could not understand what kind of resources are you talking about and kindly tell me what should I do for this forum to get rid of this problem of database load

Chas Large:
A quick look at your site reveals you'll get a lot of hits when discussing "Pictures" from hidden web cams, almost every PORN seeker will go for those things. Your server resources requirement will be "high bandwidth" and "high CPU usage" with that kind of content.

there is no any kind of picture and no such contents which have load its just about stories and stories are in text I thing this SMF software is not good for sharing hosting It has heavy files and required heavy database


[0] Message Index

[#] Next page

Go to full version