Hi Kenneth, I'm using MYSQL, How can I tell which query it is? I get no logging and nothing in the MYSQL slow search log, I assume because it never completes?
Thanks, Justin ------------------------------------------------- Justin Hayes Orbis Support Manager [email protected] On 29 Apr 2010, at 13:39, Kenneth Marshall wrote: > On Thu, Apr 29, 2010 at 08:24:22AM +0100, Justin Hayes wrote: >> RT3.8.4 >> >> If I use an unprivileged user (or a privileged user with no rights to see >> queues or tickets) to create a very simple search that looks like this: >> >> Requestor.EmailAddress Like '<email address>' >> >> then the apache process handling the request maxes out CPU and hangs >> forever. If I create the same search with a privileged user that has rights >> to see queues etc it's fine and returns instantly. >> >> This is a big problem as the SelfService interface screens work via >> requestor email address, so anyone accessing SelfService severely affects >> performance of my RT. >> >> Anyone got any ideas???? >> >> Thanks, >> >> Justin >> >> ------------------------------------------------- >> Justin Hayes >> Orbis Support Manager >> [email protected] >> > Hi Justin, > > Perhaps you are missing an index. What query is hitting the database > for the slow search? What DB backend are you using? > > Cheers, > Ken Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
