[OSM-dev] Mass imports (TIGER and AND)

[Tom Hughes]

In message <1188327685.28903.44.camel at localhost>
          Dave Hansen <dave at sr71.net> wrote:

> On Tue, 2007-08-28 at 08:29 +0100, Tom Hughes wrote:
> > In message <1188275447.28903.15.camel at localhost>
> >         Dave Hansen <dave at sr71.net> wrote:
> > > The thing that *IS* on my laptop is the ruby code.  It is responsible
> > > for 90% of the CPU time, and the CPUs are maxed out.  mysql, on the
> > > other hand, is responsible for ~3% of total cpu time.  Even with my
> > > piddly notebook hard drive, the I/O wait time is under 1%.
> > 
> > That's quite impressive, because the CPUs on our web servers never
> > get anywhere near maxing out, and between then they are processing
> > anything up to about a dozen requests each at any one time.
> 
> Yeah, that's very interesting.  What is the actual bottleneck?  Do you
> see actual I/O wait time on the server?

No, because the waiting is primarily against the network for the
database to response, not against the disks.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/