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
Triage: Needs Triage: D5 (Feature request)

[15 Jul 2010 15:10] Matthew Lord
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.
[24 Nov 2010 3:41] Tatiana Azundris Nuernberg
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