<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=384495522-31012002><FONT face=Arial color=#0000ff size=2>from
the look of it, what someone has done, is searched for a ticket with 2 or
more differenet requestors.</FONT></SPAN></DIV>
<DIV><SPAN class=384495522-31012002><FONT face=Arial color=#0000ff size=2>The
query just to find tickets by 1 requestor is very heavy (and shouldn't really
be! hopefully this will be fixed up in the future), adding more requestors onto
it blows the query right out.</FONT></SPAN></DIV>
<DIV><SPAN class=384495522-31012002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=384495522-31012002><FONT face=Arial color=#0000ff size=2>I've
actually changed around my search pages so staff cannot search via requestor
(they need to go through our customer info pages to get the
tickets).</FONT></SPAN></DIV>
<DIV><SPAN class=384495522-31012002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=384495522-31012002><FONT face=Arial color=#0000ff size=2>I
wouild suggest making it so only one requestor can be in the search query at a
time, then you will see this query disappear i think</FONT></SPAN></DIV>
<DIV><SPAN class=384495522-31012002></SPAN> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]<B>On
Behalf Of </B>Derek Buttineau<BR><B>Sent:</B> Friday, 1 February 2002 4:31
AM<BR><B>To:</B> rt-users@lists.fsck.com<BR><B>Subject:</B> [rt-users] Odd
Question<BR><BR></FONT></DIV>
<DIV><FONT face=vt100 size=2>Been running into this lately with the our
RT2-0-11 setup, and have seen the same issue coming from previous
versions back to RT2-0-1.. </FONT></DIV>
<DIV><FONT face=vt100 size=2></FONT> </DIV>
<DIV><FONT face=vt100 size=2>We've been seeing RT overload itself on the SQL
backend (mysql) occasionally as of late.</FONT></DIV>
<DIV><FONT face=vt100 size=2></FONT> </DIV>
<DIV><FONT face=vt100 size=2>Today I managed to catch the query that was
causing it, which is:</FONT></DIV>
<DIV><FONT face=vt100 size=2></FONT> </DIV>
<DIV><FONT size=2>
<P>SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Watchers
Watchers_3, Watchers Watcher</P>
<P><FONT face=vt100>When this happens it locks the RT Tickets table while it
copies the query to a tmp database:</FONT></P>
<P><FONT face=vt100>| 5933 | rtuser |
localhost |
rt2 | Query | 447 | Copying to
tmp table | SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1,
Watchers Watchers_3, Watchers Watcher |</FONT></P>
<P><FONT face=vt100>However, we're seeing this sit for up to hours without
resolution.. I end up having to flush the processes in order for RT to resume
operation.</FONT></P>
<P><FONT face=vt100>Has anyone else ran into this and/or know how to resolve
it?</FONT></P>
<P><FONT face=vt100>Thanks,</FONT></P>
<P><FONT face=vt100><BR>Derek</FONT></P></FONT></DIV></BLOCKQUOTE></BODY></HTML>