Re: Database performance
Christopher L. Everett wrote:
> I do a lot of database work. Sometimes I must do massive batch jobs on
> my box
> 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.
Adam
Reply to: