We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine.
However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF is selected in the drop down. I don't see this line added to the my.ini file when viewing with notepad.
Should I check this setting and set it to ON so we can utilize the enabled innodb settings (buffers & log file etc.) or does this not matter?
Best Answer
Innodb is the default storage engine, and it is loaded by default. I would consider this a flaw in MySQL Workbench. You can read more about the --innodb (and --skip-innodb) option here:
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#option_mysqld_innodb
Notice that if you disable innodb, MySQL won't even start unless you specify a different default storage engine as well.