From owner-freebsd-questions@FreeBSD.ORG Tue Mar 2 16:30:16 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 78B5016A4CF for ; Tue, 2 Mar 2004 16:30:16 -0800 (PST) Received: from ms-smtp-01-eri0.southeast.rr.com (ms-smtp-01-lbl.southeast.rr.com [24.25.9.100]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3627C43D31 for ; Tue, 2 Mar 2004 16:30:16 -0800 (PST) (envelope-from wegster@mindcore.net) Received: from mindcore.net (rdu162-234-100.nc.rr.com [24.162.234.100]) i230UDSm019286; Tue, 2 Mar 2004 19:30:13 -0500 (EST) Message-ID: <40452715.5030304@mindcore.net> Date: Tue, 02 Mar 2004 19:30:13 -0500 From: Scott W User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joseph Koenig References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine cc: freebsd-questions@freebsd.org Subject: Re: 1 processor vs. 2 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 03 Mar 2004 00:30:16 -0000 Joseph Koenig wrote: >I'm putting together a system that will host a relatively small database >(around 20,000 records), as well as run Apache / PHP to search that >database. I have the option in front of me to use a P III dual 1GHz machine >with a SCSI Raid 5, or to use a single P4 2.8 GHz with a SCSI Raid 1. Both >have 1GB RAM. I'm looking to use MySQL as the DB. The site that this machine >will host gets about 2 million hits per months (yes, hits, not pageviews or >visitors) from about 21,000 unique visitors. Does anyone have an opinion as >to which machine will perform best under this scenario? Obviously, both >would run FreeBSD. Thanks, > >Joe Koenig >Production Manager >jWeb New Media Design >joe@jWebmedia.com >http://www.jwebmedia.com/ >636.928.3162 > >_______________________________________________ >freebsd-questions@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-questions >To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" > > > Someone else already mentioned this, but RAID-1 will be faster than the RAID-5 at the storage level, if the RAID-5 array is a relatively small # of drives. If you're talking about 2 disk RAID-1 versus 10 disks RAID-5, those numbers may change. If the drives are integrated into the systems, it's also possible the RAID-1 disks are faster drives than the RAID-5 drives... If you're going to run the DB and web server on the same system with a high percentage of static pages, the SMP system may help out. If you have almost all dynamic content is full of complex DB queries, the P4 would do better based solely on CPU speed. How about RAID-1 on the dual PIII and keep the P4 as a workstation? :-) The PIII is likely up to the task, but it really depends on the type of content (is _everything_ PHP generating dynamic content, every page hitting the DB etc?) Scott