Received: (from majordomo@localhost)
	by oss.sgi.com (8.11.2/8.11.3) id f84Huwu28802
	for linux-xfs-outgoing; Tue, 4 Sep 2001 10:56:58 -0700
Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90])
	by oss.sgi.com (8.11.2/8.11.3) with SMTP id f84Husd28782
	for <linux-xfs@oss.sgi.com>; Tue, 4 Sep 2001 10:56:54 -0700
Received: from sweeney.demon.co.uk ([158.152.71.87] helo=pereskia.sweeney.demon.co.uk)
	by anchor-post-32.mail.demon.net with esmtp (Exim 2.12 #1)
	id 15eKRP-000Jl8-0W
	for linux-xfs@oss.sgi.com; Tue, 4 Sep 2001 18:56:51 +0100
Received: from rebutia.sweeney.demon.co.uk (rebutia.sweeney.demon.co.uk [10.0.0.3])
	by pereskia.sweeney.demon.co.uk (Postfix) with ESMTP id 8E4D027EF
	for <linux-xfs@oss.sgi.com>; Tue,  4 Sep 2001 18:56:49 +0100 (BST)
Received: by rebutia.sweeney.demon.co.uk (Postfix, from userid 1001)
	id BBF8B125E6; Tue,  4 Sep 2001 18:56:46 +0100 (BST)
Date: Tue, 4 Sep 2001 18:56:46 +0100 (BST)
From: Keith Matthews <keith_m@sweeney.demon.co.uk>
Subject: Re[2]: System lock while accessing files causes file corruption
To: linux-xfs@oss.sgi.com
In-Reply-To: <4.3.2.7.2.20010904193203.032499a0@pop.xs4all.nl>
References: <3B94F726.E978C299@sgi.com>
 <85063BBE668FD411944400D0B744267A888526@AUSMAIL>
 <3B94F726.E978C299@sgi.com>,
 <4.3.2.7.2.20010904193203.032499a0@pop.xs4all.nl>
X-Mailer: Mahogany, 0.60 'Redmond', compiled for Linux 2.2.13 i686
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; CHARSET=ISO-8859-1
Content-Disposition: INLINE
Message-Id: <20010904175646.BBF8B125E6@rebutia.sweeney.demon.co.uk>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by oss.sgi.com id f84Hutd28783
Sender: owner-linux-xfs@oss.sgi.com
Precedence: bulk

On Tue, 04 Sep 2001 19:33:49 +0200 Seth Mos <Seth Mos <knuffie@xs4all.nl>> wrote:

> At 17:57 4-9-2001 +0200, utz lehmann wrote:
> >Hi Eric
> >
> >Eric Sandeen [sandeen@sgi.com] wrote:
> > > But in any case, it occurred to me that you could make /etc on it's own
> > > partition, and mount that O_SYNC - I don't think that would be too much
> > > overhead, /etc doesn't get written that much on a normal system (?).  If
> > > Oracle puts config files elsewhere, you could simlink them onto this
> > > filesystem.
> >
> >You can't make /etc on a different partition than /.
> >/etc, /sbin, /dev (without devfs) must on the / partition otherwise your
> >system will not boot.

> If you use a decent layout fopr your data it does not matter.
> If you have a separate /usr /var /tmp /home like most servers do you could 
> just mount your / fs O_SYNC since it would only have a _very_ slight 
> performance loss since you almost never write to the root fs. :-)

If you use Oracle's recommended layout you have (at least ) 4 top
level mount points. It does not use OS config directories for its
config for good reasons - you may want to have more than one database
instance on a host.

Well designed layouts for database files should have no problems with
special control. Its better to have synced writes for the data files
anyway as the DBMS does its own caching.
--
Keith Matthews 			Spam trap - my real account at this 
							node is keith_m
Frequentous Consultants  - Linux Services, 
		Oracle development & database administration