I use RT 3.8.2 On Fri, Sep 16, 2011 at 6:02 PM, Kevin Falcone <[email protected]>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
-------- 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
