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:
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

[20 Apr 2010 16:08] Paul Rudge
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.
[20 Apr 2010 16:43] MySQL Verification Team
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)


the above was done without any my.ini/my.cnf file.
[21 Apr 2010 14:49] Paul Rudge
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
[22 Apr 2010 7:54] Valeriy Kravchuk
This variable has value 1 by default. Check http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_fast_shutdown.
[22 Apr 2010 7:58] Valeriy Kravchuk
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.
[22 Apr 2010 13:58] Paul Rudge
I know the 'variables' show correct but the ADmin / INNODB Paramets check box does NOT!