Subject: Re: [MTT users] Reporter problems
From: Ethan Mallove (ethan.mallove_at_[hidden])
Date: 2008-01-30 14:52:41
I don't remember a "past 24 hour" summary taking "24
seconds". Are we seeing a slow down due to an accumulation
of results? I thought the week-long table partitions would
prevent this type of effect?
-Ethan
On Wed, Jan/30/2008 11:00:46AM, Josh Hursey wrote:
> This maintenance is complete. The reporter should be operating as
> normal.
>
> There are a few other maintenance items, but I am pushing them to the
> weekend since it will result in a bit of a slowdown again.
>
> Thanks for your patience.
>
> Cheers,
> Josh
>
> On Jan 29, 2008, at 9:47 AM, Josh Hursey wrote:
>
> > The reporter should be responding much better now. I tweaked the
> > maintenance scripts so they no longer push nearly as hard on the
> > database. They are still running, but the query you specified seems to
> > run in approx. 15-20 sec. with the current load.
> >
> > -- Josh
> >
> > On Jan 29, 2008, at 8:38 AM, Josh Hursey wrote:
> >
> >> For the next 24 - 48 hours this is to be expected. Sorry :(
> >>
> >> I started some maintenance work last night, and it is taking a bit
> >> longer than I expected (due to integrity constraint checking most
> >> likely). The maintenance scripts are pushing fairly hard on the
> >> database, so I would expect some slowdown with the reporter (and
> >> maybe
> >> client submits).
> >>
> >> If this becomes a substantial problem for anyone please let me know,
> >> and I may be able to shift this work to the weekend. In the mean time
> >> I'll see if I can reduce the load a bit.
> >>
> >> -- Josh
> >>
> >>
> >> On Jan 29, 2008, at 7:44 AM, Tim Prins wrote:
> >>
> >>> Hi,
> >>>
> >>> Using the reporter this morning it is being awfully slow, as in it
> >>> is
> >>> taking about 3 minutes to do a top level summary search for:
> >>> Date: past 24 hours
> >>> Org: IU
> >>> Platform name: IU_Odin
> >>>
> >>> I don't know whether this is a known problem or not. I seem to
> >>> recall
> >>> that after the last database upgrade such a search was taking just a
> >>> few
> >>> seconds.
> >>>
> >>> Thanks,
> >>>
> >>> Tim
> >>> _______________________________________________
> >>> mtt-users mailing list
> >>> mtt-users_at_[hidden]
> >>> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
> >>
> >> _______________________________________________
> >> mtt-users mailing list
> >> mtt-users_at_[hidden]
> >> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
> >
> > _______________________________________________
> > mtt-users mailing list
> > mtt-users_at_[hidden]
> > http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
>
> _______________________________________________
> mtt-users mailing list
> mtt-users_at_[hidden]
> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users