Bug #74753 Error log incorrectly states --skip-innodb is deprecated when using innodb=OFF
Submitted: 9 Nov 2014 2:06 Modified: 13 Nov 2014 13:14
Reporter: Chris Calender Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Logging Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Daniel Price CPU Architecture:Any

[9 Nov 2014 2:06] Chris Calender 
Description:
If you disable InnoDB (tested in MySQL 5.6.21) using the "innodb=OFF" option, as per the manual's instructions:

http://dev.mysql.com/doc/refman/5.6/en/innodb-turning-off.html

If you set that option, and start mysqld, you will see this message logged to the error log:

"2014-11-08 21:03:46 24132 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release"

How to repeat:
Use MySQL 5.6.21.

Disable InnoDB altogether using:

default-storage-engine=MyISAM
default-tmp-storage-engine=MyISAM
innodb=OFF

Restart mysqld.

Check error log.  You will see this warning, which seems irrelevant:

"2014-11-08 21:03:46 24132 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release"

Suggested fix:
Do not log this warning when using the "innodb=OFF" option, as the manual suggests.
[9 Nov 2014 3:54] Chris Calender 
Changed to S3 from S4.
[9 Nov 2014 9:22] MySQL Verification Team 
Hello Chris,

Thank you for the report.

Thanks,
Umesh
[9 Nov 2014 9:23] MySQL Verification Team 
// 5.6.23

2014-11-11 16:18:53 2182 [Warning] The option innodb (skip-innodb) is deprecated and will be removed in a future release
2014-11-11 16:18:53 2182 [Note] Plugin 'InnoDB' is disabled.
[13 Nov 2014 13:14] Daniel Price 
Posted by developer:
 
The error message is correct. 

As of MySQL 5.6.21, the "--skip-innodb" 
option still works but is deprecated and will return a warning if used. 
It will be removed in a future MySQL release. This also applies to its 
synonyms ("--innodb=OFF", "--disable-innodb", and so forth).

The documentation has been updated. The revised content should appear within
24-hours.

http://dev.mysql.com/doc/refman/5.6/en/innodb-turning-off.html

Thank you for the bug report.