On Fri, Feb 24, 2012 at 02:48, ronald higgins <ronald.higg...@gmail.com> wrote: > Hi Guys, > > I have an RT3.8.7 deployments (I know, we're still a little behind). > > The system is pretty nippy, even with Tickets closing in on 3millions > in the MySQL DB. > > An issue has recently cropped up where using "Bulk Update" on the web > interface takes extremely long to load, it's only this that is slow. > The database seems to finish with the query but it still takes an age > to render. If I perform an strace on http during the time I see plenty > of: > > select(0, NULL, NULL, NULL, {1, 0}) = 0 (Timeout) > wait4(-1, 0x7fff037646ec, WNOHANG|WSTOPPED, NULL) = 0 > select(0, NULL, NULL, NULL, {1, 0}) = 0 (Timeout) > wait4(-1, 0x7fff037646ec, WNOHANG|WSTOPPED, NULL) = 0 > select(0, NULL, NULL, NULL, {1, 0}) = 0 (Timeout) > wait4(-1, 0x7fff037646ec, WNOHANG|WSTOPPED, NULL) = 0 > select(0, NULL, NULL, NULL, {1, 0}) = 0 (Timeout) > wait4(-1, 0x7fff037646ec, WNOHANG|WSTOPPED, NULL) = 0 > > The above goes on and on and on.... > > Any thoughts on where I can snoop to find out what's going on to cause this?
Grep for MasonX::Profiler in the config. Enable it and you would be able to understand which mason component cause slowdown. Mysql slow log may help as well. > Regards > > Ronald > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Boston March 5 & 6, 2012 -- Best regards, Ruslan. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012