Re: mysql online ddl still lock

[hua kai]

Hi, Rick, Here is one table schema

CREATE TABLE `zm_meeting` (
`meeting_id` varchar(36) NOT NULL,
`host_id` varchar(36) NOT NULL,
`meeting_number` bigint(10) NOT NULL ,
`status` tinyint(4) NOT NULL,
`topic` varchar(200) NOT NULL,
`password` varchar(64) DEFAULT NULL,
`agenda` varchar(2000) DEFAULT NULL,
`options` bigint(10) NOT NULL,
`type` tinyint(4) DEFAULT '0',
`created_by` tinyint(4) DEFAULT '0' ,
`start_time` datetime DEFAULT NULL ,
`end_time` datetime DEFAULT NULL ,
`schedule_time` datetime DEFAULT NULL ,
`duration` int(10) DEFAULT '0' ,
`repeat_type` tinyint(4) DEFAULT '0',
`repeat_end_time` datetime DEFAULT NULL,
`timezone` varchar(256) DEFAULT NULL ,
`minutes` int(10) DEFAULT '0' ,
`attendees` int(10) DEFAULT '0' ,
`attendees_viewonly` int(10) DEFAULT '0',
`total_minutes` int(10) DEFAULT '0' ,
`total_minutes_viewonly` int(10) DEFAULT '0',
`attendee_list` text ,
`session_list` varchar(64) DEFAULT NULL ,
`phone_id` int(10) DEFAULT NULL ,
`callin_number` varchar(256) DEFAULT NULL ,
`ping_zc` varchar(4000) DEFAULT NULL,
`host_zc` varchar(256) DEFAULT NULL,
`host_zone` varchar(64) DEFAULT NULL ,
`top_mmr` varchar(256) DEFAULT NULL,
`email_reminder` tinyint(4) DEFAULT '0' ,
`assistant_id` varchar(36) DEFAULT NULL ,
`crc_meeting` tinyint(4) DEFAULT '0' ,
`ping_bc` varchar(4000) DEFAULT NULL ,
`panelist_key` varchar(36) DEFAULT NULL,
`create_time` datetime NOT NULL,
`modify_time` datetime NOT NULL,
PRIMARY KEY (`meeting_id`),
UNIQUE KEY `meeting_number` (`meeting_number`),
KEY `start_time` (`start_time`),
KEY `modify_time` (`modify_time`),
KEY `host_zone` (`host_zone`),
KEY `top_mmr` (`top_mmr`(64)),
KEY `host_id` (`host_id`),
KEY `assistant_id` (`assistant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8