disk IO request queue 2005-08-05 - By nasvel
Back
Hi,
since some weeks our database server (redhat taroon + oracle 9i)
suffered from a very bad performance. The load avg climbed sometimes to
80% :(, althought I think I've a powerful machine (HP, 3 Intel Xeon with
16G memory).
To try to find out the problem, I looked at the iostat report. I found
the await time are pretty high, and the average queue length is about
10. Someone told me that it is normal for a DB server, but I have some
doubt, so I would like to have you guy's opinions about that...
any suggestion is welcome, thanks
dux
=== begin output ===
Linux 2.4.9-e.62enterprise 05.08.2005
cpu-moy: %user %nice %sys %idle
17,63 0,02 12,31 70,04
Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz
await svctm %util
cciss/c1d1p1
889,26 11,04 515,44 13,11 623,61 193,26 1,55 10,62
21,30 8,03 42,42
cciss/c1d0p1
273,76 45,13 100,64 48,85 872,20 751,95 10,86 10,62
114,52 26,39 39,45
cciss/c1d2p1
198,26 108,73 107,90 27,83 326,31 1061,51 10,22 10,62
100,75 26,34 35,76
cciss/c1d3p1
233,38 29,04 89,97 30,70 463,79 477,95 7,80 8,29
68,69 26,78 32,32
=== end output ===
--
Taroon-list mailing list
Taroon-list@(protected)
http://www.redhat.com/mailman/listinfo/taroon-list
Earn $52 per hosting referral at Lunarpages.
|
|
