Date: Fri, 19 Aug 2005 22:00:16 +1000 From: Dean Hamstead <dean@bong.com.au> To: Uzi <uzi@bmby.com> Cc: freebsd-database@freebsd.org, freebsd-hardware@freebsd.org Subject: Re: FreeBSD hardware solution for a database server Message-ID: <4305C9D0.60607@bong.com.au> In-Reply-To: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi> References: <040f01c5a4b9$f5d2dff0$0700a8c0@uzi>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4305C9D0.60607>