Date: Tue, 10 Dec 2002 14:14:56 +0200 From: Dmitry Alyabyev <dimitry@al.org.ua> To: Paul Schenkeveld <fb-isp@psconsult.nl> Cc: FreeBSD ISP <freebsd-isp@FreeBSD.ORG> Subject: Re: Loaded mysql box: best hardware? Message-ID: <200212101414.56930.dimitry@al.org.ua> In-Reply-To: <20021210122229.A42380@psconsult.nl> References: <3487689390.20021209163011@slik.org> <20021210122229.A42380@psconsult.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200212101414.56930.dimitry>