From owner-freebsd-questions@FreeBSD.ORG Fri May 23 16:24:46 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1F1ED106564A for ; Fri, 23 May 2008 16:24:46 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239]) by mx1.freebsd.org (Postfix) with ESMTP id BA2488FC20 for ; Fri, 23 May 2008 16:24:45 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: by wx-out-0506.google.com with SMTP id h27so552095wxd.7 for ; Fri, 23 May 2008 09:24:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=xdlzVMr5mkMlRUqOsM4azpxXxZZ8/UyXy/obkJHTmDw=; b=PbdhIIEfm6ZU0wA8nNtWSpaT0y3UBB8E3FPzAR0RTepKtzoN6Vkze8wtUGvuwIMh+VRFZ8Li30cjwUgEqHfMgqYkwjPJ447O3FMmdjYUdf1HFe0c53vOKDkCAaJbQFp1io8L/4mvEJbt76UwbhC4i5/cbzfY4RmZRmfqQIB+KnM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=nsRWUDIvT0OJrk9AhWLFs/UglOqJj7veEKxlJYNSrRP1J6rdGPzp5qdo93L2xKF/UkVrxWjzf4eENAkFg18n+FWsbM7YXVw0ZjJuExoyGBBllaOippoDn1laPdQbx73K1GVPYjlkSeusniZBKtH5gOqEvyQXDR8CsVxlULo7h50= Received: by 10.114.66.2 with SMTP id o2mr1994204waa.102.1211559882962; Fri, 23 May 2008 09:24:42 -0700 (PDT) Received: by 10.114.102.13 with HTTP; Fri, 23 May 2008 09:24:42 -0700 (PDT) Message-ID: <2cd0a0da0805230924u611fcfa7t4dde98be82438519@mail.gmail.com> Date: Fri, 23 May 2008 18:24:42 +0200 From: VeeJay To: "Frank Shute" , VeeJay , FreeBSD-Questions In-Reply-To: <20080522020117.GA3334@melon.esperance-linux.co.uk> MIME-Version: 1.0 References: <2cd0a0da0805202349sf97edd1t4d6c49404de5ab26@mail.gmail.com> <20080522020117.GA3334@melon.esperance-linux.co.uk> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Re: Your suggestions about this Dell configuration? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 23 May 2008 16:24:46 -0000 Hello Frank Really good points. I am really glad to have your thoughts. Regarding your questions and comments, I have given some answers and a couple of questions in *RED* colour. Please comment if you happen to manage some time during weekend, Thanks! *Please continue...* On Thu, May 22, 2008 at 4:01 AM, Frank Shute wrote: > On Wed, May 21, 2008 at 08:49:51AM +0200, VeeJay wrote: > > > > Hello friends, > > > > My employer is buying this Dell server and I would like to have your > opinion > > about the configuration. > > > > Requirements are: > > 2 Websites with 3-4 million hits per month with video ads. > > If it's "3-4 million hits per month" as you've stated twice now, then > your hardware is complete overkill. > > So I'll assume you mean 3-4 million hits a day for each site. *No, its 3-4 million each site per month and we are having problem. Because, either Apache or MySQL stops responding. I have following settings as Performance:* ** *# ================================================= # Performance settings # ================================================= Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 15 MinSpareServers 5 MaxSpareServers 10 StartServers 5 MaxClients 256 MaxRequestsPerChild 0* > > > > > Operating System: > > *FreeBSD AMD64 7-STABBLE* > > I'd use 7.0-RELEASE. > > > > > Database: > > *PHP+MySQL with Apache* > > No problem. You should use Apache 2.*. *We will use Apache 2.** > > > > > > > Server Configuration: > > *PowerEdge? 6850 SCSI* > > > > Dual Core Intel(R) Xeon(R) Processor 7130M, 3.2GHz, 8MB L3 Cache, 800Mhz > FSB > > 1x Additional Dual Core Intel(R) Xeon(R) Processor 7130M, 3.2GHz, 8MB L3 > Cache, > > 800MHz FSB > > Slow FSB. I suppose they hope you hit the cache. Shouldn't matter > because your server is more likely to be disk bound rather than bus > bound. Changed Processor to: *PE 2950 III Quad Core Xeon X5450 (3.0GHz, 2x6MB, 1333MHz FSB)* *what do you think about E5450?* > > > > > 16GB 400MHz Dual Rank DDR2 Memory (8X2GB) > > Slow memory, to match the slow FSB :) But you've got >250MB per hit. > So use the excess to cache frequently accessed content. *We have changed it to:* *16GB (8x2GB Dual Rank DIMMs) 667MHz FBD* > > > C5 Drives attached to embedded PERC4ei, RAID 10 > > > > PERC 4/DC RAID controller (128MB cache) (1 intern and 1 extern Channel) > > (Should I use controller with Both Internal or Both External Channel? > What > > they do?) > > Supported according to a quick Google search. > > > > > 5 x 146GB SCSI Ultra320 (15000rpm) 1'' 80 pin harddrives > > "No name" or a brand? *We have changed the disks to :* *6 x 450GB SAS 15k 3.5" HD Hot Plug, (Hitachi Japan)* > > > > > > Chassis with support for 3.5'' SCSI Hard Drives > > > > Dell Remote Access Card 4 SERVER MANAGEMENT CARD > > Don't know if this will work. Most guys use a serial console/ssh for > management. > > > > > (I will have hot swappable drives & chassis) > > > > Thank you in advance. > > The performance of this hardware will depend on what *sort* of hits > you get. Are a lot of them just for the homepage? Then just cache it. > > Is it static content? *No, its dynamic contents, data is coming form Database.* > > > If you're getting lots of ad-hoc database queries and fetches/writes > from/to disk, then your disks could get a thrashing. > > How big's your database? Being read from more than written to? How > precious is the data? > *More than 20 million records and more than 1000 Tables.* *And of course, data is always preciouse. :)* > > How many of these hits are reading video ads? All of them? How many > KBs are these awful ads? > *50% of users are going to see the Video Ads.* ** *Size would vary between 100KB to 2MB. * What bandwidth do you have to these servers? *100 Mbps* How you are going to get the best out of your hardware depends on questions like these, so you have to analyse your Apache logs and tune appropriately. Tuning Apache, mysql and PHP are all subjects in their own right. For FreeBSD, read tuning(7). Are you running FreeBSD ATM? Then some numbers from iostat, top etc. would be useful in analysing how your new server is going to cope and how much spare capacity you'll have, but the numbers are dependent on how you've tuned it (if at all). Hope I've given you something to think about. Regards, -- Frank Contact info: http://www.shute.org.uk/misc/contact.html -- Thanks! BR / vj