请教各位专家一下两个问题:
1、通过iostat发现IO比较繁忙,数据库比较忙,通过top发现以下db2的进程,
2、可以通过TOP里面的PID进程号找到对应执行程序或sql吗?
iostat:
Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 16.20 0.00 1.40 0.00 70.40 100.57 0.00 0.29 0.29 0.04
sdb 13.60 0.60 85.60 10.80 17774.40 72.00 370.26 2.43 25.30 10.32 99.52
sdc 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sdd 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sde 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
top:
top - 14:44:45 up 13 days, 20:37, 6 users, load average: 1.86, 2.38, 3.08
Tasks: 859 total, 1 running, 856 sleeping, 0 stopped, 2 zombie
Cpu(s): 0.6%us, 0.2%sy, 0.0%ni, 87.4%id, 11.7%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 16436148k total, 14703416k used, 1732732k free, 283560k buffers
Swap: 2096472k total, 9952k used, 2086520k free, 12273852k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11659 db2inst4 24 0 15.3g 5.2g 4.8g S 8 33.5 5167:12 db2sysc 8188 root 15 0 13244 1688 812 R 1 0.0 0:14.24 top
10441 root 15 0 235m 27m 10m S 1 0.2 391:23.78 java 965 root 0 -20 0 0 0 S 0 0.0 48:49.72 mpp_dcr
11307 db2inst3 23 0 1155m 137m 59m S 0 0.9 46:39.31 db2sysc
11660 root 15 0 581m 28m 18m S 0 0.2 2:33.34 db2syscr
11661 root 15 0 581m 28m 18m S 0 0.2 2:33.63 db2syscr
1 root 15 0 10328 696 580 S 0 0.0 0:03.77 init
2 root RT -5 0 0 0 S 0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0 0.0 1:10.37 ksoftirqd/0
4 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0 0.0 0:00.05 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.53 ksoftirqd/1
收起