From owner-freebsd-hardware@FreeBSD.ORG Sun Aug 21 10:15:26 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 A25E816A41F for ; Sun, 21 Aug 2005 10:15:26 +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 B1DB643D46 for ; Sun, 21 Aug 2005 10:15:24 +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 j7LAFYPS014015; Sun, 21 Aug 2005 13:15:34 +0300 Message-ID: <43086205.8060307@bmby.com> Date: Sun, 21 Aug 2005 13:14:13 +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: freebsd-hardware@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 10:15:26 -0000 Dean Hamstead wrote: > you may need to look at specifically what sort of > queries are taxing the system > lots of queries or long queries Both, but mostly long queries. > this will vary your final decision considerably. > other options you might consider are.... > - breaking up your database across several servers > - separate databases completely (good for mainly write stuff) > - !!! replicate and load share (really good for ro stuff) !!! > - getting in and really checking that indexes are well designed > (indexes can change long taxing queries into childes play) Good points, the database does need optimization, I will to that as well, but its about time for a dedicated server anyway (and it costs way less than normalizing a +-500 related tables db) > im not sure what these servers are like, im a dell man but its > all just hardware. obviously faster cpu, more ram, 15k scsi disks > and if raid 1+0 or 5 is faster may depend on the controller > how many channels etc. the driver and card performance might > even be worth looking into. That what my original question meant to be: What are the minimum/recommended system requirements (*hardware* wise) for a heavy loaded database server. If you're a Dell man, please be kind and point me to a Dell box... > if your really dying for performace, go back to the ports tree > and try compiling for better performance. ie mysql can compile > static for (what it claims) better performance, and there is > one other option that eludes me. im not sure if linuxthreads > is faster than native threads I have done most of the software tweaking. > you may also find mysql5 to be faster than 41 (assuming mysql) You don't really advise me to use beta software for production, do you? Thanks, -Uzi