Bug #76243 rc script does not respect both delimiters for service timeout startup
Submitted: 10 Mar 2015 13:17
Reporter: John Cesario Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.5.41 OS:Linux (RH)
Assigned to: CPU Architecture:Any

[10 Mar 2015 13:17] John Cesario
Description:
service-startup-timeout is documented here: http://dev.mysql.com/doc/refman/5.5/en/mysql-server.html#option_mysql_server_service-start....

The RC script does not respect the option if using _ for delimiters

head -n 3 /etc/my.cnf
[mysql.server]
service-startup-timeout = 1800

% 13:14 <vagrant@db1:/data/mysql $ > sudo bash -x  /etc/init.d/mysql status 2>&1 | grep service_startup_timeout
+ service_startup_timeout=900
+ service_startup_timeout=1800

% 13:14 <vagrant@db1:/data/mysql $ > head -n 3 /etc/my.cnf
[mysql.server]
service_startup_timeout = 1800

% 13:14 <vagrant@db1:/data/mysql $ > sudo bash -x  /etc/init.d/mysql status 2>&1 | grep service_startup_timeout
+ service_startup_timeout=900

How to repeat:
add the following to /etc/my.cnf: 

<<<
[mysql.server]
service_startup_timeout = 1800
<<<

sudo bash -x /etc/init.d/mysql start
sudo bash -x /etc/init.d/mysql stop

Note the value of service-startup-timeout is unchanged from default

Suggested fix:
Respect both _ and - in /etc/my.cnf
[10 Mar 2015 15:55] Peter Laursen
In my understanding *options* are specifiedw ith "-" ; whereas variables are specifie dwith a "_" (like this-is-an-option & this_is_a_variable). 

A server variable will often inherit its value from an option specified on the options file or on the command line but an option is still not a variable and vice versa.

http://dev.mysql.com/doc/refman/5.6/en/server-options.html
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html

But I also think that MySQL is not everywhere consistent in this respect (I believe I remember some old reports where such *incorrect typing* of options is accepted). 

-- Peter
-- not a MySQL/Oracle person