Bug #51278 WB doesn't support the InnoDB loose_* variables
Submitted: 18 Feb 2010 9:38 Modified: 4 Apr 2014 10:56
Reporter: Giuseppe Maxia Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S2 (Serious)
Version:5.2.16 OS:Any
Assigned to: CPU Architecture:Any
Tags: innodb, loose, plugin, variables, workbench

[18 Feb 2010 9:38] Giuseppe Maxia
Description:
Using WB with the Innodb plugin enabled, I used the "loose_*" format of the variables, as recommended by the documentation to avoid possible conflicts before the plugin is loaded.
The server works as expected, but WB does not recognize the "loose_*" variables.

How to repeat:
(1) Add the following to the option file of MySQL 5.1.45

ignore-builtin-innodb
loose_innodb_file_per_table=1 
loose_innodb_file_format=barracuda
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so

(2) within WB, inspect "Configuration/InnoDB parameters/One file per table"
  and "Configuration/Misc/innodb file format". The variables were not recognized.

(3) Check in "Variables/System Variables": the server reports the "loose_*" variables (without prefix) as they were set in the option file.

Suggested fix:
Make WB accept the "loose_*" variables as the un-prefixed ones
[18 Feb 2010 12:03] Susanne Ebrecht
Many thanks for writing a feature request.
[18 Feb 2010 13:20] Giuseppe Maxia
This is NOT a feature request.

The loose_* parameters are necessary when using the InnoDB plugin in 5.1.x, as stated in 
http://www.innodb.com/doc/innodb_plugin-1.0/innodb-plugin-installation.html
and 
http://dev.mysql.com/doc/refman/5.1/en/install-plugin.html
So, the impact of this issue is much higher than you may think.
[4 Apr 2014 10:56] Alfredo Kojima
Since InnoDB is now built-in, this would be no longer applicable in recent server versions.