WL#5349: Change default storage engine to InnoDB
Affects: Server-5.5
—
Status: Complete
As of MySQL 5.5, the default storage engine should change from MyISAM to InnoDB.
InnoDB should be the default storage engine for all user created objects in the regular and enterprise versions of MySQL. MyISAM will remain the default engine for the embedded server. System tables will still remain in MyISAM tables InnoDB code should be mandatory in the build (except for the embedded server), so it should not be possible to exclude InnoDB support when building MySQL server. Upgrade/downgrade scenarios should not be affected by this change. If a table is MyISAM before upgrade/downgrade, it should continue to be so. The regression test suite will need to be examined and changed to ensure that MyISAM related regression tests have an explicit "engine=MyISAM" clause. Since MyISAM so far has been the default, some of these test cases may have omitted the engine clause. Change the following default values: (as per recommendations from the InnoDB team) innodb_file_format -> Barracuda (was: Antelope) innodb_strict_mode -> TRUE (was: FALSE) innodb_file_per_table -> TRUE (was: FALSE) Note: the changes to the default values were reverted back in 5.5 due to replication failures.
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.