Mailing List Archive

Slow Bulk Update Display Screen
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?

Regards

Ronald
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
Re: Slow Bulk Update Display Screen [ In reply to ]
On Fri, Feb 24, 2012 at 02:48, ronald higgins <ronald.higgins@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