From owner-freebsd-hardware@FreeBSD.ORG Sun Aug 21 12:41:31 2005 Return-Path: X-Original-To: freebsd-hardware@freebsd.org Delivered-To: freebsd-hardware@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8471616A41F; Sun, 21 Aug 2005 12:41:31 +0000 (GMT) (envelope-from uzi@bmby.com) Received: from dev.bmby.co.il (l192-114-46-204.broadband.actcom.net.il [192.114.46.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9706043D45; Sun, 21 Aug 2005 12:41:30 +0000 (GMT) (envelope-from uzi@bmby.com) Received: from [192.168.0.2] ([192.168.0.2]) by dev.bmby.co.il (8.12.9/8.12.9) with ESMTP id j7LCfdPS024065; Sun, 21 Aug 2005 15:41:39 +0300 Message-ID: <43088442.7000704@bmby.com> Date: Sun, 21 Aug 2005 15:40:18 +0200 From: Uzi Klein Organization: B.M.B.Y Software Systems Ltd. User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: jmc References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> <6863f0c905081906061290c642@mail.gmail.com> In-Reply-To: <6863f0c905081906061290c642@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-database@freebsd.org, freebsd-hardware@freebsd.org Subject: Re: FreeBSD hardware solution for a database server X-BeenThere: freebsd-hardware@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: General discussion of FreeBSD hardware List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Aug 2005 12:41:31 -0000 jmc wrote: > For the best database-write performance on the DL380G4, make sure you > have the Battery-Backed Write Cache (BBWC) option. Never heard of it. I'd take it as a hardware setup in BIOS? (The server is in co-location, i have no physical access to it but i can explain ISP sys-admin what to do if needed) > The more spindles you have, the better. Are you using all 6 drive > bays in the 380? Make sure they're all Ultra320 drives. 15K will > give the best performance, but the 10K drives aren't too shabby. > RAID0 will give the best performance, but it's not redundant. Next is > RAID1, then RAID5 or ADG. I have 5 drives 36 GB Ultra320 15K: 2 mirrored drives mounted as / 3 RAID 5 drives mounted as /var www# df -h Filesystem Size Used Avail Capacity Mounted on /dev/da0s1a 33G 4.7G 26G 16% / devfs 1.0K 1.0K 0B 100% /dev /dev/da1s1d 62G 9.5G 47G 17% /var > You might also try a DL385 (dual socket Opteron) or DL585 (quad socket > Opteron) which will give you either 4 or 8 procs (if they are dual > core). Are you suggesting AMD based boxes outperforms Intel based machines? That's what I'm really interested in... I know it's time for a dedicated fast database server. If i optimized my database and hardware settings, i could gain months, not more. The question is upgrade to what (Assuming my DL380 isn't enough) Thanks, Uzi P.S - Please CC me the replies as I'm not subscribed.