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.
On 24 Jun 2004 13:42:33 -0700, Shelly Zhang
> 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=1