Bug #27459 Unknown system variable 'skip_external_locking'
Submitted: 26 Mar 2007 23:15 Modified: 27 Mar 2007 12:04
Reporter: Eric Fox Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Locking Severity:S3 (Non-critical)
Version:5.0.37-community OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[26 Mar 2007 23:15] Eric Fox
Description:
Unable to set external locking.

How to repeat:
Install RPMS MySQL-client-community-5.0.37-0.rhel3.i386.rpm, MySQL-server-community-5.0.37-0.rhel3.i386.rpm, and MySQL-shared-compat-5.0.37-0.rhel3.i386.

Adding "skip-external-locking=off' in my.cnf under group [mysqld] has no effect.

Executing sql command 'set skip_external_locking=off;' produces: Unknown system variable 'skip_external_locking.'

Passing '-skip-external-locking' to mysqld startup does not have the desired effect.

Executing sql command 'show variables;' indicates that the system variable 'skip_external_locking = ON'
[27 Mar 2007 12:04] MySQL Verification Team
Thank you for the bug report. 'skip_external_locking' it a system variable
which is ON by default and if you want to change to OFF you need to use
'external-locking' in your my.cnf or start server option command line:

[miguel@light 5.0]$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.40-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%external%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | ON    | 
+-----------------------+-------+
1 row in set (0.00 sec)

[miguel@light 5.0]$ libexec/mysqld --external-locking
070327  8:54:01  InnoDB: Started; log sequence number 0 50068
070327  8:54:02 [Note] libexec/mysqld: ready for connections.
Version: '5.0.40-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.40-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "%locking%";
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| skip_external_locking | OFF   | 
+-----------------------+-------+
1 row in set (0.01 sec)

mysql> 

You can't set that variable using the command line client
[11 May 2010 5:34] Roel Van de Paar
See bug #53552