IDS 10.0 FC3 on Solaris 9

I've been looking into RAID on a new server I'm setting up. I have 6 disks
in an external, JBOD, array, so have striped the Informix server over 3 of
these then mirrored to the other 3 in classic RAID 0+1 fashion. Because of
the way in which the striping is achieved (Sun Volume Manager's metadevices)
this actually gives RAID 1+0 protection, so I read.

My question is, has anyone any experience or anecdote to share on the
optimal interlace size for Informix (the interlace is stripe size used by
the striping algorithim)? The Solaris default is 16k, though I set it to
64k based on an article I read on Oracle performance tuning written in
January 1995.

Thanks
Neil

Hello Neil,

it used to be (16 * pagesize ) * 2 on things i have done;
where 16 was maxiosize.... and 2 was to try and avoid split writes

however since one can configure pagesize nowadays i have no clue
what the maxiosize is; and i havenot played with V 10 yet..
so maybe someone else can tell you what maxiosize is....

Superboer.


Neil Truby schreef:

> IDS 10.0 FC3 on Solaris 9
>
> I've been looking into RAID on a new server I'm setting up. I have 6 disks
> in an external, JBOD, array, so have striped the Informix server over 3 of
> these then mirrored to the other 3 in classic RAID 0+1 fashion. Because of
> the way in which the striping is achieved (Sun Volume Manager's metadevices)
> this actually gives RAID 1+0 protection, so I read.
>
> My question is, has anyone any experience or anecdote to share on the
> optimal interlace size for Informix (the interlace is stripe size used by
> the striping algorithim)? The Solaris default is 16k, though I set it to
> 64k based on an article I read on Oracle performance tuning written in
> January 1995.
>
> Thanks
> Neil

Neil Truby wrote:

> My question is, has anyone any experience or anecdote to share on the
> optimal interlace size for Informix (the interlace is stripe size used by
> the striping algorithim)? The Solaris default is 16k, though I set it to
> 64k based on an article I read on Oracle performance tuning written in
> January 1995.

Our IBM xSeries (Intel) kit recommends 16kb stripes for OLTP databases.
A specific database engine is not mentioned. I don't know how useful
this recommendation is as we have not tested performance ourselves or
how it may apply to your equipment. Disc latency is not an issue on this
kit for us however...

Ben.

Neil Truby wrote:

> IDS 10.0 FC3 on Solaris 9
>
> I've been looking into RAID on a new server I'm setting up. I have 6 disks
> in an external, JBOD, array, so have striped the Informix server over 3 of
> these then mirrored to the other 3 in classic RAID 0+1 fashion. Because of
> the way in which the striping is achieved (Sun Volume Manager's metadevices)
> this actually gives RAID 1+0 protection, so I read.
>
> My question is, has anyone any experience or anecdote to share on the
> optimal interlace size for Informix (the interlace is stripe size used by
> the striping algorithim)? The Solaris default is 16k, though I set it to
> 64k based on an article I read on Oracle performance tuning written in
> January 1995.
>
> Thanks
> Neil
>
>

We run ours at 16K, but will probably start to review if we start to
tune the Buffer page size

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #