Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Request Tracker: Users

Slow Bulk Update Display Screen

 

 

Request Tracker users RSS feed   Index | Next | Previous | View Threaded


ronald.higgins at gmail

Feb 23, 2012, 2:48 PM

Post #1 of 2 (383 views)
Permalink
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


ruz at bestpractical

Feb 24, 2012, 4:03 AM

Post #2 of 2 (358 views)
Permalink
Re: Slow Bulk Update Display Screen [In reply to]

On Fri, Feb 24, 2012 at 02:48, ronald higgins <ronald.higgins [at] gmail> 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

Request Tracker users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.