From owner-freebsd-questions Tue Feb 5 11:51:56 2002 Delivered-To: freebsd-questions@freebsd.org Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by hub.freebsd.org (Postfix) with ESMTP id F3D9937B41D for ; Tue, 5 Feb 2002 11:51:52 -0800 (PST) Received: (from dan@localhost) by dan.emsphone.com (8.11.6/8.11.6) id g15Jpn874798; Tue, 5 Feb 2002 13:51:49 -0600 (CST) (envelope-from dan) Date: Tue, 5 Feb 2002 13:51:49 -0600 From: Dan Nelson To: "Eric J. Schwertfeger" Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Using raw slices with InnoDB/MySQL? Message-ID: <20020205195149.GJ12749@dan.emsphone.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.27i X-OS: FreeBSD 5.0-CURRENT X-message-flag: Outlook Error Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG In the last episode (Feb 05), Eric J. Schwertfeger said: > I've got a slice that was set up, and at one time even newfs'ed and > mounted, but is no longer in use, /dev/da1s1e. Whenever anyone tries > to write to the slice, including root, I get a readonly file error. > > Since the slice works fine if I newfs and mount it, I'm pretty sure > that this is some kind of protection that FreeBSD enforces keeping > filesystems from getting wiped. A raw device will go readonly if you have a filesystem mounted on it, or if your securelevel is 1 or higher. Or if your disk is jumpered read-only :) > As a side note, the InnoDB/MySQL combination allows for database > files larger than 4GB on "some operating systems" but the > InnoDB/MySQL docs don't mention which features are needed. Any > FreeBSD MySQL users out there have the answer to this? InnoDB on FreeBSD should be able to go over 4gb with no problems (FreeBSD has always had 64-bit file offsets). -- Dan Nelson dnelson@allantgroup.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message