[rt-users] Severe performance problems suddenly in RT 3.8.2

[Ruslan Zakirov]

On Tue, Feb 17, 2009 at 8:47 PM, Dave Holland <dh3 at sanger.ac.uk> wrote:
> Tim's just got into his car to go home, but I can provide some
> answers...
>
> On Tue, Feb 17, 2009 at 12:29:10PM -0500, Jesse Vincent wrote:
>> On Tue 17.Feb'09 at 16:51:57 +0000, Tim Cutts wrote:
>> > We migrated our RT server to RT 3.8.2 a week ago, and all went well
>> > until today,
>> From what version?
>
> 3.4.2
>
>> Anything in mysql's error logs?
>
> No, only the messages in the slow log, e.g:
>
> # Query_time: 240  Lock_time: 0  Rows_sent: 4  Rows_examined: 27

I hope you see that mysql examined only 27 rows and spend 240 seconds
to do that. I suspect that it's related to very high IO activity that
were going parallel with this query and blocked mysql's IO requests.

[snip]

-- 
Best regards, Ruslan.