MySQL Bugs: #27459: Unknown system variable 'skip_external

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

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'

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

See bug #53552