[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Database performance



Adam Aube wrote:

Christopher L. Everett wrote:
<snip>

The problem is that these things often take 10 to 30 minutes to run on
my box. When I use the GNU time utility, I see a low PCPU number,
typically between 15 and 25%.  CPU utilization viewed through top remains
at 35% or so, and I never go deeper than a few tens of kilobytes into
swap, even though the 1 minute load average climbs to 2 and higher (I've
seen peak numbers around 6).
Am I correct in thinking that the bottleneck lies in the HD subsystem?

Yes.

So, what kind of hard drive subsystem can I run that would get me
3 to 4 times the performance that wouldn't break the bank?

--
Christopher L. Everett

Chief Technology Officer                               www.medbanner.com
MedBanner, Inc.                                          www.physemp.com



Reply to: