Subject: Re: [MTT users] Reporter problems
From: Josh Hursey (jjhursey_at_[hidden])
Date: 2008-01-30 15:14:20
I'm seeing between 12 and 20 seconds on a fairly idle machine. We can
likely do better. I'll dig into it this week[end] and see what I can do.
12 - 20 isn't too bad though considering the amount of data that query
is returning. :)
On Jan 30, 2008, at 2:52 PM, Ethan Mallove wrote:
> 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
> _______________________________________________
> mtt-users mailing list
> mtt-users_at_[hidden]
> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users