[OSM-dev] Stats: Report took 6043.817004 seconds to run

Tom Hughes tom at compton.nu
Sat Sep 15 23:59:34 BST 2007


In message <b11426350709151506g684ba4e2jea31b92c3ab199ee at mail.gmail.com>
          "Francisco R. Santos" <frsantos at gmail.com> wrote:

> 2007/9/15, Tom Hughes <tom at compton.nu>:
> >
> > In message <b11426350709151117p741fdbc5te8fb86046e187940 at mail.gmail.com>
> >           "Francisco R. Santos" <frsantos at gmail.com> wrote:
> >
> > > The stats page at [1] says at the bottom "Report took 6043.817004seconds to
> > > run". Is this figure correct? Did it took 1:40 hours to generate one
> > single
> > > stats page? If so, I think we should disable it for the moment.
> >
> > Yes, it probably did take that long to run.
> >
> > Why do you think we should disable it though? Do you have some reason
> > to believe it is causing a problem?
> 
> Mmm, right I shouldn't assume anything, but if it takes so long, I thought
> it is making some expensive queries to the database, slowing it down even
> more.

Well it table scans several large tables, but that's not a huge
problem so long as they are InnoDB tables.

Tom

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




More information about the dev mailing list