Hi,
my database requires 1TB of disk space, but I want to avoid RAID (e.g.
8x 300GB SAS drives in RAID 10), and use rather a 1TB SATA disk.
To avoid the "slowness" of SATA showing in queries, I want to cache
lots of the database, but I don't want to buy more than 16GB RAM.
(Budget limits).
So I'm considering configuring a large cache, requiring larger than
16GB, and allowing it to "spill over" into swap space on a single
300GB SAS drive.
Is this a good idea?
Thanks
Brian
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/