From owner-freebsd-hackers@FreeBSD.ORG Thu Apr 20 18:08:56 2006 Return-Path: X-Original-To: hackers@freebsd.org Delivered-To: freebsd-hackers@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 407A016A400 for ; Thu, 20 Apr 2006 18:08:56 +0000 (UTC) (envelope-from anderson@centtech.com) Received: from mh2.centtech.com (moat3.centtech.com [207.200.51.50]) by mx1.FreeBSD.org (Postfix) with ESMTP id DDBB243D46 for ; Thu, 20 Apr 2006 18:08:55 +0000 (GMT) (envelope-from anderson@centtech.com) Received: from [10.177.171.220] (neutrino.centtech.com [10.177.171.220]) by mh2.centtech.com (8.13.1/8.13.1) with ESMTP id k3KI8s7Q027898; Thu, 20 Apr 2006 13:08:54 -0500 (CDT) (envelope-from anderson@centtech.com) Message-ID: <4447CE2A.1040603@centtech.com> Date: Thu, 20 Apr 2006 13:08:42 -0500 From: Eric Anderson User-Agent: Thunderbird 1.5 (X11/20060402) MIME-Version: 1.0 To: Paul Halliday References: <2dab70a30604201049i41e409e1y8924383843c95980@mail.gmail.com> In-Reply-To: <2dab70a30604201049i41e409e1y8924383843c95980@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.87.1/1409/Wed Apr 19 16:02:41 2006 on mh2.centtech.com X-Virus-Status: Clean Cc: hackers@freebsd.org Subject: Re: Server choice. X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Apr 2006 18:08:56 -0000 Paul Halliday wrote: > Hi, > > I am in the process of building a new database server and after > pricing up 2 Dell models I thought I would throw this out just to see > which choice would be better suited for FreeBSD. > > The demands on the system will be mostly network -> disk I/O with a > hope of best performance on quickly servicing numerous reads; for > example when reports are generated using the data in the database. > > The 2 choices (we dont have that much money and they have to be Dell) > are a poweredge 1850 and a poweredge 850. > > 850 specs. > ---------------- > Procsesor: Pentium(Dual Core) 830 @ 3.0GHz/2X1MB Cache 800MHz FSB > Memory: 2GB DDR2, 533MHz (2x1GB) Dual ranked DIMMs > Disks: SATA > > 1850 specs. > ------------------ > Processors: 2 @ Xeon @ 3.0GHz/2MB Cache 800MHz FSB > Memory: 2GB DDR2, 400MHz (4x512) Single ranked DIMMs > Disks: Ultra 320 > > The pricing is really close. I'm not sure the type of memory<->cpu utilization that mysql will do, however I can tell you that in a number of applications that do lots of cpu cache utilization, the 2x Xeon will knock over the dual-core. I'd go with the 1850 (we have stacks of these in house). Eric -- ------------------------------------------------------------------------ Eric Anderson Sr. Systems Administrator Centaur Technology Anything that works is better than anything that doesn't. ------------------------------------------------------------------------