On 4/6/07, Jesse Vincent <[EMAIL PROTECTED]> 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
# [EMAIL PROTECTED]: 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--
Best regards, Ruslan.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
