Open MPI logo

MTT Users Mailing List Archives

  |   Home   |   Support   |   FAQ   |  

This web mail archive is frozen.

This page is part of a frozen web archive of this mailing list.

You can still navigate around this archive, but know that no new mails have been added to it since July of 2016.

Click here to be taken to the new web archives of this list; it includes all the mails that are in this frozen archive plus all new mails that have been sent to the list since it was migrated to the new archives.

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