[rt-users] mysql slowness

[Jesse Vincent]

On Wed, Jul 13, 2005 at 10:57:07AM -0500, Kroll, Nathan Allen wrote:
> I found a little more out about this problem we seem to be having. The
> slowest part seems to be when loading the query builder page and this
> mysql query is run:
> 
> SELECT DISTINCT main.* FROM Users main , Principals Principals_1, ACL
> ACL_2, Groups Groups_3, CachedGroupMembers CachedGroupMembers_4  WHERE
> ((ACL_2.RightName = 'OwnTicket')) AND ((CachedGroupMembers_4.MemberId =
> Principals_1.id)) AND ((Groups_3.id = CachedGroupMembers_4.GroupId)) AND
> ((Principals_1.Disabled = '0')or(Principals_1.Disabled = '0')) AND
> ((Principals_1.id != '1')) AND ((main.id = Principals_1.id)) AND  ( (
> ACL_2.PrincipalId = Groups_3.id AND ACL_2.PrincipalType = 'Group' AND (
> Groups_3.Domain = 'SystemInternal' OR Groups_3.Domain = 'UserDefined' OR
> Groups_3.Domain = 'ACLEquivalence')) OR ( ( (Groups_3.Domain =
> 'RT::Queue-Role' )  )  AND Groups_3.Type = ACL_2.PrincipalType) )  AND
> (ACL_2.ObjectType = 'RT::System' OR  (ACL_2.ObjectType = 'RT::Queue') )
> ORDER BY main.Name ASC;
> 
> The query has taken up to 59 seconds and is the most frequent slow query
> logged to mysql.  The query returns about 2100 results.  Is this normal
> for people or is something fubar-ed on our setup?

Perhaps you've granted "Everyone" the right to OwnTickets. Which isn't
likely what you meant.