On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> wrote:
On Apr 6, 2007, at 9:15 PM, Ruslan Zakirov wrote:
> On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> 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?
Most probably, 4.1 gens good plan for this.
-j
--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
