mysql5.6在线ddl_mysql5.6 online ddl—索引

尝试对mysiam表(1500万)删除索引失败

#uk表字段类型比较简单，都是int/tinyint/timestamp类型。

CREATE TABLE `uk` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`a` int(11) NOT NULL DEFAULT '0',

`b` int(11) NOT NULL,

`c` int(11) NOT NULL DEFAULT '0',

`d` int(11) NOT NULL DEFAULT '0',

`e` int(11) DEFAULT '0',

`f` tinyint(4) NOT NULL DEFAULT '1',

`l` timestamp NOT NULL DEFAULT ‘0’ ,

PRIMARY KEY (`id`),

UNIQUE KEY `idx_a_b_c` (`a`,`b`,`c`),

KEY `idx_f` (`f`)

) ENGINE=MyISAM AUTO_INCREMENT=15000000 DEFAULT CHARSET=utf8;

#尝试允许并发删除索引

alter table uk drop index idx_a_b_c , ALGORITHM=INPLACE/LOCK=NONE;

ERROR 1845 (0A000): ALGORITHM=INPLACE is not suppor