Informix, Solaris and striping
Neil Truby, running IDS 10.0 FC3 on Solaris 9 with Sun Volume Manager striping in RAID 0+1, asked the best stripe interlace size for Informix (Solaris default 16k; he set 64k). Superboer recalled (16 x pagesize) x 2 in the past but was unsure for version 10. Ben Thompson said IBM xSeries hardware recommends 16KB for OLTP, and Paul Watson runs 16K. No firm answer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 #