From owner-freebsd-questions@FreeBSD.ORG Sun Jul 6 14:43:29 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 D372D1065695 for ; Sun, 6 Jul 2008 14:43:29 +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 9D6A38FC19 for ; Sun, 6 Jul 2008 14:43:29 +0000 (UTC) (envelope-from chris@vindaloo.com) Received: from yavin.vindaloo.com (yavin.vindaloo.com [172.24.144.34]) by corellia.vindaloo.com (Postfix) with ESMTP id 1FD1C5DB0 for ; Sun, 6 Jul 2008 10:43:29 -0400 (EDT) Received: by yavin.vindaloo.com (Postfix, from userid 1001) id CCF0225363; Sun, 6 Jul 2008 10:43:28 -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 X-Smtp-Server: smtp.vindaloo.com:chris 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> Resent-From: chris@vindaloo.com Resent-Date: Sun, 6 Jul 2008 10:43:28 -0400 Resent-To: freebsd-questions@freebsd.org Resent-Message-Id: <20080706144328.CCF0225363@yavin.vindaloo.com> 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:43:29 -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