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 = 'Commen
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 m
I use RT 3.8.2
On Fri, Sep 16, 2011 at 6:02 PM, Kevin Falcone 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:
> > *
> > # Q
On Fri, Sep 16, 2011 at 09:02:36PM +0300, Michael Stepanov wrote:
>I use RT 3.8.2
That still doesn't look like a standard RT query.
You'll need to move on to my other suggestion.
> your version. You'll probably want to turn on the StatementLog option
> and figure out where that quer
- Original Message -
> From: "Kevin Falcone"
> 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.
Which makes you a goo
On Fri, Sep 16, 2011 at 02:31:37PM -0400, Jay Ashworth wrote:
> - Original Message -
> > From: "Kevin Falcone"
>
> > 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 tha
- Original Message -
> From: "Kevin Falcone"
> This destroys mysql's query cache, which is a very nice performance
> win.
Oh hell; of course.
> On RT4 you can enable the statement log and see every query run
> on a page with pointers into the source that executed it.
That doesn't help,
On Fri, Sep 16, 2011 at 02:40:42PM -0400, Jay Ashworth wrote:
> - Original Message -
> > From: "Kevin Falcone"
>
> > On RT4 you can enable the statement log and see every query run
> > on a page with pointers into the source that executed it.
>
> That doesn't help, though, on a large rea
> > That doesn't help, though, on a large realtime system, and
> > especially not on code that isn't RT. :-)
>
> I actually have found it to be my favorite new RT4 feature, especially
> for improving the performance of large systems.
I'm sure it's very nice (and since I'm probably about to instal