Why would it make such a difference to move mysqld to another machine?

2008-07-05 Thread John Almberg
I asked a question the other day about using top on a multi-processor machine. As a side note, I asked how mysqld could be consuming more than 100% of CPU power... last pid: 43730; load averages: 1.93, 2.64, 2.22 up 92+19:45:54 09:26:27 238 pr

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread Matthew Seaman
John Almberg wrote: Luckily, I have a pretty powerful machine sitting right next to my main webserver that I mainly use for backup. The two servers are directly connected to each other with a twisted ethernet cable, using extra NIC cards in the machines, so they have a fast, dedicated 'LAN' to

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread Christopher Sean Hilton
On Jul 6, 2008, at 4:58 AM, Matthew Seaman wrote: John Almberg wrote: [snip] In the second case, it's really just about competition for resources. I suspect that you could have achieved a pretty good speed-up simply by adding another hard drive to your server and moving all of the dat

Fwd: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread John Almberg
On Jul 6, 2008, at 4:58 AM, Matthew Seaman wrote: John Almberg wrote: Luckily, I have a pretty powerful machine sitting right next to my main webserver that I mainly use for backup. The two servers are directly connected to each other with a twisted ethernet cable, using extra NIC cards in

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread Mel
On Sunday 06 July 2008 10:58:54 Matthew Seaman wrote: > I suspect that you could have achieved a pretty good speed-up simply by > adding another hard drive to your server and moving all of the database > onto it, separate from the web root and any other areas which apache > would be doing a lot of

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread John Almberg
When I go back and look at the original top output for the single machine I note that it's out of RAM. It looks to me like apache and mysqld were contending over memory. Can you explain this idea in more detail, Chris? I thought this TOP display indicated that there was still 2G free. A

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread John Almberg
Since MySQL is clearly the bottleneck of the sites, I'd investigate why in the world apache2 needs >150M per process. Now that was a darn good question. I ran httpd -M and got a list of 60 loaded modules... duh. I said before I'm just a beginner Admin. I'm learning a lot, but some of these

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-06 Thread Christopher Sean Hilton
On Jul 6, 2008, at 5:10 PM, John Almberg wrote: Since MySQL is clearly the bottleneck of the sites, I'd investigate why in the world apache2 needs >150M per process. Now that was a darn good question. I ran httpd -M and got a list of 60 loaded modules... duh. I said before I'm just a begi

Re: Why would it make such a difference to move mysqld to another machine?

2008-07-07 Thread Michael Powell
John Almberg wrote: > I asked a question the other day about using top on a multi-processor > machine. As a side note, I asked how mysqld could be consuming more > than 100% of CPU power... [snip] > Well, that mysqld reading should have been a warning to me. This > weekend, my webserver with abou