Re: mysql online ddl still lock

[hua kai]

table can not use online ddl:
CREATE TABLE `aa_usersns` (
`user_id` VARCHAR(36) NOT NULL,
`type` TINYINT(4) NOT NULL,
`sns_id` VARCHAR(128) DEFAULT NULL,
`sns_id2` VARCHAR(64) DEFAULT NULL,
`email` VARCHAR(256) NOT NULL,
`password` VARCHAR(64) DEFAULT NULL,
`email_verified` TINYINT(4) DEFAULT NULL,
`online_status` TINYINT(4) DEFAULT NULL,
`account_id` VARCHAR(36) NOT NULL,
`contact_hash` VARCHAR(64) DEFAULT NULL,
`client_login` TINYINT(4) NOT NULL,
`client_version` VARCHAR(50) DEFAULT NULL,
`client_uuid` VARCHAR(64) DEFAULT NULL,
`last_login_time` DATETIME DEFAULT NULL,
`login_times` INT(11) DEFAULT '0',
`domain` VARCHAR(64) DEFAULT NULL,
`create_time` DATETIME NOT NULL,
`modify_time` DATETIME NOT NULL,
PRIMARY KEY (`user_id`,`type`),
KEY `last_login_time` (`last_login_time`),
KEY `email` (`email`(255)),
KEY `account_id` (`account_id`),
KEY `domain` (`domain`),
KEY `client_version` (`client_version`),
KEY `create_time` (`create_time`)
) ENGINE=INNODB DEFAULT CHARSET=utf8


table could:
CREATE TABLE `aa_polling` (
`polling_id` varchar(36) NOT NULL DEFAULT '',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT 'Polling name',
`meeting_number` bigint(10) NOT NULL DEFAULT '0',
`creator_id` varchar(36) NOT NULL DEFAULT '',
`status` tinyint(3) NOT NULL DEFAULT '0',
`start_time` datetime DEFAULT NULL,
`end_time` datetime DEFAULT NULL,
`totalparticipant` smallint(6) DEFAULT '0',
`create_time` datetime DEFAULT NULL,
`modify_time` datetime DEFAULT NULL,
PRIMARY KEY (`polling_id`),
KEY `meeting_number` (`meeting_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8