Re: mysql online ddl still lock
Posted by:
hua kai
Date: August 30, 2016 09:33PM
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
Subject
Views
Written By
Posted
2572
February 19, 2016 02:35AM
1574
February 19, 2016 03:09AM
1511
February 19, 2016 06:53AM
1474
February 20, 2016 01:38AM
1212
August 24, 2016 03:48AM
1074
August 25, 2016 07:40PM
Re: mysql online ddl still lock
1228
August 30, 2016 09:33PM
1189
September 01, 2016 04:55PM
1129
September 01, 2016 11:40PM
1132
September 03, 2016 05:05PM
1130
September 05, 2016 01:20AM
1194
September 05, 2016 03:54PM
1018
September 08, 2016 04:04AM
1092
September 10, 2016 12:19AM
1399
February 23, 2016 11:29PM
1789
February 29, 2016 11:32PM
1579
March 05, 2016 12:19AM
1504
March 07, 2016 03:34AM
1485
March 31, 2016 02:32AM
1433
April 02, 2016 12:39AM
1456
May 13, 2016 02:44AM
1419
May 24, 2016 09:53AM