From owner-freebsd-questions@FreeBSD.ORG Wed Mar 3 20:34:55 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 DF8EA16A4CE for ; Wed, 3 Mar 2004 20:34:55 -0800 (PST) Received: from ms-smtp-03-eri0.southeast.rr.com (ms-smtp-03-lbl.southeast.rr.com [24.25.9.102]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8A6F743D1F for ; Wed, 3 Mar 2004 20:34:55 -0800 (PST) (envelope-from wegster@mindcore.net) Received: from mindcore.net (rdu162-234-100.nc.rr.com [24.162.234.100]) i244Yqs1027961; Wed, 3 Mar 2004 23:34:52 -0500 (EST) Message-ID: <4046B1EB.1070300@mindcore.net> Date: Wed, 03 Mar 2004 23:34:51 -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: Stefan Cars References: <40452715.5030304@mindcore.net> <20040303140216.U99563@guldivar.globalwire.se> In-Reply-To: <20040303140216.U99563@guldivar.globalwire.se> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine cc: Joseph Koenig 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: Thu, 04 Mar 2004 04:34:56 -0000 Stefan Cars wrote: > Hi! > > Following up on this I'm also looking into buying some servers and have > the almost the same scenario, a MySQL DB together with apache with > mod_perl and embperl, (alot of SQL and dynamic content). Would we be > better off with: > > Dual Xeon, 2.4 GHZ with 2GB of RAM or Xeon 3.0 GHZ with 2GB of RAM > and > RAID-1 on three disks or RAID-5 on three disks. > > > Will the difference between 2.4 and 3.0 really do that much ? Isn't the > SMP system better. > > Kind Regards, > Stefan Cars With that small a difference in CPU speed for the purpose you state, I'd definitely go with the dual 2.4 Xeon setup. Unless the FreeHSD SMP implemetation is _really_ bad, which I haven't seen any indication of at all, the SMP system will perform better when you're going to have multiple relatively heavy duty processes and threads running at once, as in the case of a web server with dynamic content hitting a database. Someone commented on RAID-5 with 3 disks being useless- it isn't, but most setups have at least a hot spare designated, and some vendors (IBM, unsure of others offhand) also 'extend' RAID-5 to include the hot spare in different methods (ie RAID-5E, RAID-5EE). Some relatively experienced comments on your config- Add more disk if possible. A striped (2x disk) OS dedicated disk will improve performance a bit, but you'd probably do better using seperate physical disks (or logical RAID volumes but comprised of different physical disks) between the database and the web content, resulting in less I/O contention between the two (web server and DB). RAID-1 across 3 disks is a bit of overkill IMHO, as you're still limited to a bit less than the throughput for a single disk. Use a single disk (or striped pair) for the OS (seperate disk for swap if you anticipate heavy swapping), a RAID-1 mirror for the Database data/files, and another disk for web content. If the content is reasonably unchanging, (the HTML), or you have the content in a source control or content management system, then the DB data is arguably more important so should get the RAID redundancy...then just back up the HTML and web content regularly, or perhaps snapshot it to spare space on the RAID volume nightly. That woould be something along the lines of: Vol 1 (non-RAID or RAID-0 striped of $ allows, so single or dual disks)- FreeBSD Vol 2 - web content. Single disk or RAID-1 mirror, again depending on $ Vol 3 - DB content. RAID-1 mirror, only for DB use. If heavy swapping is expected, then allocate swap space on one of the other disks, but it will obviously affect performance. Do NOT use a single RAID-5 for both web and DB, unless performance is secondary- you _will_ see high amounts of I/O wait states as the server becomes more loaded. If $ allowed, making each RAID-5 or RAID-1 but using seperate physical disks for each volume would be ideal..some RAID hardware and/or software allow you to span different types of RAID configurations across the same disks, which is great for the budget (ie 3 physical disks, but having a RAID-1 volume across _parts_ of two physical disks, and the rest being a RAID-5 volume), but again, you'll eventually run into disk seek and I/O issues... Scott > On Tue, 2 Mar 2004, Scott W wrote: > > >>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 >> >>_______________________________________________ >>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" >> > > > -- > Stefan Cars > Snowfall Communications > Tel: +46 (0)18 430 80 50 - Direct: +46 (0)18 430 80 51 > Mobile: +46 (0)708 44 36 00 - Fax: +46 (0)708 44 36 04 > > > > ______________________________________________________________________ > SNOWFALL DISCLAIMER: > The information contained in this email and in any > attachments is confidential and may be privileged. If you are not the > intended recipient, please destroy this message and notify the sender > immediately. You should not retain, copy or use this email for any > purpose, nor disclose all or any part of its content to any other person. > Any views expressed in this message are those of the individual sender, > except where the sender specifically states them to be the views of > Snowfall Communications. > > Snowfall Communications monitors the content of emails sent and received > via its network for unauthorised use and for other lawful business > purposes. The contents of an attachment to this email may contain viruses > which could damage your computer system. While Snowfall Communications has > taken every reasonable precaution to minimise this risk, we cannot accept > liability for any damage which you sustain as a result of software > viruses. You should carry out your own virus checks before opening the > attachment. >