Date: Wed, 11 Dec 2002 00:16:38 +0100 From: Walter Hop <freebsd+20021211@walter.slik.org> To: FreeBSD ISP <freebsd-isp@FreeBSD.ORG> Subject: Re[2]: Loaded mysql box: best hardware? Message-ID: <80202079344.20021211001638@slik.org> 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
[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 <wh©slik.org> | +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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?80202079344.20021211001638>