MySQL Bugs: #76243: rc script does not respect both delimiters for service timeout startup

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

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

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

Hi Mr. Cesario,

Thank you for your bug report.

Unlike the options specified under [mysqld] header, all other options have to use dash sign '-' and not '_'. Let us know if it helps ................

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".