[rt-users] Really slow Search page startup suddenly

[Ruslan Zakirov]

On 4/6/07, Jesse Vincent <jesse at bestpractical.com> wrote:
>
>
> On Apr 6, 2007, at 8:05 AM, Philip Kime wrote:
>
> Strangely, our RT server has suddenly started being really slow loading up
> the search page and running searches - the same query is logged in the
> slow-log every time - any ideas:
>
> Likely you granted some large group of users the right to own tickets.
"Rows_sent: 288  ", So it's not that large group, but "Rows_examined:
54167891" wwhat is really wierd.

>
> # Time: 070405 16:01:56
> # User at Host: rt_user[rt_user] @ localhost []
> # Query_time: 38  Lock_time: 0  Rows_sent: 288  Rows_examined: 54167891
> SELECT DISTINCT main.* FROM Users main , Principals Principals_1,
> CachedGroupMem
> bers CachedGroupMembers_2, Groups Groups_3, ACL ACL_4  WHERE
> ((ACL_4.PrincipalTy
> pe = Groups_3.Type)) AND ((ACL_4.RightName = 'OwnTicket')) AND
> ((CachedGroupMemb
> ers_2.MemberId = Principals_1.id)) AND ((Groups_3.id =
> CachedGroupMembers_2.Grou
> pId)) AND ((Principals_1.Disabled = '0')) AND ((Principals_1.PrincipalType =
> 'Us
> er')) AND ((Principals_1.id != '1')) AND ((main.id = Principals_1.id)) AND
> ((ACL
> _4.ObjectType = 'RT::Queue') OR (ACL_4.ObjectType = 'RT::System')) AND
> ((Groups_
> 3.Domain = 'RT::Queue-Role') OR (Groups_3.Domain = 'RT::System-Role'))
> ORDER BY
>  main.RealName ASC;
>
>
> --
> Philip Kime
> NOPS Systems Architect
> 310 401 0407
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>


-- 
Best regards, Ruslan.