From owner-freebsd-performance@FreeBSD.ORG Fri Jul 14 17:05:40 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 BF7D416A4E0 for ; Fri, 14 Jul 2006 17:05:40 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from pi.codefab.com (pi.codefab.com [199.103.21.227]) by mx1.FreeBSD.org (Postfix) with ESMTP id C529B43D77 for ; Fri, 14 Jul 2006 17:05:31 +0000 (GMT) (envelope-from cswiger@mac.com) Received: from localhost (localhost [127.0.0.1]) by pi.codefab.com (Postfix) with ESMTP id 1B4195FCC; Fri, 14 Jul 2006 13:05:31 -0400 (EDT) X-Virus-Scanned: amavisd-new at codefab.com Received: from pi.codefab.com ([127.0.0.1]) by localhost (pi.codefab.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Xlg2hBuA7dl2; Fri, 14 Jul 2006 13:05:30 -0400 (EDT) Received: from [199.103.21.238] (pan.codefab.com [199.103.21.238]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by pi.codefab.com (Postfix) with ESMTP id 033B05D44; Fri, 14 Jul 2006 13:05:30 -0400 (EDT) In-Reply-To: <44B7CBCC.7020100@netconsultoria.com.br> References: <44B7CBCC.7020100@netconsultoria.com.br> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <71F17CAF-882F-48D8-91F5-52602F3B7C04@mac.com> Content-Transfer-Encoding: 7bit From: Charles Swiger Date: Fri, 14 Jul 2006 13:05:29 -0400 To: Tobias P. Santos X-Mailer: Apple Mail (2.752.2) 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:40 -0000 On Jul 14, 2006, at 12:52 PM, Tobias P. Santos wrote: > 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? Yes, in particular, the preforking design that Apache uses distributes very well amoungst multiple CPUs. There is some overhead from using SMP, you might get better performance by separating your workload into two machines, one dedicated to Apache and one dedicated to your MySQL database, but upgrading to a dual-core CPU is cheaper... -- -Chuck