View Single Post
  #12  
Old 13 Mar 2008, 05:33
FreeLunchRoom FreeLunchRoom is offline
 
Join Date: Oct 2007
Originally Posted by andrewkhunn View Post
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 13 Mar 2008 at 02:08 ---------------

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.
Reply With Quote