Re: Need suggestions for filesystem config, spindle separation, striping for HP-UX/PeopleSoft

kyle hailey wrote:

>
> On the orginal posters question, it seems to depend so much on what
> they are doing. For one I didn't get whether they had 2 striped disks
> and a 3rd disk or if all they had was two striped disks or if they had
> partitions on each of the two disks plus a third partition that was
> striped over the two disks. Either way it all depends on what they are
> doing, where does the application typically wait, how much of the data
> can be cached in the buffer cache. Typically the waits are on log
> sync and reads. The reads can be eliminated/reduced by the buffer
> cache, but the log syncs are a part of life. If there is alot of data
> changing, I would have a tendency to save the extra disk for redo, but
> how much data is going through a 2 disk pc setup and .. if .. but
> ...
>
> Best
> Kyle
>
> With a two disk system, it seems like such a huge list of
> compromises that it doesn't seem worth res
>
> Given a two disk system, my reaction to would be a bit of a brazen,
> "who cares".

Here's the deal: I have two spindles total. This is HP-UX, not a pc. I'm planning to setup three basic "partitions", a non-striped area on one, a non-striped area on the other, and a striped area across both. All the o/s volumes are on one of the drives, along with which I will be placing two new non-striped volumes on this same drive: one for oracle s/w, one for system tablespace and rollback tablespace. On the other drive, I'll have one more non-striped volume for the temp tablespace, redo logs, control files, and an area to hold dumps, etc. On the striped volume (bulk of the total space), I'm planning to put both the data tables and indexes together (but in separate tablespaces).

The application is PeopleSoft, an OLTP/DSS hybrid. But, since this is the dev platform, I'm tilting toward DSS since we'll be doing more mass-data operations on this platform than OLTP.

True, I know with only two disks there's going to be a lot of compromises, but still I do think the configuration can be optimized to at least balance between the two. Will let you know how it works.

John Received on Wed Feb 21 2001 - 11:46:38 CST