On Tue, Aug 30, 2011 at 2:50 AM, Sim Zacks <sim(at)compulab(dot)co(dot)il> wrote:
>
> Instead of restarting the database try swapoff -a && swapon -a and see if
> that helps performance. If it is that little swap in use, it might be
> something else clogging up the works.
Check to see if kswapd is going crazy or not. If it is, that's the
pathological behavior I was talking about earlier. It works real hard
at doing nothing and the machine grinds to a halt. swapoff -a fixed
it. And it was happening about every 2 weeks for me too.