cntoen

19 积分	0 好友	1 主题

发消息

数据库性能慢，是否磁盘为瓶颈？

1^#

发表于 2012-5-31 11:28:47 | 查看: 5817| 回复: 2

节点1的top
top - 11:17:57 up 5 days, 18:45,  5 users,  load average: 2.04, 2.19, 1.52
Tasks: 315 total, 1 running, 314 sleeping, 0 stopped, 0 zombie
Cpu(s):  5.3%us,  3.0%sy,  0.0%ni, 53.8%id, 29.2%wa,  0.9%hi,  7.7%si,  0.0%st
Mem: 8099060k total,  7222384k used, 876676k free, 261528k buffers
Swap: 10158072k total,       0k used, 10158072k free,  5602480k cached
  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
19446 oracle -2 0 1698m 652m 638m S 13.3  8.2 1:34.75 oracle
19442 oracle -2 0 1698m 646m 633m S 12.9  8.2 1:43.48 oracle
25581 oracle 18 0 1706m 595m 575m D  7.6  7.5 0:50.08 oracle
6773 oracle -2 0 3234m 2.3g 2.3g S  0.3 29.8  18:31.23 oracle
6783 oracle 16 0 3256m 2.6g 2.6g D  0.3 33.7 4:49.90 oracle
11941 oracle 16 0 12872 1292  824 S  0.3  0.0 0:09.65 top
26178 oracle 15 0 12872 1288  824 R  0.3  0.0 0:02.08 top
1 root    15 0 10348  696  584 S  0.0  0.0 0:01.69 init
2 root    RT  -5    0 0 0 S  0.0  0.0 0:00.01 migration/0
3 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/0
4 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/0
5 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/1
6 root    34  19    0 0 0 S  0.0  0.0 0:00.05 ksoftirqd/1
7 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/1
8 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/2
9 root    34  19    0 0 0 S  0.0  0.0 0:00.01 ksoftirqd/2
10 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/2
11 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/3
12 root    34  19    0 0 0 S  0.0  0.0 0:00.18 ksoftirqd/3
13 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/3
14 root    10  -5    0 0 0 S  0.0  0.0 0:00.04 events/0
15 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 events/1
16 root    10  -5    0 0 0 S  0.0  0.0 0:00.02 events/2
17 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 events/3
18 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 khelper
97 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 kthread

节点2top
top - 11:17:56 up 5 days, 18:45,  6 users,  load average: 0.38, 0.42, 0.62
Tasks: 288 total, 3 running, 285 sleeping, 0 stopped, 0 zombie
Cpu(s):  1.5%us,  0.7%sy,  0.0%ni, 68.3%id, 27.8%wa,  0.1%hi,  1.6%si,  0.0%st
Mem: 8099060k total,  7630272k used, 468788k free, 251732k buffers
Swap: 10158072k total, 301140k used,  9856932k free,  5955988k cached
  PID USER    PR  NI  VIRT  RES  SHR S %CPU %MEM TIME+  COMMAND
17746 oracle 15 0 1706m 450m 429m R  7.6  5.7 1:12.84 oracle
2067 oracle 16 0 12872 1260  824 R  0.3  0.0 0:06.25 top
4220 root    20 0 11056 1384  948 S  0.3  0.0 9:06.06 init.cssd
6738 oracle 15 0 3238m  60m  44m S  0.3  0.8 1:00.22 oracle
18361 oracle 16 0 12872 1260  824 R  0.3  0.0 0:01.33 top
1 root    15 0 10348  696  584 S  0.0  0.0 0:01.31 init
2 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/0
3 root    34  19    0 0 0 S  0.0  0.0 0:00.00 ksoftirqd/0
4 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/0
5 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/1
6 root    34  19    0 0 0 S  0.0  0.0 0:00.25 ksoftirqd/1
7 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/1
8 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/2
9 root    34  19    0 0 0 S  0.0  0.0 0:00.27 ksoftirqd/2
10 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/2
11 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 migration/3
12 root    34  19    0 0 0 S  0.0  0.0 0:03.30 ksoftirqd/3
13 root    RT  -5    0 0 0 S  0.0  0.0 0:00.00 watchdog/3
14 root    10  -5    0 0 0 S  0.0  0.0 0:00.05 events/0
15 root    10  -5    0 0 0 S  0.0  0.0 0:00.01 events/1
16 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 events/2
17 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 events/3
18 root    10  -5    0 0 0 S  0.0  0.0 0:00.00 khelper
97 root    11  -5    0 0 0 S  0.0  0.0 0:00.00 kthread
  104 root    10  -5    0 0 0 S  0.0  0.0 0:00.22 kblockd/0
  105 root    10  -5    0 0 0 S  0.0  0.0 0:07.62 kblockd/1

这是公司测试数据库，rac,由于公司实力花大价格钱去买fc存储，所以用了一台iscdi当存储。
ash报表在附件中,感觉数据库非常慢。