From: Eric Bergen
Date: June 24 2004 10:40pm
Subject: Re: File locking & mysql 4
List-Archive: http://lists.mysql.com/mysql/167875
Message-Id: <11b1bd99040624154060b5dc51@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

MySQL itself doesn't require file locking. Infact there is an option
to turn it off. --skip-external-locking that disables using the
flock() system call. Just watch out
that you don't accidently start two mysqlds on the same datadir. 

-Eric

On 24 Jun 2004 13:42:33 -0700, Shelly Zhang
<mysql-zrxve@stripped> wrote:
> 
> Does mysql 4 require file locking?  I'm not talking about in the
> database -- I know how to lock and unlock tables for data consistency.
> I'm referring to the filesystem that the data lives on.
> 
> For reasons too boring to go in to, I have a mysql server and I'm keeping
> the database files (i.e., the var directory) on a filesystem that doesn't
> support file locking.  Is this going to pose a problem?
> 
> If this is being sent to the wrong mailing list, please point me to the
> right one.
> 
> Any help will be appreciated!
> 
> --
> Shelly Zhang
> mysql-zrxve AT mysql-zrxve DOT kicks-ass DOT org
> (Yes, that address works.)
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.bergen@stripped
> 
>