[rt-users] mysql slowness

[Kroll, Nathan Allen]

I checked the group rights and the only right Everyone has is
ModifyOwnMembership.  Howver, on the query builder page, for the Owner
is drop down, there seems to be every email address we've ever entered
on a ticket for requestor.  The requestor role isn't allowed to
OwnTickets either though.  Why would every contact show up as a possible
owner if you can't select them as an owner when creating a ticket?

Thanks,
Nate

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com] 
Sent: Wednesday, July 13, 2005 12:03 PM
To: Kroll, Nathan Allen
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] mysql slowness




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.