RE: DATABASE SERVER HIGH LOAD AVERAGE - CRITICAL

Hi,

Today our Database live server suddenly gone load averange around 400.

When i check for the cpu idle time was 0% constently. Also checked for vmstat 5 5 for any bottelneck. That output says below

drdb-01% vmstat 5 5
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr m1 m1 m1 m2   in   sy   cs us sy id
 0 2 0 126894048 80561976 2176 816 7258 1 1 0 0 1 1 1 -0 2011 26605 5538 11 3 87
 463 2 0 121253440 72276680 3429 406 19119 0 0 0 0 0 0 0 0 6096 102255 23672 93 7 0
 468 2 0 121247440 72294512 3326 707 17962 0 0 0 0 0 0 0 0 6103 84450 23322 93 7 0
 453 19 0 121245488 72308952 5874 621 32209 0 0 0 0 0 0 0 0 9262 165323 24262 91 9 0
 468 3 0 121244616 72324736 5561 730 29570 0 0 0 0 5 4 5 0 8805 152565 24266 91 9 0

After 15min the load come down to almost 5%. Now the Vmstat 5 5 output says below

drdb-01 # vmstat 5 5
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr m1 m1 m1 m2   in   sy   cs us sy id