Resolving a ticket takes ages

RT Users
1

Hi,

We’re administering an RT 3.6.5 with MySQL ver 14.12 Distrib 5.0.51a for a
customer. While other uses of the system is relatively quick and painless,
getting the screen to “resolve” the ticket after clicking the resolve link
can take minutes. Actually resolving the ticket again is a snap.

Is the database stuck? Number of pipelines from RT to MySQL inadequate (or
is there even such a thing?)? What would be appropriate debugging
procedures to take?

Best regards,

~Robin Laurén / eCraft

2

Hi

I suggest you look at the slow queries on your database.
( or show processlist when resolving a ticket)

Oleg.On Sat, 2009-02-07 at 22:19 +0000, Lauren, Robin wrote:

Hi,

We’re administering an RT 3.6.5 with MySQL ver 14.12 Distrib 5.0.51a
for a customer. While other uses of the system is relatively quick and
painless, getting the screen to “resolve” the ticket after clicking
the resolve link can take minutes. Actually resolving the ticket again
is a snap.

Is the database stuck? Number of pipelines from RT to MySQL
inadequate (or is there even such a thing?)? What would be appropriate
debugging procedures to take?

Best regards,

~Robin Laurén / eCraft

Oleg Sladkoff
KELKOO - Service Architect
oleg.sladkoff@yahoo-inc.com
Yahoo messenger : Kelkoooleg
tel : +33 (0)476848147
gsm : +33(0)675768532