From owner-freebsd-isp Tue Dec 10 15:16:51 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 B73E337B404 for ; Tue, 10 Dec 2002 15:16:50 -0800 (PST) Received: from glow.dt1.slik.org (glow.binity.net [213.84.201.224]) by mx1.FreeBSD.org (Postfix) with ESMTP id 92F5C43EC2 for ; Tue, 10 Dec 2002 15:16:49 -0800 (PST) (envelope-from freebsd+20021211@walter.slik.org) Received: from silver.dt1.slik.org (silver.dt1.slik.org [172.24.7.10]) by glow.dt1.slik.org (Postfix) with ESMTP id EBBF3AAF1 for ; Wed, 11 Dec 2002 00:17:17 +0100 (CET) Date: Wed, 11 Dec 2002 00:16:38 +0100 From: Walter Hop X-Mailer: The Bat! (v1.61) Educational X-Priority: 3 (Normal) Message-ID: <80202079344.20021211001638@slik.org> To: FreeBSD ISP Subject: Re[2]: Loaded mysql box: best hardware? In-Reply-To: <20021210122229.A42380@psconsult.nl> References: <3487689390.20021209163011@slik.org> <20021210122229.A42380@psconsult.nl> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit 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 [in reply to fb-isp@psconsult.nl, 10-12-2002] > 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. That is true, but at Xeon prices that's hardly worth spending all that money for, where in this setup a Linux machine would benefit from far more MySQL power. To stay safe I will probably install Linux on it for now and switch back to FreeBSD 5.x when the optimizations have sank in a bit and the new code has received some testing. There is great work going on now, and as I convert Linux machines to FreeBSD all the time for a living ;) the switch back will probably be no problem at all and it would give a good opportunity to get some experience with tuning myself. I've also received the suggestion of trying MySQL 4 which has many improvements for tables with a large number of updates. I'll check that out as well. Thanks for the help everybody! -- Walter Hop | +31 6 2445 2020 | http://www.skydancer.nl/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message