Re: Queries sometimes take 1000 times the normal time

Just to add to the clutch here, also check your bdflush settings (if
you're on linux) or equivalent (if you're not.)

Many times the swapping algo in linux can be quite bursty if you have it
set to move too many pages at a time during cleanup / flush.