Box is hanging and overloading
Hi
I have mysql server ( OS:FreeBSD) is have 8 cores cpus and 8GB RAM.
Sometime, Box's top is not showing the cpu utilization. Output looks as follows
last pid: 44258; load averages: 0.38, 0.42, 0.23 up 0+16:31:11 07:15:14
169 processes: 14 running, 136 sleeping, 19 waiting
CPU: % user, % nice, % system, % interrupt, % idle
Mem: 840M Active, 1664M Inact, 296M Wired, 14M Cache, 214M Buf, 5111M Free
Swap: 8192M Total, 8192M Free
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
16 root 1 171 52 0K 16K RUN 1 963:19 99.02% idle: cpu1
11 root 1 171 52 0K 16K RUN 6 953:50 98.83% idle: cpu6
10 root 1 171 52 0K 16K RUN 7 959:30 98.68% idle: cpu7
12 root 1 171 52 0K 16K CPU5 5 958:12 98.68% idle: cpu5
13 root 1 171 52 0K 16K RUN 4 949:45 98.39% idle: cpu4
15 root 1 171 52 0K 16K RUN 2 948:04 98.24% idle: cpu2
17 root 1 171 52 0K 16K CPU0 0 950:13 98.05% idle: cpu0
14 root 1 171 52 0K 16K RUN 3 871:57 98.00% idle: cpu3
1312 mysql 29 96 0 3391M 793M ucond 7 120:13 0.00% mysqld
19 root 1 -32 -151 0K 16K WAIT 0 12:08 0.00% swi4: clock sio
Moreover, WCPU is >98%. But not much processes are running on that server.
Need suggestion to get the info about cpu or box ?
1. How to proove that box is having CPU issue
2. Is it related to memory ?
Thanks
|