From owner-freebsd-questions@FreeBSD.ORG Sun Jul 6 14:42:28 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 6D876106567F for ; Sun, 6 Jul 2008 14:42:28 +0000 (UTC) (envelope-from chris@vindaloo.com) Received: from corellia.vindaloo.com (corellia.vindaloo.com [64.51.148.100]) by mx1.freebsd.org (Postfix) with ESMTP id 3C12F8FC1C for ; Sun, 6 Jul 2008 14:42:28 +0000 (UTC) (envelope-from chris@vindaloo.com) Received: from hadar.vindaloo.com (hadar.vindaloo.com [172.24.145.72]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by corellia.vindaloo.com (Postfix) with ESMTP id 1C4AC5CE3; Sun, 6 Jul 2008 10:42:16 -0400 (EDT) Message-Id: <52ADB97C-BBC8-47F8-AAAB-443CCC8ADA03@vindaloo.com> From: Christopher Sean Hilton To: Matthew Seaman In-Reply-To: <4870894E.7090708@infracaninophile.co.uk> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v926) Date: Sun, 6 Jul 2008 10:42:14 -0400 References: <4870894E.7090708@infracaninophile.co.uk> X-Mailer: Apple Mail (2.926) Cc: John Almberg , freebsd-questions@freebsd.org Subject: Re: Why would it make such a difference to move mysqld to another machine? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 06 Jul 2008 14:42:28 -0000 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 > database > onto it, separate from the web root and any other areas which apache > would be doing a lot of read/write operations on. > 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. -- Chris -- Chris Hilton chris-at-vindaloo-dot-com ------------------------------------------------------------------------ "All I was doing was trying to get home from work!" -- Rosa Parks