RE: Informix, Solaris and striping

RE: Informix, Solaris and striping

This is a discussion on RE: Informix, Solaris and striping within the Informix forums, part of the Database Server Software category; --> -----Original Message----- From: owner-informix-list@iiug.org [mailto wner-informix-list@iiug.org] On Behalf Of Neil Truby Sent: 02 August 2005 10:01 AM To: informix-list@iiug.org ...

		Unix Technical Forum > Database Server Software > Informix
RE: Informix, Solaris and striping

#1 (permalink)

04-20-2008, 08:55 AM

Dirk Moolman

Posts: n/a

RE: Informix, Solaris and striping

-----Original Message-----
From: owner-informix-list@iiug.org [mailto

wner-informix-list@iiug.org]
On Behalf Of Neil Truby
Sent: 02 August 2005 10:01 AM
To: informix-list@iiug.org
Subject: Informix, Solaris and striping

>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

I'm running the same as mentioned by Ben in his reply. On my normal TP
systems, also using JBODs, I use 16k stripe sizes, while on one of my
systems, the data warehouse, I use 64k stripe sizes, which works well
for us.

I guess it will depend on what you do most, reading or writing.

Dirk

sending to informix-list

« RE: I'm back | Re: Re: How to set variables in DTS »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 11:14 PM.