On Tue, Feb 17, 2009 at 8:47 PM, Dave Holland <d...@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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com