[rt-users] RT Slow to add and remove group members

Todd Chapman todd at chaka.net
Mon Dec 13 16:27:19 EST 2010


Our production RT instance (3.6.3 - old, I know) takes a really,
really long time to add and remove group members.

Our database is MySQL and the CachedGroupMembers table has the index:
KEY `CachedGroupMembers3` (`MemberId`,`ImmediateParentId`)

What can we do to improve the situation (yes, I would be upgrading if
that were possible at the moment)?

Would running shrink_cgm_table.pl be a good idea?

Thanks!

-Todd



More information about the rt-users mailing list