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

[Justin Hayes]

Sorry I've been on holiday Ruslan.

I think I said before that I don't get any slow query in the mysql logs.... whatever is hanging (it might be a query) never appears to finish, so doesn't get logged as far as I can tell.

Thanks,

Justin

-------------------------------------------------
Justin Hayes
Orbis Support Manager
justin.hayes at orbisuk.com




On 29 Apr 2010, at 17:54, Ruslan Zakirov wrote:

> Hello,
> 
> 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.