MySQL Bugs: #52993: Fast Shutdown always indicated even though NOT set

Bug #52993	Fast Shutdown always indicated even though NOT set
Submitted:	20 Apr 2010 16:08	Modified:	22 Apr 2010 13:58
Reporter:	Paul Rudge	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.19 m3	OS:	Windows (XP SP3)
Assigned to:		CPU Architecture:	Any
Tags:	Fast Shutdown

Description:
On starting the Admin mode of Workbench, the variable innodb_fast_shutdown always shows a tick - even when the variable is NOT set in the my.ini file.

How to repeat:
To avoid confusion - stop the instance and ensure the variable is NOT present in the my.ini file.

Restart instance and open up the Workbench / Admin.

Examine the INNODB Paramaters Tab - Fast Shutdown is ticked.

To reiterate, if you untick the box and try to apply, a blank SQL form appears showing that nothing is changing - the paramater is NOT set in the my.ini file. 

Conversely, if you then tick the option and apply, the SQL statement shows it will now add the variable to the file correctly.

Suggested fix:
I believe it is just a form default, since the my.ini file is showing true results.

Thank you for the bug report. Please do the test with mysql.exe client:

[miguel@tikal ~]$ dbs/5.5-mr/bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.99-m4-debug Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show variables like "%shut%";
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 1     |
+----------------------+-------+
1 row in set (0.01 sec)

mysql> set global innodb_fast_shutdown=2;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like "%shut%";
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 2     |
+----------------------+-------+
1 row in set (0.00 sec)

mysql> 

the above was done without any my.ini/my.cnf file.

Using the mysql client.exe and setting the parameter as below made NO difference.

set global innodb_fast_shutown = 2
Restarted instance, checked Workbench Admin / Configuration tab - still ticked
Repeated for value 0, same result.

I still believe it is a 'Form' default for the check box on the INNODB tab

This variable has value 1 by default. Check http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_fast_shutdown.

When I set it to 0 with:

mysql> set global innodb_fast_shutdown=0;
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like 'innodb_fast%';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| innodb_fast_shutdown | 0     |
+----------------------+-------+
1 row in set (0.00 sec)

and then connect with Workbench 5.2.19, I see correct value, 0, in the Variables | System Variables section.

I know the 'variables' show correct but the ADmin / INNODB Paramets check box does NOT!