http://dev.mysql.com/doc/mysql/en/server-options.html : "--skip-external-locking Don't use system locking. To use isamchk or myisamchk, you must shut down the server. See Section 1.4.3, “MySQL Stability”. In MySQL 3.23, you can use CHECK TABLE and REPAIR TABLE to check and...
skip-locking: Drawbacks? Benefits?Posted by: Craig Matthews Date: May 30, 2005 11:46AM The manual is pretty quiet on this issue (unless the search function is not working as it should) so I would appreciate some experiences. I have a big table and seven small ones. Big table is ...
Re: skip-locking: Drawbacks? Benefits? Posted by:Dennis Yu Date: July 19, 2006 07:51PM I installed 5.0.22 rpm on SuSE SLES9 and copied my-large.cnf to /etc/my.cnf, found in [mysqld] section there's still a line of "skip-locking". Should I change it to "skip-external-licking...