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.
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-hardware
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
--
WWW: http://dean.bong.com.au LAN: http://www.bong.com.au
EMAIL: [EMAIL PROTECTED] or [EMAIL PROTECTED]
ICQ: 16867613
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-hardware
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
