From owner-freebsd-performance@FreeBSD.ORG Fri Jul 14 17:05:07 2006 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7896116A4E6 for ; Fri, 14 Jul 2006 17:05:07 +0000 (UTC) (envelope-from anderson@centtech.com) Received: from mh1.centtech.com (moat3.centtech.com [207.200.51.50]) by mx1.FreeBSD.org (Postfix) with ESMTP id 219F143D72 for ; Fri, 14 Jul 2006 17:05:02 +0000 (GMT) (envelope-from anderson@centtech.com) Received: from [10.177.171.220] (neutrino.centtech.com [10.177.171.220]) by mh1.centtech.com (8.13.1/8.13.1) with ESMTP id k6EH51CX059460; Fri, 14 Jul 2006 12:05:02 -0500 (CDT) (envelope-from anderson@centtech.com) Message-ID: <44B7CEC4.6050504@centtech.com> Date: Fri, 14 Jul 2006 12:05:08 -0500 From: Eric Anderson User-Agent: Thunderbird 1.5.0.4 (X11/20060612) MIME-Version: 1.0 To: "Tobias P. Santos" References: <44B7CBCC.7020100@netconsultoria.com.br> In-Reply-To: <44B7CBCC.7020100@netconsultoria.com.br> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.87.1/1599/Fri Jul 14 00:35:31 2006 on mh1.centtech.com X-Virus-Status: Clean Cc: freebsd-performance@freebsd.org Subject: Re: Upgrade to dual-core (Pentium D) processor - Does it worth it? X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 14 Jul 2006 17:05:07 -0000 On 07/14/06 11:52, Tobias P. Santos wrote: > Hello! > > We have a server running FreeBSD 5.4 i386 (which we plan to upgrade to > 6.1) with a single Pentium 4 2.8GHz processor without SMP kernel. > This machine basically serves web pages that may or may not use MySQL > server (also run in this server). > Usually, we have low usage and load average is ~ 0.2 which is ok, but > sometimes, one single process (e.g., mysqld) begins to use all CPU > cycles, loading up the system and leading the other smaller processes > (in terms of CPU usage) to have a high response time. > As this server's motherboard doesn't support an additional processor, we > are wondering whether a Pentium D processor (830) might help to minimize > this problem. > In our understanding, one core would be busy with mysqld for example, > while the other one would be free to handle other processes like httpd > and serve pages that don't even need mysql resources. > Is this correct? Did someone have similiar (successful or unsuccessful) > experiences? This isn't a clear cut yes/no situation I don't think, but for mysqld, there's a lot of tuning you could probably do to make the cpu time drop and free up more cycles for other processes. There's been discussions in the past on this list about mysql, but if you have already done all the optimizations that you can with mysql (with indexes and such for instance), then the extra processor would definitely allow the other non-database blocked web pages to be served, as long as you aren't actually IO bound somewhere. I don't know how much memory you have in the current machine, but adding more might be a good quick upgrade (that is fairly cheap probably). Eric -- ------------------------------------------------------------------------ Eric Anderson Sr. Systems Administrator Centaur Technology Anything that works is better than anything that doesn't. ------------------------------------------------------------------------