MySQL Bugs: #55290: ability to specify ON/OFF as parameter values in config files

Bug #55290	ability to specify ON/OFF as parameter values in config files
Submitted:	15 Jul 2010 15:10	Modified:	24 Nov 2010 3:41
Reporter:	Matthew Lord	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S4 (Feature request)
Version:	all	OS:	Any
Assigned to:	Tatiana Azundris Nuernberg	CPU Architecture:	Any

Description:
Currently you can only specify 0/1 for config file options that take a boolean value.  It would be nice if the config file options were consistent with what you set and see within mysqld.  For example:

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

mysql> set global slow_query_log=OFF;
Query OK, 0 rows affected (0.03 sec)

mysql> show global variables like "slow_query_log";
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| slow_query_log | OFF   |
+----------------+-------+
1 row in set (0.00 sec)

This would lead one to think that this is a valid config file option, but it is not:
slow_query_log=ON

How to repeat:
N/A

Suggested fix:
Allow the use of ON/OFF for server options in the config files.

Tested with ~/.my.cnf on 5.6.1-m5-debug, works with true/false and on/off.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html