On 07/23/2012 10:46 PM, Jim Vanns wrote:
> Nothing obvious - and we log a fair amount. No tmp table creations,
> no locks held.
>
> To add to this EXPLAIN reports it took only 0.23ms to run (for example)
> whereas the wall clock time is more like 20-30 minutes (or up to n hours
> as I said where everything appears to click back into place at the same
> time).
How many concurrent connections do you have?
--
Craig Ringer