[rt-users] RT 3.6.4 poor query performance

[Ruslan Zakirov]

Jesse, I know that they both have index on CachedGroupMembers table
that starts from 'MemberId' column. And it does mess up optimizer and
doesn't matter if it's one column or multiple like in (MemberId,
GroupId, Disabled) index (Jeff created such thing). We really need
such index in the core on CGM table, otherwise people have problems
with searches by watchers (like in "Requestor is XXX" search or "More
about XXX" box). It's very sad that mysql can not deal with that. Fix
I've implemented in 3.6.6 helps people on setups with few ACL records
and few queues, but not in these two cases.

On Wed, Mar 19, 2008 at 7:28 PM, Jesse Vincent <jesse at bestpractical.com> wrote:
>
>
>
>  On Wed, Mar 19, 2008 at 04:22:46PM +0000, Richard Ellis wrote:
>  > Hi Ruslan,
>  >
>  > here's the two sets of results.
>
>  FWIW, from your response to ruslan, it _does_ look like your hand-added
>  "group1" index was messing up the query planner. It's on GroupId, while
>  we already had an index on GroupId, MemberId.
>


-- 
Best regards, Ruslan.