The first suspect is garbage collection. There
are various tools you can use to monitor GC and
see if those times correlate. There's a great
intro here:
http://www.lucidimagination.com/blog/2011/03/27/garbage-collection-bootcamp-1-0/
But a word of caution when re-executing the
queries. It's *possi
ene.apache.org"
> Cc:
> Sent: Wednesday, October 12, 2011 10:12 AM
> Subject: Extreme QTime
>
> We service about 25K of each particular query type per hour per server.
> QTime
> *averages* less than a second; however, there always a few (1-10) whose
> QTimes
> go
We service about 25K of each particular query type per hour per server. QTime
*averages* less than a second; however, there always a few (1-10) whose QTimes
go way above (10 - 500 seconds) the average. If I harvest these queries from
the log an re-execute them they of course execute sub-second
