Phpbb Causes extremely high load!

Fizman · Post by **Fizman** » Sun Dec 29, 2013 4:31 pm

My forum has been shutted be down.

Stats for 28 Dec 2013:
---------------------------------
CPU Usage - %1.60
MEM Usage - %5.87
Number of MySQL procs (average) - 27.54
Top Process %CPU 27.00 [php]
Top Process %CPU 11.00 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/posting.php
Top Process %CPU 5.50 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/posting.php

As such, we have been forced to temporarily suspend your account. You can access your control panel via https://tempest.lunarbreeze.com to modify your scripts.

Here are the most common causes for high usage:

- Your scripts are not upgraded: you may have not upgraded your scripts yet, as older versions of the scripts can have bugs in them that would cause high CPU and Memory usage

Lumpy Burgertushie · Post by **Lumpy Burgertushie** » Sun Dec 29, 2013 4:34 pm

normally phpbb does not do this.

Please fill out the Support Request Template Generator and post it back here to enable us to assist you better.

we need to see what MODs you may have installed etc. to try to figure out what is causing it.
also, what else in installed on the server.

are you getting a lot of spam etc.

robert

Fizman · Post by **Fizman** » Wed Jan 01, 2014 8:32 am

Now I got answer, I have original phpbb 3.0.8 without mods.

Hello,

Thank you for contacting us back regarding this issue.

Please note that we were forced to suspend the account because the high usage on it destabilized the server functionality. Please note that you are hosted on a shared server and you need to share resources with other customers. We need to provide our customers a fair share of the resource usage on the server where you are hosted too. Server resources often refer to the CPU,MySQL and RAM usage on a web hosting server. To put it in simple terms, this means your web hosting account is overloading the server to an extent where no other accounts on the same hosting server can function.

I unsuspended the account for you to be able to make further changes on it. Also I scan the account and there is no virus or infected file.

On a further check I noticed that your site veikkausforum.com is receiving unnecessary hits from different bots/IPs/spam, please see more information below:
=================================================
# Hits Files KBytes Visits Hostname
=================================================
1 28430 4.60% 1610 0.40% 262674 3.46% 0 0.00% 94.228.34.210
2 21778 3.53% 16713 4.12% 115378 1.52% 270 1.44% dsl-olubrasgw1-54fb51-228.dhcp.inet.fi
3 19507 3.16% 9138 2.25% 344357 4.53% 226 1.20% crawl-66-249-73-48.googlebot.com
4 19494 3.16% 5627 1.39% 62232 0.82% 364 1.94% 114.static.sea.rackd.net
5 18347 2.97% 2879 0.71% 258289 3.40% 0 0.00% 217.149.51.37
6 17465 2.83% 2729 0.67% 247754 3.26% 0 0.00% tengiz.whitevector.com
7 8993 1.46% 3631 0.90% 51698 0.68% 202 1.08% 192.74.236.242
8 8894 1.44% 5377 1.33% 230736 3.04% 63 0.34% 212.150.211.175
9 7663 1.24% 1174 0.29% 107730 1.42% 0 0.00% hegel.whitevector.com
10 6825 1.11% 6697 1.65% 69957 0.92% 231 1.23% host-62-106-15-52.phpoint.net
11 6453 1.05% 2603 0.64% 95693 1.26% 35 0.19% 91-145-112-67.bb.dnainternet.fi
12 6208 1.01% 2443 0.60% 34859 0.46% 157 0.84% 31.41.218.136
13 5586 0.90% 2172 0.54% 30194 0.40% 131 0.70% 216.244.80.50
14 5570 0.90% 2148 0.53% 31167 0.41% 296 1.58% 91-145-94-102.bb.dnainternet.fi
15 5540 0.90% 4720 1.16% 32072 0.42% 160 0.85% 82-128-235-52.bb.dnainternet.fi
16 5226 0.85% 2209 0.54% 34446 0.45% 195 1.04% 31.41.218.138
17 5055 0.82% 1985 0.49% 27791 0.37% 144 0.77% 216.244.82.50.static.onserver.com.br
18 4422 0.72% 1900 0.47% 30462 0.40% 138 0.73% 31.41.218.154
19 3929 0.64% 2336 0.58% 36409 0.48% 145 0.77% dsl-trebrasgw2-54f94f-210.dhcp.inet.fi
20 3523 0.57% 3502 0.86% 46048 0.61% 0 0.00% 91.200.14.55
21 3503 0.57% 3480 0.86% 47496 0.63% 0 0.00% 91.200.13.87
22 3405 0.55% 3267 0.81% 24953 0.33% 79 0.42% 212-149-252-221.bb.dnainternet.fi
23 3380 0.55% 3366 0.83% 44249 0.58% 0 0.00% 91.200.13.20
24 3334 0.54% 2485 0.61% 28037 0.37% 98 0.52% dsl-jklbrasgw2-54f8b6-45.dhcp.inet.fi
25 3231 0.52% 3216 0.79% 42343 0.56% 0 0.00% 91.200.13.18
26 2995 0.49% 2274 0.56% 68070 0.90% 196 1.04% pc-55-85.dsl.aina.net
27 2992 0.48% 1890 0.47% 30676 0.40% 71 0.38% dsl-trebrasgw2-54fb2e-198.dhcp.inet.fi
28 2900 0.47% 1979 0.49% 49250 0.65% 118 0.63% mcmxxviii.voas.sl-laajakaista.fi
29 2846 0.46% 959 0.24% 27805 0.37% 71 0.38% 82.195.192.6
30 2786 0.45% 2786 0.69% 39464 0.52% 0 0.00% modern.hardtofindfacenine.com
=================================================

In order to consult your account's detailed web-statistics you may use the Webalizer (Web Statistics) tool from your cPanel. You will find the most requested web pages or sub-pages (or resources), the IP addresses that are responsible for most of your web pages' hits, the hits / day or / month and other useful information.

Please use the robots.txt file to control access of the bots on your account. Robots are indexing your website, you may want to use a robots.txt file in order to manage this process. More information about it at: http://www.robotstxt.org/. Also you should block these IP addresses if you do not recognize them via the IP Deny Manager from your cPanel.

More than that you can use Google Webmaster Central Tool at https://www.google.com/webmasters/sitemaps/ to reduce the rate of crawling a domain or you can use the following link http://www.google.com/support/webmaster ... swer.py?an... to change the Google crawl rate.

Not all of the above are bad bots, because of that we advise you to check them with this online tool and block only the unnecessary:

http://centralops.net/co/

If you have any questions, please don't hesitate to ask us, we will be happy to answer them. Please feel free to contact us for further help.

What Ip:s I should ban?

RMcGirr83 · Post by **RMcGirr83** » Wed Jan 01, 2014 11:44 am

You got an answer from the host (a weak one at that) but didn't provide the information that Lumpy asked for.

Fizman · Post by **Fizman** » Fri Jan 03, 2014 6:03 am

Support Request Template
What version of phpBB are you using? phpBB 3.0.10
What is your board's URL? http://www.veikkausforum.com/keskustelu
Who do you host your board with? http://www.lunarpages.com/
How did you install your board? Someone else installed my board for me
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
What version of phpBB3 did you update from? phpBB 3.0.10
What styles do you currently have installed? Prosilver, subsilver
What language(s) is your board currently using? Finnish
Which database type/version are you using? MS SQL Server
What is your level of experience? New to PHP but not phpBB
When did your problem begin? 2 weeks ago
Please describe your problem. My registered users started to complain about board not working properly. It is lagging like hell.
Generated by SRT Generator

Fizman · Post by **Fizman** » Sun Jan 05, 2014 7:00 am

Any ideas?

Oyabun1 · Post by **Oyabun1** » Sun Jan 05, 2014 9:15 pm

Since you have no MODs update the board using the file replacement method.

Before proceeding backup all files and the database.

Download the full package.
Unzip to your desktop and open the phpBB3 folder.
Remove (delete) the config.php file, and the /images and /files folders from the package.
Via FTP or SSH upload the remaining files and folders to the root of your board installation on the server overwriting the existing files.
In your browser go to http://www.veikkausforum.com/keskustelu ... update.php
Let that run to completion.
Via FTP or SSH delete the /install folder from the root of your board installation.
Done.

You now have a new up to date board containing all your users and posts but without any MODs that you might have had installed.

Only use a good FTP or SSH client, such as FileZilla, to transfer the files. (File transfer utilities provided in host control panels can cause problems.)

mandrake88 · Post by **mandrake88** » Sun Jan 05, 2014 10:01 pm

Seems odd to me that nobody asked about the amount of users of the forum.

How many users online do u have in any given time? how many users online do u have in rush hour?

In my experience, most of the shared hosting services will fail with a forum that have 25 or more online users at any given time. You can't expect much more form a crappy shared hosting...

p.d: if u have too many bots/gues u can try using this mod https://www.phpbb.com/customise/db/mod/cgp/

p.d2: disable gzip, it will reduce cpu load. And make sure that guest can't use search in the forum

Oyabun1 wrote:Since you have no MODs update the board using the file replacement method.

format c: solution? do u really call that "support"? ....

Lumpy Burgertushie · Post by **Lumpy Burgertushie** » Sun Jan 05, 2014 10:21 pm

that advice is nothing at all like "format c:" . replacing the files is a very quick and simple way to eleminate the possibility of it being a corrupt file.
it is not reinstalling, it is not wiping anything out etc.

you will notice that he said, "since you have no MODs installed".

your advice about the number of users can somtimes be correct. however, when that is the case, it normally causes the "too many connections" errors from the server, not cpu usage errors.

the most common cause of the cpu usage errors is the host trying to get you to upgrade to a better /more expensive hosting plan.

next would probably be a problem with a bad MOD or some corrupt files. hence the advice to replace all the files with new good ones.

robert

Fizman · Post by **Fizman** » Mon Jan 06, 2014 9:09 am

I think there is some problem with both. I have installed some mod which did not work ( seo mod) and rush hours are way below what it was, I used to have 100 online at the time. Now the problem is that LUNARPAGES are not sending me the domain transfer verification code?? What I should do? I bought cheap host from godaddy, but Im maybe using it for some other website. What host you suggest in Europe for phpbb?

Fizman · Post by **Fizman** » Mon Jan 06, 2014 2:14 pm

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Apache/2.2.24 (Unix) mod_ssl/2.2.24 OpenSSL/0.9.7a mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.6 Server at keskustelu.veikkausforum.com Port 80 what does this mean?

Fizman · Post by **Fizman** » Mon Jan 06, 2014 4:11 pm

Damn...I just uploaded all files to phpbb root 3.08.12 update 3.08.10 and now : Fatal error: Call to a member function on a non-object in /home/veikk1/public_html/keskustelu/index.php on line 24

And no backup at the moment.

mandrake88 · Post by **mandrake88** » Mon Jan 06, 2014 4:23 pm

100 users online in a shared hosting? No way, that is too much for a shared hosting. You need a vps, shared hostings cant handle that amount of traffic. U need a vps server asap.

Oyabun1 · Post by **Oyabun1** » Mon Jan 06, 2014 9:32 pm

Fizman wrote:I just uploaded all files to phpbb root 3.08.12 update 3.08.10

phpBB doesn't have either of those versions?

Why not just follow the instructions you were given? There was no mention of an update package and you were told to backup first.

Oyabun1 wrote:Before proceeding backup all files and the database.

Download the full package.

...

Fizman · Post by **Fizman** » Tue Jan 14, 2014 11:05 pm

After strugling in another thread, forum is back online. BUT:

Hello Juha,

Thank you for contacting Lunarpages Internet Solutions & Web Hosting.

I have checked and see that your account has reached the allowed resources usage on the server, which is causing the site at URL http://keskustelu.veikkausforum.com to not load.

Stats for 14 Jan 2014:
---------------------------------
CPU Usage - %0.48
MEM Usage - %2.23
Number of MySQL procs (average) - 10.72
Top Process %CPU 10.00 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/viewtopic.php
Top Process %CPU 8.00 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/viewforum.php
Top Process %CPU 4.00 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/viewtopic.php

Stats for 13 Jan 2014:
---------------------------------
CPU Usage - %0.03
MEM Usage - %0.51
Number of MySQL procs (average) - 1.62
Top Process %CPU 2.20 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/index.php
Top Process %CPU 0.30 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/viewtopic.php
Top Process %CPU 0.20 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/search.php

Stats for 12 Jan 2014:
---------------------------------
CPU Usage - %0.31
MEM Usage - %2.91
Number of MySQL procs (average) - 13.91
Top Process %CPU 13.00 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/viewforum.php
Top Process %CPU 4.50 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/index.php
Top Process %CPU 3.50 /usr/php4/bin/php /home/veikk1/public_html/keskustelu/ucp.php What does this mean?