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-us...@open-mpi.org > >>> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users > >> > >> _______________________________________________ > >> mtt-users mailing list > >> mtt-us...@open-mpi.org > >> http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users > > > > _______________________________________________ > > mtt-users mailing list > > mtt-us...@open-mpi.org > > http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users > > _______________________________________________ > mtt-users mailing list > mtt-us...@open-mpi.org > http://www.open-mpi.org/mailman/listinfo.cgi/mtt-users
