1. Unless your doing major league DB stuff, the FS should make more than marginal difference, if it's Journaled then it's good. You can take all the time benchmarking that you want, just be sure your ROI is worth the time you invest. My favourite fs is Reiser, but in the cold light of day, ext3 is supported in more places. My first choice is Reiser, since I used it even when it was "unstable" on production servers and it never let me down. I often use one or the other.
2. Bruce's article really is good for this question, but in a nutshell you need to get as much of the DB as close to the CPU as possible. As with any serious application, you can't beat a good L1/L2 cache, then plenty of RAM/Memory ... DBs yum RAM, the more the merrier. Lastly fast and wide disc access, remember disk access will be the slowest part of the system, and in an ideal world you'd fit nearly all of your DB in RAM if it was practical and safe.
You'd probably gain more from taking the time to really ensure that your DB is designed flawlessly, and all your indexes are where they're needed. All of the basics come into play, but a well built RDBMS system is greater than the sum of its parts.
Hi
I'm upgrading the DB sever hardware and also the Linux OS.
My Questions are:
1. What is the preferred FS to go with ? EXT3, Reiseref, JFS, XFS ? ( speed,
efficiency )
2. What is the most importent part in the Hardware ? fast HD, alot of mem,
or maybe strong cpu ?
Thanks in Advance
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend