[rt-users] Certain RT operations painfully slow.

[Todd Chapman]

On Tue, Jan 18, 2011 at 1:13 PM, Jesse Vincent <jesse at bestpractical.com> wrote:
> Todd,
>
>> >> Which causes this long running mysql query:
>> >>
>> >>    Time: 86
>> >>    Info: SELECT main.* FROM CachedGroupMembers main   WHERE ((main.Via = '28522070')) AND ((main.id != '28522070'))
>> >>
>> >> Can anyone recommend an approach to fixing this problem?
>> >
>> > What does an EXPLAIN on that select tell you?
>>
>> mysql> explain SELECT main.* FROM CachedGroupMembers main   WHERE ((main.Via = '28522070')) AND ((main.id != '28522070'))\G
>>   select_type: SIMPLE
>>         table: main
>>          type: range
>> possible_keys: PRIMARY
>>           key: PRIMARY
>>       key_len: 4
>>           ref: NULL
>>          rows: 20568305
>>         Extra: Using where
>> 1 row in set (0.02 sec)
>
> What happens if you add an index on Via?

I'm considering that, but with 20 million+ rows it will take a
non-trivial amount of time.

>
> Jesse
> --
>