INNODB setting in WB

[Don Giddens]

I am running MySQL 5.5.29 on Windows 2008 R2 Server. The server has a mix of MyISAM & InnoDB tables with InnoDB being the default database engine. Looking at the servers configuration settings in MySQL Workbench, I can see that the “default-storage-engine=INNODB” under the General tab. However, if I look under the INNODB tab I see an option “InnoDB” that is set to “OFF”. There is a checkbox next to this setting, but it is not selected. Possible values for this option are “ON”, “OFF” & “FORCE”.

It would appear from the startup log that InnoDB is started, but I don’t understand the purpose of the “InnoDB” option. Does this need to be enabled for InnoDB to function properly? The only thing I read about this was in regard to the “FORCE” option, which basically prevent the server from starting without InnoDB support. If I don’t want to use the FORCE option, what is the relevance of the ON/OFF setting in relationship to the “default-storage-engine” setting under the General tab?


Thanks