Repository: ambari Updated Branches: refs/heads/branch-2.5 92b9df77c -> 171279a25
AMBARI-18951. Force InnoDB usage for MySQL. Fix for MySQL < 5.6. (mpapirkovskyy) Project: http://git-wip-us.apache.org/repos/asf/ambari/repo Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/171279a2 Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/171279a2 Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/171279a2 Branch: refs/heads/branch-2.5 Commit: 171279a25cf12cd1f3c13ee70e366ca0f5f4a53f Parents: 92b9df7 Author: Myroslav Papirkovskyi <[email protected]> Authored: Fri Dec 2 16:41:40 2016 +0200 Committer: Myroslav Papirkovskyi <[email protected]> Committed: Fri Dec 2 16:54:18 2016 +0200 ---------------------------------------------------------------------- .../src/main/resources/Ambari-DDL-MySQL-CREATE.sql | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ambari/blob/171279a2/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql ---------------------------------------------------------------------- diff --git a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql index b01ed2f..82ce31e 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql @@ -26,7 +26,16 @@ delimiter ; # USE @schema; -SET default_storage_engine=INNODB; +-- Set default_storage_engine to InnoDB +-- storage_engine variable should be used for versions prior to MySQL 5.6 +set @version_short = substring_index(@@version, '.', 2); +set @major = cast(substring_index(@version_short, '.', 1) as SIGNED); +set @minor = cast(substring_index(@version_short, '.', -1) as SIGNED); +set @engine_stmt = IF(@major >= 5 AND @minor>=6, 'SET default_storage_engine=INNODB', 'SET storage_engine=INNODB'); +prepare statement from @engine_stmt; +execute statement; +DEALLOCATE PREPARE statement; + CREATE TABLE stack( stack_id BIGINT NOT NULL,
