Re: Filesystem blocksize for archive logs on AIX

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 29 Oct 2013 09:32:59 -0500
Message-ID: <CAP79kiRoM=gVzTzLbB0oLy644CiqtOz5rEUNyu17jgL_XTZ-yQ_at_mail.gmail.com>

This is the first time (I think) I've heard of performance degradation due to filesystem block size not matching. Is there some guidance (whitepapers etc) on this? I should probably buff up on some of that *if* there is a large penalty involved.
Thanks,
Chris

On Tue, Oct 29, 2013 at 4:18 AM, Nuno Souto <dbvision_at_iinet.net.au> wrote:

> On 29/10/2013 3:00 AM, Rich Jesse wrote:
>
> What does destroy the performance is to use a file system block size
> larger than the db block size.
> No danger of that with JFS2 and db_block_size=8K! :)
>
> But a clear danger of that, if using std redos (512) and a default file
> system blocksize of 4K,
> as the other poster pointed out. That's when one has to match things.
> One way or the other.
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 29 2013 - 15:32:59 CET