Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Sep 292010

Enable external locking in MySQL


External locking is a method that allow MySQL aware of external program(s) might also have access to the database tables as the same time, so if other programs locked the files, MySQL will wait until those files are unlocked.

This is not recommended and poor for MySQL performance, so you should turn off it unless you have multiple MySQL servers using the same database directory.

To enable it, edit the MySQL configurations, e.g. /etc/my.cnf


Don't forget to restart MySQL to take effect.

# /sbin/service mysqld restart

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>