From owner-freebsd-questions@FreeBSD.ORG Sun Jul 6 16:13:59 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 2DF451065686 for ; Sun, 6 Jul 2008 16:13:59 +0000 (UTC) (envelope-from jalmberg@identry.com) Received: from mx1.identry.com (on.identry.com [66.111.0.194]) by mx1.freebsd.org (Postfix) with ESMTP id AEA778FC1A for ; Sun, 6 Jul 2008 16:13:58 +0000 (UTC) (envelope-from jalmberg@identry.com) Received: (qmail 47601 invoked by uid 89); 6 Jul 2008 16:13:58 -0000 Received: from unknown (HELO ?192.168.1.110?) (jalmberg@75.127.142.66) by mx1.identry.com with ESMTPA; 6 Jul 2008 16:13:58 -0000 In-Reply-To: <52ADB97C-BBC8-47F8-AAAB-443CCC8ADA03@vindaloo.com> References: <4870894E.7090708@infracaninophile.co.uk> <52ADB97C-BBC8-47F8-AAAB-443CCC8ADA03@vindaloo.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <532521D3-E0A6-4639-88C3-47FEDE62C9A4@identry.com> Content-Transfer-Encoding: 7bit From: John Almberg Date: Sun, 6 Jul 2008 12:13:56 -0400 To: Christopher Sean Hilton X-Mailer: Apple Mail (2.752.3) Cc: 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 16:13:59 -0000 > > 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. Am I interpreting it wrong? How can you tell that it's out of RAM? Thanks: John last pid: 43730; load averages: 1.93, 2.64, 2.22 up 92+19:45:54 09:26:27 238 processes: 3 running, 235 sleeping CPU states: 8.1% user, 0.0% nice, 17.3% system, 0.2% interrupt, 74.4% idle Mem: 1384M Active, 3753M Inact, 373M Wired, 884K Cache, 214M Buf, 2150M Free Swap: 16G Total, 88K Used, 16G Free PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 1393 mysql 63 20 0 400M 221M kserel 0 191.5H 157.13% mysqld 43698 www 1 4 0 169M 29888K sbwait 5 0:00 2.63% httpd 43697 www 1 20 0 169M 29804K lockf 1 0:00 1.18% httpd 23376 vpopmail 1 4 0 81468K 55772K select 7 0:28 1.17% perl5.8.8 43729 root 1 96 0 7228K 2676K select 5 0:00 1.00% couriertls