From owner-freebsd-isp Tue Dec 10 4:15:15 2002 Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 020C537B401 for ; Tue, 10 Dec 2002 04:15:14 -0800 (PST) Received: from relay.kiev.sovam.com (relay.kiev.sovam.com [212.109.32.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id DCEA743EBE for ; Tue, 10 Dec 2002 04:15:10 -0800 (PST) (envelope-from dimitry@al.org.ua) Received: from [212.109.32.116] (helo=dimitry.kiev.sovam.com) by relay.kiev.sovam.com with esmtp (Exim 3.34 #1) id 18LjHt-000Fv3-00; Tue, 10 Dec 2002 14:14:57 +0200 Content-Type: text/plain; charset="us-ascii" From: Dmitry Alyabyev Reply-To: dimitry@al.org.ua To: Paul Schenkeveld Subject: Re: Loaded mysql box: best hardware? Date: Tue, 10 Dec 2002 14:14:56 +0200 User-Agent: KMail/1.4.3 Cc: FreeBSD ISP References: <3487689390.20021209163011@slik.org> <20021210122229.A42380@psconsult.nl> In-Reply-To: <20021210122229.A42380@psconsult.nl> X-NCC-RegID: ua.svitonline MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200212101414.56930.dimitry@al.org.ua> Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org On Tuesday 10 December 2002 13:22, Paul Schenkeveld wrote: > On Mon, Dec 09, 2002 at 04:30:11PM +0100, Walter Hop wrote: > > Last month I read a doc that argues that MySQL is not able to profit from > > an SMP setup using the FreeBSD 4.x userland threads - saved it here: > > http://www.skydancer.nl/dl/etc/20021119.freebsd.mysql.problems.mht - > > Considering this, would an expensive dual box still be worth the money, > > or would it be more effective to switch to a single-CPU system with the > > fastest clock instead? > > Even if MySQL doesn't benefit from a second CPU, the second CPU will > pick up other processes (httpd for example) leaving more cycles to > mysqld on its 'own' processor. Also, think about things you as a > sysadmin do from the shell, with only one CPU, the commands you type > will compete for that single CPU with mysqld so if you like to have > reasonable interactive response you'll be happy to have dual CPUs. not very reasonable way to have dedicated CPU for this stuff, yes ? > > I want to prepare for when the machine REALLY gets abused, and I'd like > > input from people who have experience in this field, anything will help. > > :) What choice did you make for your high-end database servers? > > > > (If absolutely necessary I would consider installing another OS on the > > server if it would use the hardware more effectively, but seeing that > > FreeBSD 5.x is at the horizon, I'd rather throw money at the problem than > > spend the time on switching to L*n*x or S*l*r*s/x86...) i'm worried if FreeBSD 5 will dramatically improve this situation and let me and lots of ppl around move from linux/solaris to fbsd on database servers. -- Dimitry To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message