CPU overload from Simple Machines

[Flavious]

I need some immediate help, and we are willing to pay! We have an extremely busy Simple Machines site that is having problems and this is the middle of our busy season!

The CPU on the server keeps getting overloaded. Clicking most parts of SMF and it just sits and spins saying "waiting for server". My hosting provider keeps saying it is a php script from simple machines that is using 100% of the CPU.

If you can help, please contact me asap.

[Kill Em All]

What version of SMF are you using?
http://www.simplemachines.org/community/index.php?topic=293441.msg1935333#msg1935333
http://www.simplemachines.org/community/index.php?topic=49999.0

[Flavious]

   SMF 1.1.11

[Kill Em All]

Take a look at both of those links, using a lot of those tips will help.

[Flavious]

Well it's getting worse. At a random time, someone will respond to a thread. Once the do, that thread appears to send the CPU into hyper overdrive, making the site inaccessable. If I can isolate the thread and delete it, everything is fine. Sometimes I have to hunt it down in the DB and delete it there, then run all the forum maintenance to straighten everything out.

[Kill Em All]

Is this on a dedicated server or a shared hosting server?

Who are you hosting with?

[Flavious]

Shared, but only 1 of a handful of sites on that box - aqhost.com

[stfox100]

Also, ask your host which process is using all the CPU. Index.php? index.template.php?
Is your RAM and MYSQL use also unusually high?

[Tyrsson]

WHat mods do you have installed?

[Flavious]

WHat mods do you have installed?

Aeva ~ Auto-Embed Video & Audio

[Flavious]

Also, ask your host which process is using all the CPU. Index.php? index.template.php?
Is your RAM and MYSQL use also unusually high?

As far as they are telling me, just index.php and it's just the cpu.
Thanks for the responses guys... losing my mind on this thing.

If I didn't mention it before.. I can look at the Last Post in a board that is locked up from the home page. If I then go into the database, I can delete that post and sometimes it clears everything up. If not, I have to delete the whole topic, then do all the maintenance stuff, and finally repair the DB from MySQL and it clears it up.. for awhile.

Hope any of this helps.

[Tyrsson]

Have you checked the support topic for this mod? It may have already been covered there as well as a fix posted. A link to the support topic can be found on the mod download page.

[Flavious]

I did not find anything there.. but a couple mentions of this not being a good idea for heavy traffic sites. If I just do the uninstall from the admin should that be enough to disable it?

[Kindred]

oh yes.... Aeva will probably increase server load

Also... If your forum is as busy as you say, you might want to consider a dedicated server.   At one of my sites, we went to a dedicated server ages ago because of the load of having a thousand members online at a time...

[Flavious]

About 100,000 unique visitors, 4-5 million page views. Worth a dedicated sever?

[Kindred]

per day? per week? per month?

[Something like that]

About 100,000 unique visitors, 4-5 million page views. Worth a dedicated sever?

Yep, a low end dedicated box would be my recommendation. Something with 2 GB+ of RAM.

I ran a site doing 1 million PHP requests daily on a single core box with 1 GB, and it was at its limits during peaks times, and it was heavily tuned.

[Flavious]

About 100,000 unique visitors, 4-5 million page views. Worth a dedicated sever?

Per month. Sorry...

Well I killed that video mod and it stopped... just waiting to see if it happens again.

[Something like that]

About 100,000 unique visitors, 4-5 million page views. Worth a dedicated sever?

Per month. Sorry...

Well I killed that video mod and it stopped... just waiting to see if it happens again.

If you want to make Aeva faster, enable only the sites that your members frequently use. For me, that's Youtube and Dailymotion. It's the checking for the number of sites that makes it so slow.

[Flavious]

Okay it happened again. The CPU is being chewed until the server grinds to a halt. Here's what we see on the server. This has not happened since we deleted that mod, and since then no other mods have been added. Any one have a clue?

========================================
PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
25701 gunty    20   0 34672  14m 6552 R 86.3  0.4   0:26.65 /usr/bin/php /home/gunty/public_html/bs/index.php
25313 gunty     20   0 34672  14m 6524 R 79.6  0.4   1:26.45 /usr/bin/php /home/gunty/public_html/bs/index.php
25745 gunty    20   0 34672  14m 6552 R 78.6  0.4   0:20.39 /usr/bin/php /home/gunty/public_html/bs/index.php
25747 gunty    20   0 34672  14m 6552 R 75.0  0.4   0:19.94 /usr/bin/php /home/gunty/public_html/bs/index.php
25575 gunty     20   0 34672  14m 6540 R 74.0  0.4   0:51.23 /usr/bin/php /home/gunty/public_html/bs/index.php
25495 gunty     20   0 34676  14m 6524 R 71.7  0.4   1:01.03 /usr/bin/php /home/gunty/public_html/bs/index.php
25144 gunty     20   0 35964  14m 6524 R 71.0  0.4   1:47.78 /usr/bin/php /home/gunty/public_html/bs/index.php
25258 gunty     20   0 34932  14m 6524 R 69.4  0.4   1:39.19 /usr/bin/php /home/gunty/public_html/bs/index.php
25681 gunty     20   0 34416  14m 6524 R 69.0  0.4   0:33.60 /usr/bin/php /home/gunty/public_html/bs/index.php
25341 gunty     20   0 34676  14m 6524 R 65.0  0.4   1:22.58 /usr/bin/php /home/gunty/public_html/bs/index.php
========================================

the column called "%CPU" shows cpu usage by each /home/gunty/public_html/bs/index.php instance, so if you summarize all this you will see that this script is critically overloading the server. There must be some bug in it that results in such huge CPU usage but anyway we can't let run many instances of it, eating 10x server CPU resources. Probably you should update your application or hire a web developer to debug/patch it to avoid such problems.

We had to disable this script again because it caused huge server load (~20).