Bug #61535 ignore-builtin-innodb not well defined for 5.5
Submitted: 16 Jun 2011 12:46 Modified: 17 Jun 2011 9:24
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any

[16 Jun 2011 12:46] Laurynas Biveinis
In 5.5, the server silently accepts the ignore-builtin-innodb option and loads InnoDB engine. The option is meaningless there is no builtin InnoDB in 5.5.  If the option is for backward compatibility only, then its docs are outdated as the server does nothing in the description.

And grepping the latest 5.5 trunk shows that opt_ignore_builtin_innodb is still being checked in sql_plugin.cc, probably dead code.

How to repeat:
Add ignore-builtin-innodb to my.cnf, check SHOW ENGINES output.

Suggested fix:
Document that option is meaningless for 5.5, remove dead code related to it.
[16 Jun 2011 13:17] Valeriy Kravchuk
I do not see this with current 5.5.14:

macbook-pro:5.5 openxs$ bin/mysqld_safe --ignore-builtin-innodb &
[1] 98757
macbook-pro:5.5 openxs$ 110616 16:15:44 mysqld_safe Logging to '/Users/openxs/dbs/5.5/data/macbook-pro.err'.
chown: /Users/openxs/dbs/5.5/data/macbook-pro.err: Operation not permitted
110616 16:15:44 mysqld_safe Starting mysqld daemon with databases from /Users/openxs/dbs/5.5/data
110616 16:15:44 mysqld_safe mysqld from pid file /Users/openxs/dbs/5.5/data/macbook-pro.pid ended

[1]+  Done                    bin/mysqld_safe --ignore-builtin-innodb
macbook-pro:5.5 openxs$ tail data/macbook-pro.err 
110616 16:15:44 [Warning] One can only use the --user switch if running as root

110616 16:15:44 [Note] Plugin 'FEDERATED' is disabled.
110616 16:15:44 [ERROR] Unknown/unsupported storage engine: InnoDB
110616 16:15:44 [ERROR] Aborting

110616 16:15:44 [Note] unregister_replicator OK
110616 16:15:44 [Note] /Users/openxs/dbs/5.5/bin/mysqld: Shutdown complete

110616 16:15:44 mysqld_safe mysqld from pid file /Users/openxs/dbs/5.5/data/macbook-pro.pid ended

So, it is not ignored and works as described at http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#option_mysqld_ignore-builtin...

What exact version, 5.5.x, do you use?
[17 Jun 2011 9:19] Laurynas Biveinis
Valeryi -

I can confirm your findings, apparently the initial testing was with user error on my part.

Sorry about that.