[rt-users] How to avoid a huge dataset returning

[Michael Stepanov]

I use RT 3.8.2

On Fri, Sep 16, 2011 at 6:02 PM, Kevin Falcone <falcone at bestpractical.com>wrote:

> On Fri, Sep 16, 2011 at 05:08:24PM +0300, Michael Stepanov wrote:
> > Hi,
> >
> > Our RT3 system is a big and it crashes time to time. Today we found one
> > query in the slow queries log which killed the system:
> > *
> > # Query_time: 97  Lock_time: 0  Rows_sent: 15906633  Rows_examined:
> 39069181
> > SELECT main.* FROM Transactions main  WHERE (main.Type = 'Create' OR
> > main.Type = 'Comment' OR main.Type = 'Correspond')  ORDER BY main.Created
> > ASC, main.id ASC;
> > *
> > Is there a way to reduce a number of returning records on the application
> > level?
>
> That doesn't looks like a standard RT query, but you haven't provided
> your version.  You'll probably want to turn on the StatementLog option
> and figure out where that query is coming from so you can fix the
> source.
>
> -kevin
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> *  Chicago, IL, USA — September 26 & 27, 2011
> *  San Francisco, CA, USA — October 18 & 19, 2011
> *  Washington DC, USA — October 31 & November 1, 2011
> *  Melbourne VIC, Australia — November 28 & 29, 2011
> *  Barcelona, Spain — November 28 & 29, 2011
>



-- 
Cheers,
Michael
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110916/5023157a/attachment.htm>