Hosting Provided By

Re: [GENERAL] Help tuning a large table off disk and into RAM

From: Alban Hertroys <a.hertroys(at)magproductions.nl>
Date: Wed Sep 26 2007 - 11:45:16 EDT

James Williams wrote:
> The box has 4 x Opterons, 4Gb RAM & five 15k rpm disks, RAID 5. We
> wanted fast query/lookup. We know we can get fast disk IO.

RAID 5 is usually adviced against here. It's not particularly fast or safe, IIRC. Try searching the ML archives for RAID 5 ;)

-- 
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Received on Wed Sep 26 11:49:15 2007

This message: [ Message body ]
Next message: David Siebert: "[GENERAL] More on migragting the server."
Previous message: Raymond O'Donnell: "Re: [GENERAL] Dumping from older version"
In reply to: James Williams: "[GENERAL] Help tuning a large table off disk and into RAM"
Next in thread: Greg Smith: "Re: [GENERAL] Help tuning a large table off disk and into RAM"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 11:53:42 EDT