Your posts aren't making much sense. How big is your PM table?

Also, the connection between the two servers matters because if connections between Apache and MySQL are being routed through 10mbps wire, you're going to have load issues while processes stack on top of one another waiting for communication.

I was experiencing symptoms similar to what you are describing when my servers were unknowingly auto-negotiating at 10mbps. Once I got upgraded to 100mbit everything evened back out. Also, their physical distance has little/nothing to do with it.

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

Also, please run this script and copy/paste the output here (between 2 code brackets): http://forge.mysql.com/projects/view.php?id=44

It is 100mbit. Will run the query and paste it. But we rebuilt the PM table and seems to have cooled down a bit.

Also, what kind of hard drives do you have? I know they're RAID1, but what interface and rotational speed?

Also are you sure that they have (and are using!!) a direct connection. Seen before that 2 servers next to eachother where routing their inter-server traffic over the outside internet connection.

In addition to the server suggestions at vbulletin.com.

Upgrade MySQL.

Make sure you have the latest Apache 2 - we also had problems with a particular version. (Don't remember which one.)


Check the # of queries running on your site (per page) ...

Check each custom query and make sure
1)__ they are optimized
2)__ are using index whenever possible
3)__ ensure that SELECTs are retrieving from the SLAVE server and not the MASTER (check processlist)

NOTES
- only use necessary plugins - those that add value to your site
--- I recommend removing the arcade.
- vbseo has all their queries fetching from MASTER. :down:
- vbadvanced - I'm sure there's some queries that are going to MASTER when they should be going to SLAVE.