SMF Support > Server Performance and Configuration

Forum Loading on Database

(1/2) > >>

Mudaber:
Firstly I am so much worried about my site url : http://www.how-to-romance.net [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
STATE:
TIME: 0
COMMAND: Sleep
INFO: NULL

Open connections

Current Site Requests:
1.38.13.4 howtoromance.achisite.com   /favicon.ico
1.38.13.4 howtoromance.achisite.com   /favicon.ico
1.38.13.4 howtoromance.achisite.com   /index.php/board,5.18/wap2.html
1.38.13.4 howtoromance.achisite.com   /index.php/board,5.18/wap2.html
1.38.17.32 howtoromance.achisite.com   /Themes/5th_RC2/images/ip.gif
1.38.17.32 howtoromance.achisite.com   /Themes/5th_RC2/images/ip.gif
1.38.26.35 howtoromance.achisite.com   /Themes/5th_RC2/images/post/xx.gif
1.38.26.35 howtoromance.achisite.com   /Themes/5th_RC2/images/post/xx.gif
1.38.26.35 howtoromance.achisite.com   /Themes/5th_RC2/images/topic/normal_post.gif
1.38.26.35 howtoromance.achisite.com   /Themes/5th_RC2/images/topic/normal_post.gif
101.209.252.78 howtoromance.achisite.com   /index.php?topic=420.0
101.209.252.78 howtoromance.achisite.com   /index.php?topic=420.0
101.210.117.173 howtoromance.achisite.com   /Themes/default/scripts/script.js?rc2
101.210.117.173 howtoromance.achisite.com   /Themes/default/scripts/script.js?rc2
101.63.104.161 howtoromance.achisite.com   /Themes/default/scripts/script.js?rc2
101.63.104.161 howtoromance.achisite.com   /Themes/default/scripts/script.js?rc2
101.63.104.161 howtoromance.achisite.com   /index.php/board,14.0.html?PHPSESSID=58271ea477f5b0751b8406
101.63.104.161 howtoromance.achisite.com   /index.php/board,14.0.html?PHPSESSID=58271ea477f5b0751b8406
106.200.115.251 howtoromance.achisite.com   /index.php/board,5.207/wap2.html?PHPSESSID=a65e54015e8ca2d4
106.200.115.251 howtoromance.achisite.com   /index.php/board,5.207/wap2.html?PHPSESSID=a65e54015e8ca2d4
110.172.163.91 achisite.com   /sex_problems/play.htm
110.172.163.91 howtoromance.achisite.com   /Themes/5th_RC2/images/upshrink2.png
110.172.163.91 howtoromance.achisite.com   /Themes/5th_RC2/images/upshrink2.png
110.38.2.93 howtoromance.achisite.com   /
110.38.2.93 howtoromance.achisite.com   /
110.38.2.93 howtoromance.achisite.com   /index.php/favicon.ico
110.38.2.93 howtoromance.achisite.com   /index.php/favicon.ico
111.92.140.102 achisite.com   /islam/madina_wallpapers.jpg
111.92.140.102 achisite.com   /islam/wallpaper_islam.jpg
115.167.47.103 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
115.167.47.103 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
115.249.25.252 howtoromance.achisite.com   /index.php/board,7.0/wap2.html
115.249.25.252 howtoromance.achisite.com   /index.php/board,7.0/wap2.html
115.249.44.252 howtoromance.achisite.com   /index.php/topic,114.0/nowap.html
115.249.44.252 howtoromance.achisite.com   /index.php/topic,114.0/nowap.html
115.251.238.8 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
115.251.238.8 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
115.42.72.83 howtoromance.achisite.com   /
115.42.72.83 howtoromance.achisite.com   /
117.228.222.227 howtoromance.achisite.com   /index.php
117.228.222.227 howtoromance.achisite.com   /index.php
119.154.227.120 achisite.com   /images/chat.jpg
119.155.2.8 howtoromance.achisite.com   /Themes/5th_RC2/images/tl.png
119.155.2.8 howtoromance.achisite.com   /Themes/5th_RC2/images/tl.png
119.155.24.77 howtoromance.achisite.com   /index.php?action=dlattach;attach=4;type=avatar
119.155.24.77 howtoromance.achisite.com   /index.php?action=dlattach;attach=4;type=avatar
119.160.126.102 howtoromance.achisite.com   /index.php/topic,208.0/wap2.html?PHPSESSID=0e47410c90501e08
119.160.126.102 howtoromance.achisite.com   /index.php/topic,208.0/wap2.html?PHPSESSID=0e47410c90501e08
124.253.50.166 howtoromance.achisite.com   /index.php?action=dlattach;attach=4;type=avatar
124.253.50.166 howtoromance.achisite.com   /index.php?action=dlattach;attach=4;type=avatar
139.190.109.214 howtoromance.achisite.com   /
139.190.109.214 howtoromance.achisite.com   /
139.190.109.214 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
139.190.109.214 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
139.190.109.214 howtoromance.achisite.com   /Themes/default/css/print.css?rc2
139.190.109.214 howtoromance.achisite.com   /Themes/default/css/print.css?rc2
141.0.10.105 howtoromance.achisite.com   /Themes/5th_RC2/images/br.png
141.0.10.105 howtoromance.achisite.com   /Themes/5th_RC2/images/br.png
141.0.10.105 howtoromance.achisite.com   /Themes/5th_RC2/images/tl2.png
141.0.10.105 howtoromance.achisite.com   /Themes/5th_RC2/images/tl2.png
141.0.10.181 howtoromance.achisite.com   /
141.0.10.181 howtoromance.achisite.com   /
141.0.10.181 howtoromance.achisite.com   /
141.0.10.181 howtoromance.achisite.com   /
141.0.8.113 howtoromance.achisite.com   /
141.0.8.113 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.142 howtoromance.achisite.com   /
141.0.9.230 howtoromance.achisite.com   /
141.0.9.230 howtoromance.achisite.com   /
141.0.9.230 howtoromance.achisite.com   /Themes/5th_RC2/images/upshrink.png
141.0.9.230 howtoromance.achisite.com   /Themes/5th_RC2/images/upshrink.png
141.0.9.230 howtoromance.achisite.com   /Themes/default/scripts/sha1.js
141.0.9.230 howtoromance.achisite.com   /Themes/default/scripts/sha1.js
141.0.9.230 howtoromance.achisite.com   /favicon.ico
141.0.9.230 howtoromance.achisite.com   /favicon.ico
174.132.167.66 achisite.com   /friends/wp-cron.php?doing_wp_cron=1345053438.136034965515
175.107.232.210 howtoromance.achisite.com   /
175.107.232.210 howtoromance.achisite.com   /
175.107.232.210 howtoromance.achisite.com   /
175.107.232.210 howtoromance.achisite.com   /
175.107.232.210 howtoromance.achisite.com   /index.php/favicon.ico
175.107.232.210 howtoromance.achisite.com   /index.php/favicon.ico
182.156.198.185 howtoromance.achisite.com   /
182.156.198.185 howtoromance.achisite.com   /
182.177.98.148 achisite.com   /images/logo.jpg
182.178.17.69 howtoromance.achisite.com   /
182.178.17.69 howtoromance.achisite.com   /
182.178.17.69 howtoromance.achisite.com   /
182.178.17.69 howtoromance.achisite.com   /
182.178.17.69 howtoromance.achisite.com   /Themes/5th_RC2/images/tr.png
182.178.17.69 howtoromance.achisite.com   /Themes/5th_RC2/images/tr.png
182.179.73.84 achisite.com   /sex_problems/images/centre.gif
182.185.114.116 achisite.com   /sex_problems/play.htm
182.185.114.116 howtoromance.achisite.com   /
182.185.114.116 howtoromance.achisite.com   /
182.185.114.116 howtoromance.achisite.com   /
182.185.114.116 howtoromance.achisite.com   /
182.185.114.116 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
182.185.114.116 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
182.185.114.116 howtoromance.achisite.com   /Themes/default/css/print.css?rc2
182.185.114.116 howtoromance.achisite.com   /Themes/default/css/print.css?rc2
182.185.114.116 howtoromance.achisite.com   /animated_favicon.gif
182.185.114.116 howtoromance.achisite.com   /animated_favicon.gif
182.185.114.116 howtoromance.achisite.com   /favicon.ico
182.185.114.116 howtoromance.achisite.com   /favicon.ico
182.185.207.152 howtoromance.achisite.com   /
182.185.207.152 howtoromance.achisite.com   /
182.185.207.152 howtoromance.achisite.com   /index.php/board,8.0.html
182.185.207.152 howtoromance.achisite.com   /index.php/board,8.0.html
182.187.36.114 howtoromance.achisite.com   /Themes/5th_RC2/css/index.css?rc2
182.187.36.114 howtoromance.achisite.com   /Themes/5th_RC2/css/index.css?rc2
182.187.36.114 howtoromance.achisite.com   /Themes/default/css/webkit.css
182.187.36.114 howtoromance.achisite.com   /Themes/default/css/webkit.css
182.187.36.114 howtoromance.achisite.com   /index.php?board=35.0
182.187.36.114 howtoromance.achisite.com   /index.php?board=35.0
182.187.79.204 howtoromance.achisite.com   /Themes/5th_RC2/images/catbg.png
182.187.79.204 howtoromance.achisite.com   /Themes/5th_RC2/images/catbg.png
182.187.79.204 howtoromance.achisite.com   /Themes/5th_RC2/images/tl.png
182.187.79.204 howtoromance.achisite.com   /Themes/5th_RC2/images/tl.png
202.69.15.156 howtoromance.achisite.com   /index.php?topic=368.0;wap2
202.69.15.156 howtoromance.achisite.com   /index.php?topic=368.0;wap2
203.88.22.140 howtoromance.achisite.com   /favicon.ico
203.88.22.140 howtoromance.achisite.com   /favicon.ico
203.88.22.142 howtoromance.achisite.com   /
203.88.22.142 howtoromance.achisite.com   /
203.88.23.34 howtoromance.achisite.com   /favicon.ico
203.88.23.34 howtoromance.achisite.com   /favicon.ico
203.88.23.37 howtoromance.achisite.com   /index.php/board,11.0/wap2.html
203.88.23.37 howtoromance.achisite.com   /index.php/board,11.0/wap2.html
203.88.23.37 howtoromance.achisite.com   /index.php/board,11.0/wap2.html
203.88.23.37 howtoromance.achisite.com   /index.php/board,11.0/wap2.html
203.88.23.38 howtoromance.achisite.com   /Themes/default/css/wireless.css
203.88.23.38 howtoromance.achisite.com   /Themes/default/css/wireless.css
203.88.23.38 howtoromance.achisite.com   /index.php?topic=247.0;wap2
203.88.23.38 howtoromance.achisite.com   /index.php?topic=247.0;wap2
203.88.6.38 howtoromance.achisite.com   /favicon.ico
203.88.6.38 howtoromance.achisite.com   /favicon.ico
204.93.60.129 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
204.93.60.129 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
213.186.119.136 myjoygames.achisite.com   /super-slugger/feed/http:/www.wibiy%20%20a.com/
213.186.119.136 myjoygames.achisite.com   /super-slugger/feed/http:/www.wibiy%20%20a.com/
213.231.96.32 howtoromance.achisite.com   /Themes/5th_RC2/images/br.png
213.231.96.32 howtoromance.achisite.com   /Themes/5th_RC2/images/br.png
218.248.65.140 howtoromance.achisite.com   /Themes/default/css/wireless.css
218.248.65.140 howtoromance.achisite.com   /Themes/default/css/wireless.css
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/br2.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/br2.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/br3.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/br3.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/menu_gfx.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/menu_gfx.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/submit_bg.png
221.120.246.8 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/submit_bg.png
221.120.246.8 howtoromance.achisite.com   /Themes/default/css/print.css?rc2
221.120.246.8 howtoromance.achisite.com   /Themes/default/css/print.css?rc2
223.183.119.180 howtoromance.achisite.com   /Themes/default/css/wireless.css
223.183.119.180 howtoromance.achisite.com   /Themes/default/css/wireless.css
39.45.15.44 howtoromance.achisite.com   /
39.45.15.44 howtoromance.achisite.com   /
39.45.15.44 howtoromance.achisite.com   /
39.45.15.44 howtoromance.achisite.com   /
39.47.128.148 howtoromance.achisite.com   /index.php?action=dlattach;attach=4;type=avatar
39.47.128.148 howtoromance.achisite.com   /index.php?action=dlattach;attach=4;type=avatar
39.47.14.56 howtoromance.achisite.com   /
39.47.14.56 howtoromance.achisite.com   /
39.52.88.75 achisite.com   /favicon.ico
39.52.88.75 achisite.com   /images/ad.swf
39.52.88.75 achisite.com   /images/alphattack1.swf
39.52.88.75 achisite.com   /images/racead.swf
39.52.88.75 achisite.com   /images/search.swf
39.53.241.149 achisite.com   /404.htm
39.54.115.118 howtoromance.achisite.com   /
39.54.115.118 howtoromance.achisite.com   /
39.54.115.118 howtoromance.achisite.com   /
39.54.115.118 howtoromance.achisite.com   /
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/br3.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/br3.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/catbg.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/catbg.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/submit_bg.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/submit_bg.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/tr2.png
42.106.175.148 howtoromance.achisite.com   /Themes/5th_RC2/images/tr2.png
42.107.175.149 howtoromance.achisite.com   /index.php?board=6.0;wap2
42.107.175.149 howtoromance.achisite.com   /index.php?board=6.0;wap2
42.83.84.9 howtoromance.achisite.com   /Themes/default/scripts/script.js?rc2
42.83.84.9 howtoromance.achisite.com   /Themes/default/scripts/script.js?rc2
42.83.84.9 howtoromance.achisite.com   /index.php?nowap
42.83.84.9 howtoromance.achisite.com   /index.php?nowap
42.83.85.19 howtoromance.achisite.com   /
42.83.85.19 howtoromance.achisite.com   /
42.83.85.19 howtoromance.achisite.com   /index.php%3Ftopic%3D355.0
42.83.85.19 howtoromance.achisite.com   /index.php%3Ftopic%3D355.0
65.255.37.139 howtoromance.achisite.com   /favicon.ico
65.255.37.139 howtoromance.achisite.com   /favicon.ico
65.255.37.145 howtoromance.achisite.com   /index.php/board,5.126/wap.html?PHPSESSID=e618fd2fe9c2dc48a
65.255.37.145 howtoromance.achisite.com   /index.php/board,5.126/wap.html?PHPSESSID=e618fd2fe9c2dc48a
65.255.37.145 howtoromance.achisite.com   /index.php/board,5.207/wap.html?PHPSESSID=e618fd2fe9c2dc48a
65.255.37.145 howtoromance.achisite.com   /index.php/board,5.207/wap.html?PHPSESSID=e618fd2fe9c2dc48a
65.255.37.157 howtoromance.achisite.com   /Themes/5th_RC2/images/bl2.png
65.255.37.157 howtoromance.achisite.com   /Themes/5th_RC2/images/bl2.png
65.255.37.157 howtoromance.achisite.com   /Themes/5th_RC2/images/tr3.png
65.255.37.157 howtoromance.achisite.com   /Themes/5th_RC2/images/tr3.png
65.255.37.157 howtoromance.achisite.com   /favicon.ico
65.255.37.157 howtoromance.achisite.com   /favicon.ico
65.255.37.157 howtoromance.achisite.com   /index.php/board,13.0/nowap.html?PHPSESSID=d29cf96aa1290df9
65.255.37.157 howtoromance.achisite.com   /index.php/board,13.0/nowap.html?PHPSESSID=d29cf96aa1290df9
65.255.37.157 howtoromance.achisite.com   /index.php/board,13.0/wap.html?PHPSESSID=d29cf96aa1290df9d8
65.255.37.157 howtoromance.achisite.com   /index.php/board,13.0/wap.html?PHPSESSID=d29cf96aa1290df9d8
65.255.37.157 howtoromance.achisite.com   /index.php?topic=253.0;wap
65.255.37.157 howtoromance.achisite.com   /index.php?topic=253.0;wap
65.255.37.173 howtoromance.achisite.com   /
65.255.37.173 howtoromance.achisite.com   /
65.255.37.173 howtoromance.achisite.com   /favicon.ico
65.255.37.173 howtoromance.achisite.com   /favicon.ico
65.255.37.177 howtoromance.achisite.com   /
65.255.37.177 howtoromance.achisite.com   /
65.255.37.177 howtoromance.achisite.com   /
65.255.37.177 howtoromance.achisite.com   /
65.255.37.177 howtoromance.achisite.com   /
65.255.37.177 howtoromance.achisite.com   /
65.255.37.177 howtoromance.achisite.com   /index.php/topic,387.0/wap.html?PHPSESSID=4d854a0b1217fa5f6
65.255.37.177 howtoromance.achisite.com   /index.php/topic,387.0/wap.html?PHPSESSID=4d854a0b1217fa5f6
65.255.37.193 achisite.com   /favicon.ico
65.255.37.209 howtoromance.achisite.com   /favicon.ico
65.255.37.209 howtoromance.achisite.com   /favicon.ico
66.249.73.12 achisite.com   /news/jang.htm
66.249.73.212 achisite.com   /news/magazine/1akhbarejehan.htm
66.54.75.199 achisite.com   /sex_problems/play.htm
66.54.75.222 howtoromance.achisite.com   /favicon.ico
66.54.75.222 howtoromance.achisite.com   /favicon.ico
66.54.75.224 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/submit_bg.png
66.54.75.224 howtoromance.achisite.com   /Themes/5th_RC2/images/theme/submit_bg.png
66.54.75.225 howtoromance.achisite.com   /
66.54.75.225 howtoromance.achisite.com   /
66.54.75.226 howtoromance.achisite.com   /index.php?board=11.0
66.54.75.226 howtoromance.achisite.com   /index.php?board=11.0
66.54.75.227 howtoromance.achisite.com   /Themes/default/scripts/script.js?fin20
66.54.75.227 howtoromance.achisite.com   /Themes/default/scripts/script.js?fin20
66.54.75.240 howtoromance.achisite.com   /
66.54.75.240 howtoromance.achisite.com   /
66.54.75.241 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
66.54.75.241 howtoromance.achisite.com   /Themes/5th_RC2/scripts/theme.js?rc2
66.54.75.246 howtoromance.achisite.com   /favicon.ico
66.54.75.246 howtoromance.achisite.com   /favicon.ico
69.31.51.45 howtoromance.achisite.com   /
69.31.51.45 howtoromance.achisite.com   /
74.111.33.106 achisite.com   /
74.111.33.106 achisite.com   /
74.111.33.106 achisite.com   /robots.txt
74.111.33.106 achisite.com   /robots.txt
74.125.16.86 howtoromance.achisite.com   /index.php?board=29.0
74.125.16.86 howtoromance.achisite.com   /index.php?board=29.0
82.145.211.121 howtoromance.achisite.com   /
82.145.211.121 howtoromance.achisite.com   /
85.194.70.122 achisite.com   /images/ad.swf
85.194.70.122 achisite.com   /images/home.jpg
85.194.70.122 achisite.com   /images/music.jpg
85.194.70.122 howtoromance.achisite.com   /Themes/5th_RC2/images/new_none.png
85.194.70.122 howtoromance.achisite.com   /Themes/5th_RC2/images/new_none.png
94.197.127.56 howtoromance.achisite.com   /Themes/5th_RC2/images/br3.png
94.197.127.56 howtoromance.achisite.com   /Themes/5th_RC2/images/br3.png
94.197.127.56 howtoromance.achisite.com   /Themes/5th_RC2/images/catbg.png
94.197.127.56 howtoromance.achisite.com   /Themes/5th_RC2/images/catbg.png
94.197.127.56 howtoromance.achisite.com   /Themes/5th_RC2/images/collapse.gif
94.197.127.56 howtoromance.achisite.com   /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 http://yourdomain.com/forum/avt/ [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?

Mudaber:
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.

Mudaber:
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

Navigation

[0] Message Index

[#] Next page

Go to full version