[rt-users] Requestor email address search hangs apache process

Ruslan Zakirov ruslan.zakirov at gmail.com
Thu Apr 29 12:54:57 EDT 2010


On Thu, Apr 29, 2010 at 8:35 PM, Justin Hayes <justin.hayes at orbisuk.com> wrote:
> Hi Ruslan,
> I have both of those indexes already, and in SelfService I have no control over the query being run - it's just trying to show the 'My open tickets' panel.

My open tickets panel uses user's ID as far as I know and it's even
faster. Optimize/Analyze on tables sometimes help convince optimizer,
but anyway read below.

> Also there is no problem with SelfService with a privileged account that has rights to see queues/tickets, so it seems to be something else that's the problem. Something rights related?

Then next step is to look into log of slow queries and figure out what
query is so slow that user waits forever.

> Thanks,
> Justin

Best regards, Ruslan.

More information about the rt-users mailing list