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.ha...@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.ha...@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. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com