From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Need to find out which process is hitting hda |
Date: | 2007-12-13 11:06:55 |
Message-ID: | 1197544015.3945.59.camel@neuromancer.home.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using centos 5 as the OS so, there's no fancy dtrace to look at
which processes is causing my disks to thrash.
I have 4 disks in the box. (all ide, 7200rpm)
1 OS disk [hda]
2 raided (1) disks [hdb/hdc]
1 pg_xlog disk (and also used as an alternate tablespace for [hdd]
temp/in-transit files via select, insert into tmp table. delete from tmp
table, insert into footable select * from tmp table)
Problem now I see from both atop and iostat, the Device: (iostat -dx 10)
rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
hda 98.60 14.69 121.98 15.08 1775.02 2908.29 34.17 47.53 551.67 7.29 99.95
hdb 0.70 4.20 16.48 2.30 304.50 51.95 18.98 0.21 10.94 8.45 15.86
hdc 0.00 3.40 12.49 2.00 223.78 43.16 18.43 0.07 5.04 4.42 6.40
hdd 0.00 56.94 0.50 3.70 53.55 485.91 128.57 0.02 5.48 3.95 1.66
md0 0.00 0.00 29.57 11.89 526.67 95.10 15.00 0.00 0.00 0.00 0.00
the number of writes and reads on hda is much greater than expected and I'm not sure who/what is causing it.
Thanks for any clues.
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2007-12-13 11:09:35 | Re: For the SQL gurus out there |
Previous Message | Richard Broersma Jr | 2007-12-13 11:06:12 | Re: For the SQL gurus out there |