Subject: Re: [MTT users] Reporter problems
From: Josh Hursey (jjhursey_at_[hidden])
Date: 2008-01-30 11:00:46
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