Apache Spiking (Paying for a fix)

[Dark Navi]

Ok so I've had this problem from 4.1.12 to 4.2, my Apache CPU usage is spiking weirdly (Like 6 people connecting = a denial of service)

I've moved servers (first was a 1.8Ghz Dual core AMD with 6gb ram, current is a 3.4Ghz i7 with 2GB ram (manages slightly better obviously) but still unusable.

The plugins I have installed are:

I'm leaning toward it being a shoutbox problem, but I've used multiple shoutboxes including vbshout and inferno, all of which work perfectly on other sites.

If anyone is willing to help me out, I'm more than willing to pay you

[nhawk]

Hate to say it but if all that can connect is 6 users, that's a total server configuration problem. Not a problem with vBulletin.

And 2GB of memory isn't very much to work with. My site uses 2.2GB on average (including the MySQL and PHP caches).

[Dark Navi]

Originally Posted by nhawk

Hate to say it but if all that can connect is 6 users, that's a total server configuration problem. Not a problem with vBulletin.

And 2GB of memory isn't very much to work with. My site uses 2.2GB on average (including the MySQL and PHP caches).

I think you should re-read the post.

I've had 2 servers (same problem on each)
The issue is CPU based.

It's a problem with vBulletin/plugins.

[nhawk]

OK, well if that's what you think. Try disabling all mods and see if the number of users that can log in goes up or not.

[Dark Navi]

Originally Posted by nhawk

OK, well if that's what you think. Try disabling all mods and see if the number of users that can log in goes up or not.

It's not what I think.. It's what I know.. how can you question the obvious? If I have two perfectly fine servers that have handled multiple vB 3.x and 4.x forums simultaneously in the past, averaging 2400 members online at a time, why would they suddenly fail on a new installation of 4.2?

[nhawk]

Listen, you asked for help.

If you don't want to try disabling your mods to see if things improve, that's up to you.

But, many are running vB 4.2 with no problems and a total of 6 people being able to log on points to a server problem. Especially if it continues with all mods disabled.

If you want to dismiss what I suggest, that's fine. But please skip the attitude when you're the one looking for help.

With that, I'll bow out and let you and others find the problem without suggesting another thing.

[Dark Navi]

Why are you telling me I asked for help? I know I asked for help, I wrote the thread..

I dismissed your suggestions as I've already tried all of the obvious 'solutions', and posting here as a last resort.

[kh99]

Originally Posted by Dark Navi

I'm leaning toward it being a shoutbox problem, but I've used multiple shoutboxes including vbshout and inferno, all of which work perfectly on other sites.

Did you try temporarily disabling or uninstalling shoutbox? It may be that it worked fine before but now has a problem with vb4.2.0.

(BTW, if you want to pay someone to help you, you should post in the "Requests for Paid Services" forum).

[Dark Navi]

Originally Posted by kh99

Did you try temporarily disabling or uninstalling shoutbox? It may be that it worked fine before but now has a problem with vb4.2.0.

Had it disabled for most of today, it was recoded by JB from p0wersurge, and he runs 4.2 on his own forum with no issues :/ Although I'm leaning toward it being the shoutbox as well.

[Simon Lloyd]

check your mycnf file...etc, it may have been since an upgrade the number of simultaneous connections or max connections may be too low, also check that persistant connections in mysql is turned off.