From owner-freebsd-hardware@FreeBSD.ORG Fri Aug 19 12:01:16 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 8E30716A41F; Fri, 19 Aug 2005 12:01:16 +0000 (GMT) (envelope-from dean@bong.com.au) Received: from aramaki.bong.com.au (aramaki.bong.com.au [203.91.232.99]) by mx1.FreeBSD.org (Postfix) with ESMTP id 29F5743D45; Fri, 19 Aug 2005 12:01:15 +0000 (GMT) (envelope-from dean@bong.com.au) Received: from dsl-203-33-164-108.nsw.netspace.net.au ([203.33.164.108] helo=[192.168.1.40]) by aramaki.bong.com.au with esmtpa (Exim 4.52 (FreeBSD)) id 1E65ad-0007lY-6F; Fri, 19 Aug 2005 22:03:15 +1000 Message-ID: <4305C9D0.60607@bong.com.au> Date: Fri, 19 Aug 2005 22:00:16 +1000 From: Dean Hamstead User-Agent: Debian Thunderbird 1.0.2 (X11/20050602) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Uzi References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> In-Reply-To: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> Content-Type: text/plain; charset=windows-1255; 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: Fri, 19 Aug 2005 12:01:16 -0000 you may need to look at specifically what sort of queries are taxing the system lots of queries or long queries this will vary your final decision considerably. other options you might consider are.... - breaking up your database across several servers - seperate 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 childs play) - putting databases (or even tables) on different physical disks - optimising queries where possible - make the queries match indexes better - make smaller queries and then get more cpus. 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. 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 you may also find mysql5 to be faster than 41 (assuming mysql) Dean Uzi wrote: > Hi > > I am looking for a FreeBSD 5.4 hardware/configuration solutions for a > MySQL database server. > > My server is currently running FreeBSD 5.4 with a web/mail/database > server on a Proliant DL380 G4 (dual Xeon 3.2, 2 GB ram), and the speed > isn't fast enough. > > We have a pretty big database with allot of complex joins/indexes, so a > dedicated database server seems like the next step (among with > optimizing/normalizing the database). > > > > Proliant DL580 looks fair to my eyes (as I'm pretty happy with HP) > > But I have a few indecisions: > > > > 1. 2/4 CPU > > 2. Amount of ram (4 GB+) > > 3. And most important (AFAIK) - Storage configuration (RAID 5 / RAID 0+1 > etc.) > > > > What would be the preferred solution? > > > > Thanks, > > Uzi > > > > P.S - Please CC me the replies as I'm not subscribed. Thanks. > > > > > > > _______________________________________________ > freebsd-hardware@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-hardware > To unsubscribe, send any mail to "freebsd-hardware-unsubscribe@freebsd.org" > -- WWW: http://dean.bong.com.au LAN: http://www.bong.com.au EMAIL: dean@bong.com.au or djzort@bong.com.au ICQ: 16867613