[rt-devel] RT SQL 'lockup' (mysql->99% cpu)

[Jesse Vincent]

On Tue, Jul 15, 2003 at 09:52:54AM +0100, Iain Price wrote:
 
> We eventually found we could replicate this by searching for requestor 
> email address containing (anything) and then another 'contains' search to 
> the search query produced is a good dozen lines long according to mysql 
> query log (i spent too long thinking this was a mysql error).  Anyway the 
> query takes over 10 minutes to respond :P during which time all the other 
> query threads lock, and RT appears to have 'died'.
 
There was a post to, iirc, rt-users, yesterday discussing this
performance issue with a recommended index to add to the database. That
may fix it for you.


> would it be possible to timelimit the sql queries, or have a more simple 
> search page that just takes a 'word' and searches for it in emails, 
> usernames, ticket subjects etc (the search in the top right seems to do 
> subjects and ticket numbers only?)


Anything is _possible_. The magic search box at the top right does a
whole bunch of different things, depending on context.

> 
-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.