Subject: Re: [MTT users] Reporter problems
From: Josh Hursey (jjhursey_at_[hidden])
Date: 2008-01-29 09:47:05
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