[rt-devel] problem with rt3-rc1, 'Reply' to a ticket, and slow mysql query...

[Jesse Vincent]

Noted and replicated. I'll see what I can do today. Incidentally, is
your mysql compiled with InnoDB support?


On Mon, Mar 17, 2003 at 09:40:00AM -0600, Joseph W. Breu wrote:
> With RT3 RC1, replying to a ticket creates a slow query on the mysql server:
> 
> SELECT DISTINCT main.* FROM Users main, Principals Principals_1,
> CachedGroupMembers CachedGroupMembers_2, Groups Groups_3, Principals
> Principals_4, ACL ACL_5, CachedGroupMembers CachedGroupMembers_6   WHERE
> ((ACL_5.RightName = 'SuperUser')OR(ACL_5.RightName = 'OwnTicket')) AND
> ((CachedGroupMembers_2.GroupId = '4')) AND ((Principals_1.Disabled = '0'))
> AND ((Principals_1.PrincipalType = 'User')) AND (ACL_5.ObjectType =
> 'RT::System'  OR (ACL_5.ObjectType = 'RT::Queue'  AND ACL_5.ObjectId =
> '9') ) AND ( Principals_4.id = Groups_3.id  AND (ACL_5.PrincipalId =
> Principals_4.Id  AND ACL_5.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.Instance = '9')  OR ( Groups_3.Domain = 'RT::Ticket-Role' AND
> Groups_3.Instance = '3222')  )  AND Groups_3.Type = ACL_5.PrincipalType
> AND Principals_4.PrincipalType = 'Group') )  AND main.id = Principals_1.id
>  AND Principals_1.id = CachedGroupMembers_2.MemberId  AND
> CachedGroupMembers_6.MemberId = Principals_1.Id  AND
> CachedGroupMembers_6.GroupId = Principals_4.Id  ORDER BY main.Name ASC
> 
> 
> The application pauses for almost 5 minutes before the query completes and
> the reply screen comes up.
> 
> Latest modules and mysql 3.23.54 on a redhat 7.3 machine.  This only
> started to happen when I went to 3.0 rc1.  We were running a 3.0 beta
> before.
> 
> 
> -- 
> Thanks,
> 
> ---------------------------------------------------------
> Joseph W. Breu, CCNA             fax : +1.319.266.8158
> Senior Network Administrator     url : http://www.cfu.net
> Cedar Falls Utilities
> 
>                 question = ( to ) ? be : ! be;
> 		              -- Wm. Shakespeare
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.