On Thu, Jan 18, 2001 at 10:13:15AM +0100, Marco Bizzarri wrote:
> Hi all...
>
> I would like to have some explanation about skip-locking feature of
> the safe_mysqld. I've already read the manual pages of safe_mysqld.
>
> The questions are as follows:
>
> 1) for a single daemon installation, without any isamcheck occuring
> during normal operation, is there any difference in using this feature?
Nope. skip-locking is safe in that case.
> 2) in the same condition as 1) is there any difference if I use also
> ODBC clients to access mysql?
skip-locking is safe then, too.
Basically, skip-locking tells MySQL that it is in complete control of
the data files and no external programs (or other instances of mysqld)
will be trying to manipulate those files. If you run multiple mysqld's
on the same machine (for example), then you need locking so that
they'll cooperate with each other.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
