[rt-users] Really slow Search page startup suddenly

[Jesse Vincent]

On Apr 6, 2007, at 9:15 PM, Ruslan Zakirov wrote:

> On 4/6/07, Jesse Vincent <jesse at bestpractical.com> wrote:
>>
>>
>> On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:
>>
>> Strangely, our RT server has suddenly started being really slow  
>> loading up
>> the search page and running searches - the same query is logged in  
>> the
>> slow-log every time - any ideas:
>>
>> Likely you granted some large group of users the right to own  
>> tickets.
> "Rows_sent: 288  ", So it's not that large group, but "Rows_examined:
> 54167891" wwhat is really wierd.
>

Yeah. MySQL 5?

-j
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070406/9cb3f91e/attachment.sig>