Re: RAID 1 - drive failed - very slow queries even after drive replaced - Mailing list pgsql-general

From tv@fuzzy.cz
Subject Re: RAID 1 - drive failed - very slow queries even after drive replaced
Date
Msg-id 78c68456526930bd70d2c8a63c873fa6.squirrel@sq.gransy.com
Whole thread Raw
In response to RAID 1 - drive failed - very slow queries even after drive replaced  (Merrick <merrick@gmail.com>)
List 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


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Utilities for managing streaming replication servers?
Next
From: Adrian Schreyer
Date:
Subject: Re: Weird problems with C extension and bytea as input type