From: | tv(at)fuzzy(dot)cz |
---|---|
To: | "Merrick" <merrick(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: RAID 1 - drive failed - very slow queries even after drive replaced |
Date: | 2011-03-23 09:25:01 |
Message-ID: | 78c68456526930bd70d2c8a63c873fa6.squirrel@sq.gransy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Hi,
>
> I am looking for some advice on where to troubleshoot after 1 drive in
> a RAID 1 failed.
>
> Thank you.
>
> I am running v 7.41, I am currently importing the data to another
> physical server running 8.4 and will test with that once I can. In the
> meantime here is relevant info:
>
> Backups used to take 25 minutes, and now take 110 minutes, before
> replacing the drive it became clear the backup was not going to finish
> since in 120 minutes it had only finished 200mb of 2.8gb.
What kind of RAID is this? I know it's RAID1, but is it built using linux
sw raid (md), or is it some other solution (like a hw card)? Can you post
some diagnostics info like
mdadm --detail /dev/md1
or something like that? I guess this would be reflected in the iostat
output (at least for the 'md') but I'm not sure. Maybe there's something
still in progress (sync of the new drive?).
Tomas
From | Date | Subject | |
---|---|---|---|
Next Message | tv | 2011-03-23 09:32:11 | Re: Utilities for managing streaming replication servers? |
Previous Message | John R Pierce | 2011-03-23 09:18:22 | Re: Utilities for managing streaming replication servers? |