Server Optimization

I need some help with server optimization. We already have a thread over at vbulletin.com:

http://www.vbulletin.com/forum/showthread.php?t=262464

But it's really not doing anything. Do you know of a company that can help or can you guys share some of your my.cnf settings?

We have 50,000+ members, over 1.3 million posts, and an average of 250 new members a day.

Whenever we have over 550 members simultaneously on the site, our server load can shoot up to 20+ which is insane. Our hardware is pretty well set up, one ded server for the db and one for the forum. Again, all the technical specs are in that vbulletin thread.

ANY help would be appreciated.

[SEOvB]

i know this is gonna sound stupid, but did you make the DB specific changes to the DB server and the http optimizations to that server?

[Ted S]

Since you're already getting help with the server setup let's delve into what's being run to make you have issues so much earlier than the "average" site.

Do you have any hacks installed? Multiple templates? Custom code you wrote?

When you say 600 memebrs, is that including guests or not? What's your total activity and guests to member ratio?

Have you run any sort of slow-query report to see what (if anything) is getting caught up?

[FreeLunchRoom]

Originally Posted by FRDS

i know this is gonna sound stupid, but did you make the DB specific changes to the DB server and the http optimizations to that server?

Yup.

[Angel-Wings]

<a href="http://forge.mysql.com/projects/view.php?id=44" target="_blank">http://forge.mysql.com/projects/view.php?id=44</a>

did you try using that tool already ?

[FreeLunchRoom]

Originally Posted by Ted S

Do you have any hacks installed? Multiple templates? Custom code you wrote?

Yes, vbulletin blog, vbseo, ibproarcade, flashchat and vbadvanced. Installed but not inuse: mass pm, mgc chatbox, payment system lite.

Originally Posted by Ted S

When you say 600 memebrs, is that including guests or not? What's your total activity and guests to member ratio?

Yes, that includes guests. Out of 600 users, I would say 475 - 525 are registered members.

Originally Posted by Ted S

Have you run any sort of slow-query report to see what (if anything) is getting caught up?

No, not yet...where can I do this? Is this within vbulletin?

--------------- Added [DATE]1205304360[/DATE] at [TIME]1205304360[/TIME] ---------------

Originally Posted by Angel-Wings

http://forge.mysql.com/projects/view.php?id=44

did you try using that tool already ?

No, I will try it tonight and report back tomorrow.

[andrewkhunn]

What kind of a connection do you have between the two servers?

[FreeLunchRoom]

Originally Posted by andrewkhunn

What kind of a connection do you have between the two servers?

I can't remember off the top of my head but it's not the problem. The server load is what is really bothering me. Just spikes when there are a lot of users on it. We're talking server load averages of 50 and higher.

[Marco van Herwaarden]

How do you know it is not (part of) your problem if you don't even remember?

[FreeLunchRoom]

Originally Posted by Marco van Herwaarden

How do you know it is not (part of) your problem if you don't even remember?

The servers are literally right next to each other....so it should be more than enough.

--------------- Added [DATE]1205364396[/DATE] at [TIME]1205364396[/TIME] ---------------

From doing more research it looks like our PM table are so huge its becoming corrupt...the database structure formating is odd...has anyone tried other db formats?