Given the choice which is more beneficial. Some of the things I've read say Database servers use up more RAM and others say they use up more CPU power. I'm just not sure. Also, what HDD should be used for the database server? I have a choice for SATA or SAS. Some benchmarks are showing SATA as faster I believe, but that SAS is more reliable? Can anyone comment intelligently regarding that as well? My DB is on mysql and it is about 400.4 MiB and I expect it to continue to grow.
Hey why r u posting such things here. Thisis pure buy and sell forum and you cant post anything other then a OFFER or AD.
You should use SCSI harddrives for a database server. People get to caught up on needing the most ram and cpu power when their real bottleneck will be their slow 7200RPM hard drive. Database servers should have SCSI hard drives for fast seek times.
I agree with the above, first get your hands on a 10k or 15k rpm disk to minimise latency and seek times. Also remember that MySQL 32-bit can only address 4GB of memory, so anything greater is a waste on the 32-bit platform. Lastly, it's good to have 1GB of Ram per core, just a small rule of thumb when it comes to SMP. Hope that helps, Jay